All database administrators know that safeguarding data is paramount and having a strong restore strategy is crucial. In this post, I would like to add another tool to your arsenal that I have found helpful in auditing server health and configurations as it pertains to backups and the backup chain. A backup chain is important … Read more
(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
On Tuesday, 12/13/22, we presented a webinar about HA/DR (high availability and disaster recovery). Join Team Straight Path as we discuss what HA is, what DR is, and how they are different. We talked about the ways to achieve HA and DR. We’ll talk about the things we’ve learned about HA and DR along the … Read more
If you’re still on SQL Server 2008/2008 R2, you’re missing out on some great features. It’s no secret that Availability Groups are my favorite feature since SQL Server 2012. Back in the day, I was supporting complex environments with aggressive SLAs. On one particular system, I had Failover Clustering for HA, Asynchronous Database Mirroring for … Read more