Auditing Data Access in SQL Server for GDPR Compliance
In relation to the GDPR, I’ve recently been looking at the tools available within SQL Server to support auditing our...
2017-10-05 (first published: 2017-09-26)
5,809 reads
Matthew McGiffen
- Twitter: @MattMcGiffen
- Website: https://matthewmcgiffen.com/
Setting up Change Data Capture (CDC)
As mentioned in my post Auditing Data Access in SQL Server for GDPR Compliance CDC can be a useful tool for...
2017-10-03
17,635 reads
When Deadlocks Become Art
We’ve all had to solve deadlock issues. Identify the two conflicting pieces of code, work out an appropriate change to...
2017-09-19
701 reads
Setting the Sample Rate for Auto Stats updates
SQL Server functionality can move on pretty quickly sometimes, and it’s not always all about the big features but the...
2017-09-12
2,305 reads
SQL Puzzle 3: Knights and Queens
I thought I’d do another chess puzzle this month. This one is a variant on the Eight Queens problem:
SQL Puzzle...
2017-09-01 (first published: 2017-08-22)
2,342 reads
Viewing the Statistics Objects Used to Create an Execution Plan
A while ago now I was running some Performance Tuning workshops and was asked how you can find out which Statistics...
2017-09-01
416 reads
Automatic Sample Sizes for Statistics Updates
I mentioned in my previous post about manually updating statistics that you can specify whether they’re updated using a full...
2017-08-23 (first published: 2017-08-15)
1,496 reads
Statistics and the Ascending Key Problem
I’ve mentioned previously how not having up to date statistics can cause problems in query performance. This post looks at...
2017-08-09 (first published: 2017-07-25)
7,680 reads
How to be a bad interviewer
In the monthly SQL blogging party that is T-SQL Tuesday (brainchild of Adam Machanic), Kendra Little has invited us this...
2017-08-08
1,428 reads
SQL Server Agent and Daylight Saving time
There was a bit of chat today on the SQL Community slack about UTC and Daylight Saving Time. It reminded...
2017-08-07 (first published: 2017-07-19)
2,548 reads
Blogs
SQL Server sa Account Security: Rename, Disable & Best Practices
By SQLPals
SQL Server sa Account Security: Rename, Disable & Best Practices In...
Stanford Emerging Technology Review 2026 Report is out
By Brian Kelley
Artificial Intelligence and quantum computing are two areas of emerging technology that receive most...
How I Troubleshoot a Slow SQL Server Live
No two SQL Server environments are alike. A fix that resolves a performance issue...
Forums
Are You Working More Hours?
Comments posted to this topic are about the item Are You Working More Hours?
Stairway to Reliable Database Deployments Level 6 – Managing Changesets Over Time
Comments posted to this topic are about the item Stairway to Reliable Database Deployments...
A Limited Startup
Comments posted to this topic are about the item A Limited Startup
Question of the Day
A Limited Startup
I add this parameter to SQL Server 2025 in the Configuration Manager:
-mDynamicsWhat does this do? See possible answers