What do you do when your monitoring system fails? Ah! An age old problem. [...Read More]

What's In Your SQL Server Library? Are your fingerprints in there anywhere? [...Read More]

Putting it all together: using Extended Events to overcome some TRY...CATCH limitations in T-SQL. [...Read More]

Using Extended Events to overcome some TRY...CATCH limitations in T-SQL.

[...Read More]

TRY...CATCH hasn't lived up to the promise of what it should be. If a fundamental part of our programming language doesn't work, what are we to do? [...Read More]

Some code samples showing how to use linked servers with dynamic TSQL to meet some of your administrative needs. [...Read More]

For my use case as a database administrator, I try to explain why the arguments against linked servers are bad ones. [...Read More]

Software vendors aren't following the Principle of Least Privilege for SQL Server authorization. Can we be the catalyst for change? [...Read More]

A recent discovery (sys.database_recovery_status) has helped me fix a couple of SQL Server backup issues. [...Read More]

Be responsible when you configure SQL Server Alerts: SPAM, Alert responses, and other considerations. [...Read More]