SSG Blog
Insights and news from the SQL Solutions Group.
Recent
What Sessions are Deployed?
As a DBA, it is not uncommon to feel like you are marooned off on some tiny little island trying to figure things out for
Participation Trophies: Is Showing Up Enough?
As you may have heard, Pittsburgh Steelers linebacker James Harrison recently decided to not allow his sons to keep participation trophies they had received from,
An Experiment with Deadlocks
Everything can be fixed with a query hint (*cough* directive), right? If a certain process is consistently causing deadlocks, a simple ROWLOCK hint can be added
Defaults In msdb Database
Today is a day to discuss defaults. It started with the day being TSQL Tuesday and having a topic of “Say No to Defaults.” You
XE Output: Weaning yourself off of SQL Profiler, Part 2
In my last post, I shared a script that will take a running trace and show you the XE events that it relates to, and
Check for Errors First, Part III: The Windows Event Logs
In Part I of Check for Errors First, we discovered how to query the error logs, and filter out the noise to find meaningful errors that