6 Common Mistakes Made With SQL Server Backups

6 Common Mistakes Made With SQL Server Backups

People are always saying things about the importance of data, like how it is the lifeblood of a business. It sounds cliché, but there’s a lot of truth to that. You and I can’t survive without any blood, and there’s a good chance your business wouldn’t exist for long if they suddenly lost all their … Read more

SQL Server Upgrade/Migration Webinar

sql server upgrades and data migrations

This month’s webinar is all about SQL Server upgrades and migration. We cover the following topics: 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 like to be notified about upcoming webinars, be sure to subscribe … Read more

High Availability and Disaster Recovery With SQL Server Standard Edition

sql server high availability

There are many ways to setup High Availability and Disaster Recovery, most of which are focused on SQL Server Enterprise edition.  However, the licensing for Enterprise edition gets costly fast.  One less talked about approach to building a cost-effective HA/DR solution is building a failover cluster instance using SQL Server Standard with SIOS Datakeeper. SQL … Read more

Books and Covers…

Believe me, every heart has its secret sorrows, which the world knows not, and oftentimes we call a man cold, when he is only sad. Longfellow, Hyperion (1839) This post has been rattling around in my head for several years. Of late, though, the rattling has turned into a steady vibration. The day before I … Read more

HA/DR Troubleshooting from a Jr. DBA

Availability groups, Failover Clusters, Log Shipping, and more. These are tools we use to ensure that the data is highly available and disaster recoverable. This post will be the general walkthrough for how to determine what may be going wrong with your HA/DR solution, as well as some general tips and tricks from what we … Read more

6 Common Pitfalls of SQL Server Migrations and Upgrades

common sql server migration pitfalls

If you’ve ever tried migrating a SQL Server database from one server to another, you know it can be a white-knuckle ride from start to finish. You need to wait forever while you backup and restore, change all your connection strings to point to the new server, and forget to change the data sources for … Read more

SQL Server HA/DR Webinar

sql server high availability data recovery hadr webinar

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