SSG Blog
Insights and news from the SQL Solutions Group.
Recent

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

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,

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

The Interview Trick Question
Today, I am diverging from the more technical posts that I routinely share. Instead, as the title suggests, I want to dive into a something

Quick Permissions Audit
Whether it is for a client, an audit, or just for good housekeeping, DBAs will often need to figure out who has access to what.

Fight The Weeds
Spring time means tuning up the lawn mower, digging out the pruning shears, and testing the sprinklers (at least in Utah, where we can’t rely

