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
Tag: SQL Script
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
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
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
Capture the Flag – Trace Flags
One of the things that would be nice to know is around the trace flags that can be enabled in
November 11, 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