SSG Blog
Insights and news from the SQL Solutions Group.
Recent
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,
Orbit Irrigation: “I feel 100% confident when working with SSG that they will resolve any issue we face.”
Orbit Irrigation
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