SQL PASS 2019 – Session Feedback – Elementary! The Curious Case of Deceptive Query Optimizer
Earlier this year, I presented a technical session on SQL Server Performance Tuning at SQL PASS 2019 at Seattle. Let us see the session feedback of Elementary! The Curious Case of Deceptive Query Optimizer. I have built this entire session from my expe …
UNION vs. UNION ALL in SQL Server
The post UNION vs. UNION ALL in SQL Server appeared first on SQLServerCentral.
Migrating Column Level Encryption from 2008R2 to Azure SQL Database
Background My team have been exploring the possibility of migrating our on-premise SQL servers to Azure SQL Database. Most of the time we were able to carry out proof of concept migrations using Azure Data Migration Assistant successfully but we had to …
SQL Server Diagnostic Information Queries for December 2019
This month, I have done more minor improvements, especially for SQL Server 2019.I have a T-SQL script that you can use to check whether your instance of SQL Server has been patched to mitigate against the Spectre/Meltdown CPU vulnerability. This works …
What Should We Change About This Year’s Data Professional Salary Survey?
Every year, we run a Data Professional Salary Survey here. Thousands of y’all have answered – here are the past results in Excel – and it helps everybody get a better idea of how overpaid they are. (Did I word that right?) Here are th …
SQL SERVER – Extended Event to Capture Memory Grant Feedback
It has been over 3 weeks since SQL Server 2019 launched and after reading my recent blog posts about the Memory Grant Feedback, I was approached by one of the leading banks in Europe to help them build an efficient architecture and performance-optimize …
Glenn’s Tech Insights For December 3, 2019
(Glenn’s Tech Insights… used to be part of our bi-weekly newsletter but we decided to make it a regular blog post instead so it can get more visibility. It covers new hardware and software developments that are generally relevant for SQL S …
Storage 101: Welcome to the Wonderful World of Storage
The series so far: Storage 101: Welcome to the Wonderful World of Storage Gone are the days when implementing storage was simply a matter of standing up a few disk drives. Today’s data-intensive workloads require a variety of storage solutions to …
Do You Have REFERENCES?
The late Jim Gray once said that in the early days of SQL, “We had no idea what we were doing!” However, that is not completely true. What we were doing was mimicking the technologies that had gone before. The first SQL engines put each tab …
Updated First Responder Kit and Consultant Toolkit for December 2019
It’s the hap-happiest season of all. To get the new version: Download the updated FirstResponderKit.zip Azure Data Studio users with the First Responder Kit extension: ctrl/command+shift+p, First Responder Kit: Import. Download the updated Consul …
SQL SERVER Tools I Use and Recommend (Updated: December 2019)
One of the most popular questions I often receive during Comprehensive Database Performance Health Check is which are the third-party tools I use in my daily routine and I recommend them. Here is the updated list for December 2019 of all the tools whic …
It’s More Than What You Know
I’m a firm believer in keeping your tech skills up to date, as well as your social skills, What better way than attending or presenting at a conference or group meeting. The reason to attend an event I’m very fortunate that my company allows me trainin …
SQL Database Project Code Branching in Git
The post SQL Database Project Code Branching in Git appeared first on SQLServerCentral.
SQL Server PDB Symbols and Callstacks The Easy Way
Lately, I have been doing a lot of work troubleshooting certain behaviors in SQL Server for workloads that are, to put it simply, designed horribly. As a part of this, I have found it necessary to collect callstacks with Extended Events and to material …
SQL ConstantCare® Population Report: Fall 2019
Our SQL ConstantCare® service lets users send data in about their SQL Servers and get health & performance advice via email. Users can opt in to share their anonymized data to get better recommendations overall. With 3,568 database servers shar …