-
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 capturing a change history for specific data – which is something we might be thinking about a bit more now the GDPR is heading our way. It’s pretty straightforward to set up, and can be Read more
-
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 databases. Many of you out there will already have full-scale auditing solutions in place. For others though, the prompting of GDPR could be the first time you’re really thinking about it. This post is a Read more
-
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 one of them to avoid the issue. Job done. Occasionally you see a deadlock that has three nodes. Okay, a little bit more analysis and head scratching before the solution presents itself What if you Read more
-
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 many little enhancements the SQL team implements to make the product better and easier to use. I’d barely published my post about Automatic Sample Sizes for Statistics Updates when I saw that Microsoft had enhanced the Read more
-
Viewing the Statistics Objects Used to Create an Execution Plan
Use trace flag 8666 to view the statistics objects that the optimizer used to generate your execution plan. Read more
-
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 2: Eight Queens Given the standard 8×8 chessboard, place an equal number of Knights and Queens such that no piece is attacked by another. What’s the maximum number of Knights and Queen’s you Read more
