SSG Blog
Insights and news from the SQL Solutions Group.
Featured
When testing code, it’s critical to have enough robust data. This often requires removing personally identifiable information. Find out how!
Recent
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
July 15, 2015
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
July 8, 2015
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
June 24, 2015
Weaning yourself off of SQL Profiler (Part 1)
In this brave, new world of Extended Events (XE, XEvents), I find myself with a mixture of scripts for troubleshooting issues – some use XE,
June 9, 2015
SHUTDOWN SQL Server
Recently a friend by the name of Chris Bell (blog | twitter) wrote about an easy way to disrupt SQL Server. That disruption comes in
June 3, 2015
Northwestern Management: “We haven’t had any other issues with performance, which translates into revenue”
Northwestern Management
June 3, 2015