Introducing sp_CheckBackup: Check Your SQL Server Backups for Recoverability Issues

SQL Server database backup tool for checking recoverability issues

Whether you are backing up your SQL Server databases with Ola Hallengren’s scripts, Maintenance Plans, or some third-party software, your backups are your lifeline for recovering your data in case of a disaster. So…are your databases recoverable? Do you know WHERE your most recent backups were written? Do you know WHEN they were written? Did … Read more

SQL Server Tool Update: sp_CheckSecurity version 1.1

free sql server dba tool sp_CheckSecurity

Since releasing our initial version of sp_CheckSecurity, we have received quite a bit of feedback. Thank you for all the emails, blog comments, and issues noted in GitHub, that have all been helpful in directing us towards making this SQL Server tool more useful. Today we are announcing the release of version 1.1, available for download … Read more

Check Out These Tools – SQL University

Some neat (and free) tools to help you out with SQL Server. This is my second contribution to the SQL University “Tools of The Trade” week series. In part one we had a quick chat about why to look at using various tools to help you out working with SQL Server. In this post, we’ll … Read more