SSG Blog
Insights and news from the SQL Solutions Group.
Recent
Persisting DBCC output data
Most of the DBCC commands return their results as textual output, even if you have SSMS configured to return result sets to a grid. This
Auditing when Database Files Change
As a Database Administrator, something that should be part of your database audit is monitoring the growth of files. That means tracking when the log
Capture the Flag – Trace Flags
One of the things that would be nice to know is around the trace flags that can be enabled in SQL Server. There are trace
What the FK? Your Foreign Keys May Not Be Performing Like They Should
Query Optimizer Tips and Tricks Part 2 This is the second installment in a continuing series of articles on things to look for and
Dodging Phantom Reads
October… the month of Halloween. Spooky events. SQL Server has all kinds of Halloween-ish themed activities like Split Brains, Zombies, Ghosts, Phantoms, and of course
Database Ghost Records
Yes Virginia, there are ghosts in your database. More specifically, there are SQL Server database ghost records. They are not there to haunt you. They