Execution Plans in Extended Events

Extended Events is a wonderful tool. Execution Plans are also some wonderful things – or are a wonderful tool as well. Both of these tools are fantastic for troubleshooting. Combined,...

Execution Plans in Extended Events

Extended Events is a wonderful tool. Execution Plans are also some wonderful things – or are a wonderful tool as well. Both...

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

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

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

Database In Recovery Update

Many moons ago, I published a post that contained a script to aid in easing the anxiety that comes when...

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

Monitoring SQL Server

Welcome to the fabulous world of blog parties, SQL Server and what has been the longest running SQL Server related...

Pages I

Audit who Dropped the Database

In the first article on this topic (which can be read here), I discussed the problem of having a database...