Backing up to NUL:

December 31, 2017 Andy 0

Linux folks have lots of jokes & fun t-shirts about /dev/null/. The null device is a handy location to dump output to, when you don’t actually care about the output. In PowerShell, you can use Out-Null to dump extra output into the ether, and keep … [Read More]

Interviewed by Mohammad Darab

December 20, 2017 Andy 0

As part of Mohammad’s series of interviews, he interviewed me on my thoughts on the future of SQL Server, the DBA role, and the cloud. Read the interview on Mohammad’s site.

Alerting on SQL Server Blocking

December 18, 2017 Andy 20

Identifying blocking is one of the most basic things that a DBA should be monitoring for. I previously wrote about how to identify blocking in SQL Server and find the leading blocker. Recently, my friend Jim Donahoe (blog | twitter) asked me about setting up … [Read More]