I started this blog post series with one thing in mind: help SQL Server administrators prepare for the journey towards the cloud. I may be a little bit ambitious to use hybrid SQL Server high availability and disaster recovery (HA/DR) solutions as a starting point. But since SQL Server HA/DR solutions have been around for a […]
PostWhen You’re Moving
This blog post is the sixth in a series that covers designing and implementing hybrid SQL Server high availability and disaster recovery solutions with Microsoft Azure. We’ve moved quite a bit as a family within the last 15 years – from moving between cities, different countries to different continents. Each move was different. The first […]
PostIt’s Just LEGO® . . .
This blog post is the fifth in a series that covers designing and implementing hybrid SQL Server high availability and disaster recovery solutions with Microsoft Azure. I’m sure you’re familiar with the famous brand and its product line of toys. You’ve probably seen one of the recent movies – The Lego® Movie and The […]
PostDon’t Click The Button Twice
This blog post is the fourth in a series that covers designing and implementing hybrid SQL Server high availability and disaster recovery solutions with Microsoft Azure. I couldn’t figure out why I got two of everything I purchased from Amazon – two copies of a book, two pieces of lavalier microphone, RAM modules for my […]
PostManaging The Right Expectations
This blog post is the third in a series that covers designing and implementing hybrid SQL Server high availability and disaster recovery solutions with Microsoft Azure. You’re on the phone to get a technical issue resolved. You checked the service provider website and noticed that their phone support is available 24/7. You dial the […]
PostAre You (Still) In The Business Of Running Databases?
This blog post is the second in a series that covers designing and implementing hybrid SQL Server high availability and disaster recovery solutions with Microsoft Azure. As I was reading the news this week, it’s hard to ignore the announcement of General Motors laying off hundreds, if not thousands, of employees in their Michigan-based manufacturing plants. […]
PostGetting Into The “Dating Phase” with the Cloud
This blog post is the first in a series that covers designing and implementing hybrid SQL Server high availability and disaster recovery solutions with Microsoft Azure. I’m sure you’ve seen a lot of status updates on your social media feeds this past Valentine’s Day. Whether you’re searching for a new partner or in an […]
PostMaking Sense of the Windows Server Failover Cluster Debug Logs For Mere Mortals
WARNING: If you’ve gone thru part 1, part 2 and part 3 of this series of blog posts and your SQL Server databases running on a Windows Server Failover Cluster (WSFC) are still offline and unavailable, I would recommend escalating it to a more senior engineer or calling Microsoft support before reading further. Regardless […]
PostGenerating the Windows Server Failover Cluster Debug Logs
WARNING: If you’ve gone thru part 1, part 2 and part 3 of this series of blog posts and your SQL Server databases running on a Windows Server Failover Cluster (WSFC) are still offline and unavailable, I would recommend escalating it to a more senior engineer or calling Microsoft support before reading further. Regardless […]
PostReviewing the Windows Event Logs to Find Hints That Can Cause Availability Issues
SQL Server Failover Clustered Instances (FCI) and Availability Groups (AG) depend a lot on Windows Server Failover Clustering (WSFC). Understanding how the underlying WSFC platform works can help us maintain availability of our databases This blog post is the third in a series that talks about the process that I follow when troubleshooting availability of SQL Server failover […]