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...
2018-04-26 (first published: 2018-04-16)
1,705 reads
The Scary DBA
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...
2018-04-11
448 reads
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...
2018-04-20 (first published: 2018-04-09)
3,446 reads
Buggy Whips 2.0
I recently found myself rereading a very old blog post of mine, from the very beginning of this blog, discussing...
2018-04-02
281 reads
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,...
2018-03-30
391 reads
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...
2018-03-26
604 reads
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...
2018-03-28 (first published: 2018-03-19)
2,778 reads
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,...
2018-03-12
844 reads
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...
2018-03-14 (first published: 2018-03-05)
1,823 reads
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...
2018-03-02
317 reads
Blogs
New article – migrating from a named instance
By Brian Kelley
Do you have a case where you have a named instance you'd like to...
Using the SIGN() Function: #SQLNewBlogger
By Steve Jones
I was trolling the docs and noticed the SIGN() function. I have never written...
T-SQL Tuesday #201 Round-Up: Temp Tables, Friend or Foe?
By ReviewMyDB
The T-SQL Tuesday #201 round-up: nine bloggers on whether temp tables are a friend...
Forums
Admin Rights for Everyone
Comments posted to this topic are about the item Admin Rights for Everyone
Kerberos Authentication for Aurora PostgreSQL: Mapping AD Groups to Database Roles
Comments posted to this topic are about the item Kerberos Authentication for Aurora PostgreSQL:...
RegEx Functions I
Comments posted to this topic are about the item RegEx Functions I
Question of the Day
RegEx Functions I
Which of these RegEx functions need compatibility level 170 in SQL Server 2025?
See possible answers