It’s been a while since we made some improvements to the public version of sp_CheckSecurity, but internally we’ve been busy fine tuning checks and adding even more to discover potential vulnerabilities in your SQL Server instances. Today we’re announcing a new version that includes additions, corrections, and a few other adjustments that should be helpful. … Read more
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
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
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
I don’t know about you, but I’m too busy to do it all. I use tools to help me do my job as a DBA. Let’s talk about some of the tools or types of tools that might help you do your job. This is Week 4 of the Spring 2010 semester of SQL University … Read more