The diagnostics process will trap various server related health (diagnostics) information related to the SQL Server instance in an effort to try and detect potential failures and errors.
SQLs Black Box Recorder – sp_server_diagnostics
Category: News
SQL Servers Black Box Recorder – system_health
In this article, the focus will be directed to the next leg of the black box recorder – or the system_health Extended Event Session.
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 the desired data points.
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.
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 Event events (yeah that sounds weird). With the release of SQL Server 2012, Microsoft introduced a couple of catalog views to help with this correlation effort.
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 notify people or follow process.
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 configure the session quickly and then to subsequently script that configuration before creating the session.
File Maintenance – Cleaning Up Old Files
We have all run into a need or a desire to clean up old stale files from the file system, whether it be to remove old backup files or flat files that are created from one process or another. And based on this need/desire, we have all come up with a method to help with achieve that goal.
Encrypting a Database Never Finishes
There is plenty of legislation and regulation in place these days that strongly suggest the encryption of data within a database. In SQL Server, we have the ability to comply with these regulations in a couple of different ways. This article will discuss one method for encryption.
T-SQL Tuesday Participation Over the Years
I have personally participated in quite a large number of these TSQL Tuesday events – despite not being every single one. This is a roundup of my personal participation across the years.