Blog

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

Data Migration Assistant

It’s upgrade season. Here at Straight Path, we have more than a couple of clients in the process of upgrading their SQL Environments to a more modern version. With the support door slamming shut soon for SQL 2008 (waaaay overdue), and others on 2012 (really not in a much better position – support wise) clients … Read more

How to Save Money on SQL Server Licensing by Upgrading

If you have SQL Server instances that are out of support, which is any version prior to SQL Server 2014, then I’m sure you have your reasons for not upgrading to a newer version. Let’s take a quick look at those reasons and then examine one reason you might not have considered. My hope is … Read more

SQL Server Migration Considerations from a Jr. DBA

SQL Server migrations are a necessary and expected part of keeping a modern SQL Server deployment. We have worked with many clients on migration projects, and I have organized some considerations for you and your team before, during, and after your SQL Server migration. We recommend working with a SQL server DBA on these kinds … Read more

SQL Server Upgrade/Migration Webinar

I hope to see you live on Tuesday, 11/29/22 at Noon (US EST) for our webinar about SQL Server Upgrades and Migrations. We’ll have a panel discussion and a short presentation followed by office hours answering your questions about upgrades/migrations (or anything SQL Server related.) The session will be recorded and shared on the blog … Read more