Is Your SQL Server Ready for a Compliance Audit?

Compliance audits ensure that organizations adhere to regulatory guidelines, industry standards, and internal policies. As SQL Server DBAs, you can be prepared for most audits if you already check all of the boxes outlined in this blog post. Each of these points could be its own blog posts, so take your time as you go … Read more

Essential Database Maintenance Tasks Every DBA Should Know

sql server maintenance tasks every dba sould know

Database maintenance is a critical aspect of the DBA role, ensuring the smooth operation of SQL Server environments. In this blog post, we will explore key tasks and areas of focus for SQL Server DBAs, accompanied by practical tips and insights gained from our experience. From backup and recovery to performance optimization and security, let’s … Read more

SQL Server Maintenance With Ola Hallengren’s Maintenance Solution.

Ola maintenance for sql server databases

Perspective from a Junior DBA. Welcome to our month of community tool blog posts! We will discuss some of our favorite and most used tools and how we use them in the coming weeks. Our first post is on Ola Hallengren’s SQL Server maintenance solution. For some, this will be old news; this will be … 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

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