Persist Sample Percent in SQL Server IS NOT PERSISTED!

Update: Sept 14, 2021 Persist sample percent is fixed. The fix is now rolled into SQL 2016 SP2 CU17, SQL 2019 CU10, and the future SQL 2017 CU26. When a bug...

Unconscious Bias

This article helps to unearth a cultural issue that each individual needs to address on a personal level. Bias is an enemy to productive conversation.
Related Posts:

Note to Self June...

Azure DP-900 (Data Fundamental) Certification perpetration

Nothing Is hard when you decide to do it, from two weeks I earned my Certification of Azure Data Engineer and today I passed Exam DP-900 and I got...

Azure DP-900 (Data Fundamental) Certification perpetration

Nothing Is hard when you decide to do it, from two weeks I earned my Certification of Azure Data Engineer and today I passed Exam DP-900 and I got...

3D Printing Ear Savers Aug 6th 2020

I have now printed over 20,000 ear savers. I hit 20k printed yesterday on Aug 5th, exactly 4 months after starting this project. As of 7PM Eastern today, my...

Daily Coping 21 Aug 2020

I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...

Down Tools Week 2020 (10 minute video/podcast episode)

In this episode of Dear SQL DBA, I talk about how Redgate runs "Down Tools Week," what I'm working on as part of the project, and how this has...

Daily Coping 20 Aug 2020

I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...

Extended Events Gets a New Home

One of the most versatile and awesome power tools given to SQL Server now has a new home! This new home will serve as a fabulous repository of extensive...

Find All Heaps In Your Database

This is just going to be a quick post but I was asked the question the other day, how can I find all the tables in the database that...