Adventures with NOLOCK

Some of the beauty of being a database professional is the opportunity to deal with our friend NOLOCK.  For one reason or another this query directive (yes I am calling it a directive* and not a […]

Extended Events, Birkenstocks and SQL Server

I bring you yet another installment in the monthly meme called T-SQL Tuesday.  This is the 67th edition, and this time we have been given the opportunity to talk about something I really enjoy – […]

Database In Recovery Update

Many moons ago, I published a post that contained a script to aid in easing the anxiety that comes when a database is “In Recovery”. When I pulled that script out to try and use […]

Monitoring SQL Server

Welcome to the fabulous world of blog parties, SQL Server and what has been the longest running SQL Server related meme in the blogosphere – TSQLTuesday. This month we are hosted by Catherine Wilhemsen (blog […]

Extended Events and Data Types

Today is another one of those installments in the long-running TSQL Party held monthly (a.k.a TSQL2SDAY). This month we have an open invitation from Mike Donnelly (blog | twitter), asking us to talk about something new […]