SQL Servers Black Box Recorder – Def Trace

Across many professions and industries there is often a need to have some sort of device that “audits” everything that...

SQL Servers Black Box Recorder – Def Trace

Very much like what you may find with the airline industry, the black box recorder in SQL Server is not just a single method (device) implemented to capture all of...

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...

How to: File Target use in Extended Events

Using a file target is not difficult from a creation point of view (event session creation). But, some basics are critical or you could end up with fewer follicles.
Related...

Upgrading From SQL Server Profiler

I just shared an article describing how to use Extended Events to perform your SQL Server Profiler duties. If not,...

Upgrading From SQL Server Profiler

How to correlate all of your favorite trace/profiler options into the shiny new XE equivalents.

As luck would have it, there is a means to correlate trace/profiler events to Extended...

How To: XEvents as Profiler

A common excuse for not delving into extended events seems to be the jump from Profiler to extended events.  There...

How To: XEvents as Profiler

Despite the controls in place there always seems to be some change that is unknown or even some cowboy that makes changes as s/he sees fit and forgets to...

Quick and Easy XE for Azure DB

The Cloud
It has been a minute since I gave much love or attention to Extended Events in Azure SQL DB....

Quick and Easy XE for Azure DB

This is a very simple introduction into the creation of an Extended Event session using a template for Azure SQL DB. I demonstrate the use of the GUI to...