SSG Blog
Insights and news from the SQL Solutions Group.
Recent
T-SQL Tuesday #61–Giving Back
The topic for this month’s T-SQL Tuesday (Giving Back to the SQL Server Community) is one that is near and dear to me so I
‘Twas the night before the upgrade…
‘Twas the night before the upgrade, when all through the place Not a backup was working, “there’s not enough disk space”; The software was compiled

An Extended Events Trifecta
When working with Extended Events, there are times when a little more information is, well, helpful. You know you want to use extended events to
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