Execution Plan Shortcoming in Extended Events

I use Extended Events almost exclusively for capturing query metrics. They are the most consistent and lowest cost mechanism for...

Privacy and Protection, By Design

With all the noise about the upcoming enforcement of GDPR, I know that people are starting to focus more on...

GDPR, Database Backups, and the Right to be Forgotten

I’ve said it before, but it bears repeating, there is no cause for any kind of panic when it comes...

Buggy Whips 2.0

I recently found myself rereading a very old blog post of mine, from the very beginning of this blog, discussing...

YouTube Channel Update: March 30, 2018

Hey everyone!
Here’s the latest stuff on my new YouTube Channel. Please let me know if these videos are helpful. Also,...

Query Store and Automated Cleanup

Query Store has mechanisms for automatically cleaning your data. It is possible to cause them to break down. While presenting...

Query Monitoring and the GDPR

I’ve been reading the General Data Protection Regulation (GDPR) and discussing the ramifications of the beginning of enforcement with lots...

Execution Plans and the GDPR

What? Execution plans and the GDPR? Is this it? Have I completely lost it? Well, no, not on this topic,...

Every Single Execution Plan is an Estimated Plan

All the execution plans are estimated plans. All of them. There fundamentally isn’t any such thing as an “Actual” plan.

Where...

YouTube Channel Update

Hey! Here’s the latest on my YouTube Channel. Click on through and subscribe. I’ll be doing lots of stuff on...