Trying out Microsoft Azure Blob Storage for SQL Server backup and restore. [...Read More]

A SQL Server chicken-and-egg problem with restoring an encrypted backup of [master]? [...Read More]

Restoring a SQL Server database backup can be a bad idea. I'll explain why, and present some alternatives. [...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]

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

Notes from my experience with a Team Foundation Server migration. [...Read More]

Save yourself some time and effort. Let t-sql generate RESTORE DATABASE commands for you. [...Read More]

3rd-party tools for backing up SQL Server just don't cut it. Here's why. [...Read More]

They usually do little more than leverage existing functionality that is native to SQL Server, wrapped in a GUI, and marketed as a sparkly unicorn that no one else has discovered. [...Read More]

The hacking of AshleyMadison.com should be an warning to us all. But not necessarily for the reasons you think. [...Read More]