What Sessions are Deployed?
As a DBA, it is not uncommon to feel like you are marooned off on some tiny little island trying
September 1, 2015
Author: Jason Brimhall
SHUTDOWN SQL Server
Recently a friend by the name of Chris Bell (blog | twitter) wrote about an easy way to disrupt SQL
June 3, 2015
The Interview Trick Question
Today, I am diverging from the more technical posts that I routinely share. Instead, as the title suggests, I want
May 21, 2015
Quick Permissions Audit
Whether it is for a client, an audit, or just for good housekeeping, DBAs will often need to figure out
May 13, 2015
How To: XEvents as Profiler
A common excuse for not delving into extended events seems to be the jump from Profiler to extended events (aka
March 11, 2015
How to: File Target use in Extended Events
I have been doing a lot of posts of late about extended events but have failed to share some of
February 17, 2015
An Extended Events Trifecta
When working with Extended Events, there are times when a little more information is, well, helpful. You know you want
December 2, 2014
Database Ghost Records
Yes Virginia, there are ghosts in your database. More specifically, there are SQL Server database ghost records. They are not
October 15, 2014
Encrypting a Database Never Finishes
There is plenty of legislation and regulation in place these days that strongly suggest encrypting a database. In SQL Server,
September 2, 2014
Missing Indexes Script v2
Frequently we hear the analogy that <insert item here> are like opinions, everybody has one and not all of them
June 15, 2014