Essential Database Maintenance Tasks Every DBA Should Know

sql server maintenance tasks every dba sould know

(Note from our founder, Mike Walsh in March of 2025: Since this post has gone live, I want to say we’ve probably made at least $70,000 in buckets of hours specifically related to clients reaching out about issues that could have been avoided and addressed simply be following the advice from David here… While we … Read more

SQL Server Health Check Worst Offenders

After performing hundreds of SQL Server Health Checks over the years, we wanted to share the most common repeat offenders we find time and again. These are: This topic is part of our monthly SQL Server webinar series. Webinar registrants get access to the entire recording, which includes the office hours Q&A. If you would … Read more

A Simple SQL Server Security Checklist

This month I am providing a 12-point checklist of scripts to check your SQL server’s current security posture. Use these scripts to get an idea of where you are, so that you can make plans for the places you may want to go. The paradigms of least privilege and defense in depth are important to … Read more

SQL Server Health Checks Webinar

Hey there! This post is the “Summary/Recap” for our Webinar on Thursday 6/23 at Noon US EDT. If you’ve not already registered for it please do so at the big REGISTER button below this. We’ll be talking about the things we see on SQL Server health checks at Straight Path that we don’t think we’d … Read more

SQL Server Patching Best Practices

It’s day four of the two weeks to a healthier SQL Server series. If I were making this ten-day plan even just three years ago, I would have had this lower on the list. With the security and compliance needs of the world today and the way Microsoft services SQL Server – it’s important to … Read more