sp_server_diagnostics – Black Box Recorder
A few months back I began a series about the SQL Black Box Recorder, that you can read here, with
July 26, 2016
Tag: XE
SQL Black Box Recorder part II
A few months back I began a series, about the SQL Black Box Recorder that you can read here, with
April 6, 2016
Freakin’ out on XE at the FreeCon
Just a couple weeks ago I announced that SQL Solutions Group was getting ready to host a day of free training—a
September 29, 2015
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
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
June 9, 2015
Upgrading From SQL Server Profiler
You may recall an article I had written a couple months back describing how to use Extended Events to perform
April 22, 2015
Where did the Database Go?
What do you do when a developer comes to you and asks, “Where did the database go? The database was
April 7, 2015
Auditing when Database Files Change
As a Database Administrator, something that should be part of your database audit is monitoring the growth of files. That
November 20, 2014