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 […]
PostReviewing the SQL Server Error Logs to Find the Two Most Common Keywords 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 second in a series that talks about the process that I follow when troubleshooting availability of SQL Server failover […]
PostThe Biggest Challenge I Had in Mastering Windows Server Failover Clustering for SQL Server
With the continuous improvement that Microsoft has invested in the WSFC technology over the years, implementing and managing it has become a lot easier. I started doing my Gone Clustering in 60 Minutes presentation back in 2010. And I’m still amazed at how much it has improved. But I still talk about the frustrating hardware compatibility […]