SSG Blog
Insights and news from the SQL Solutions Group.
Recent
SSMS: The SQL Server Solution Project
There is a great feature in SQL Server Management Studio that I do not see used very often, and that feature is the SQL Server
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
