SSG Blog
Insights and news from the SQL Solutions Group.
Recent
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
A new MVP on the team: TJay Belt recognized by Microsoft
Last week we recognized Jason Brimhall for being named a SQL Server MVP. This week, it’s TJay Belt‘s turn. TJay is the third SSG consultant