Sites anglophones


Registration Open for SQL Saturday Helsinki Workshop 2019

Publié le 3 avril 2019 sur journey to sqlauthority
 

I am super excited that I will be visiting Helsinki SQLSaturday 2019. I will be delivering a day-long post-conference on my most popular workshop – Practical Real-World SQL Server Performance for Everyone. Practical Real-World SQL Server Performa …

Automating Builds from Source Control for the WideWorldImporters Database

Publié le 3 avril 2019 sur sqlservercentral.com
 

The post Automating Builds from Source Control for the WideWorldImporters Database appeared first on SQLServerCentral.

The Curious Case of… the CLR assembly failure after an AG failover

Publié le 2 avril 2019 sur sqlskills.com - paul randall
 

(The Curious Case of… used to be part of our bi-weekly newsletter but we decided to make it a regular blog post instead so it can sometimes be more frequent. It covers something interesting one of us encountered when working …

Building a SQL Server app? Start with Azure SQL DB.

Publié le 2 avril 2019 sur brentozar.com
 

No no, April Fool’s was yesterday. Hear me out. Azure SQL DB’s feature limitations are a good thing. It doesn’t support everything that SQL Server supports, like CLR, cross-database transactions, database mail, linked servers, and OPE …

SQL SERVER – A Brief History of Deadlock and Modern Approach of Resolution

Publié le 2 avril 2019 sur journey to sqlauthority
 

Every time we talk about deadlock, you will see DBA frowning on this topic. DBA believes that Developers are creating the deadlocks and developers believe that DBA’s should be taking care of the deadlocks. Essentially, it is such a subject which …

Enforce SSL for connecting to AWS RDS Instance of SQL Server

Publié le 2 avril 2019 sur sqlservercentral.com
 

The post Enforce SSL for connecting to AWS RDS Instance of SQL Server appeared first on SQLServerCentral.

Security Considerations for ERP Applications

Publié le 1 avril 2019 sur simple-talk.com
 

Did you know? eBay suffered a serious security breach in 2014 that led all 145m customers to change passwords to secure their accounts. According to research performed by the Ponemon Institute, the average cost for a breach of sensitive data in 2018 is …

Registration Open for SQL Saturday Stockholm Workshop 2019

Publié le 1 avril 2019 sur journey to sqlauthority
 

I am super excited that I will be visiting Stockholm SQLSaturday 2019. I will be delivering a day-long pre-conference on my most popular workshop – 21 Essential Scripts: Performance Tuning for EVERYONE. 21 Essential Scripts: Performance Tuning fo …

Customizing Statistics Histogram in SQL Server 2019

Publié le 1 avril 2019 sur sqlservercentral.com
 

The post Customizing Statistics Histogram in SQL Server 2019 appeared first on SQLServerCentral.

SQL Server 2019 Adds CosmosDB Support

Publié le 1 avril 2019 sur sqlservercentral.com
 

SQL Server 2019 is already looking to be one of the major releases of the platform with quite a few enhancements. The addition of Big Data Clusters, Accelerated Database Recovery, and Java programmability, many organizations will be considering the mov …

How to Limit Output of Varchar(max), Nvarchar(max) in SELECT Statement? – Interview Question of the Week #218

Publié le 31 mars 2019 sur journey to sqlauthority
 

Question: How to Limit Output of Varchar(max), Nvarchar(max) in SELECT Statement? Answer: I must admit, I had to do search the internet for this answer. I had no idea how to answer this question. I was initially asked this question during the Comprehen …

Consulting Wrap Up – What Next and How to Get Started

Publié le 30 mars 2019 sur journey to sqlauthority
 

This is the wrap up post of my 5 part series on my over 10 years of experience in Comprehensive Database Performance Health Check consulting engagement. Here are the five blog posts which are the essence of my consulting business. You can also call it …

Consulting 105 – Why Don’t I Want My Customers to Return for the Same Problem? – SQL Server Performance Tuning

Publié le 29 mars 2019 sur journey to sqlauthority
 

This is the fifth of my 5 part series on my over 10 years of experience in Comprehensive Database Performance Health Check consulting engagement. Here are the five blog posts which are the essence of my consulting business. You can also call it my busi …

SQLServerCentral v3 coming tomorrow

Publié le 29 mars 2019 sur sqlservercentral.com
 

SQLServerCentral v3 Coming Tomorrow, Mar 30. We will release the next version of SQLServerCentral, tomorrow, March 20, 2019. There will be a brief period of downtime in the morning (9-10am UTC) as we perform a final incremental database migration of ch …

Getting Started with Azure Data Studio and SQL Server 2019 Preview

Publié le 28 mars 2019 sur sqlmag.com
 

SQL Server 2019 is in the final rounds of Community Technology Previews, and if I wasn’t excited about it before, I definitely am now.


Pages :