Reviewing the Windows Event Logs to Find Hints That Can Cause Availability Issues
Troubleshooting Availability of SQL Server Workloads Running on Windows Server Failover Cluster - Part 3

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 In the first blog post in this series, I talked about how to use the Cluster Dependency Report to identify the potential […]
Reviewing the SQL Server Error Logs to Find the Two Most Common Keywords That Can Cause Availability Issues
Troubleshooting Availability of SQL Server Workloads Running on Windows Server Failover Cluster - Part 2

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 As I was driving out of my driveway, I noticed something that is considered to be every car owner’s worst nightmare: the […]
Have You Invested In This?

A week before I officially launched my online course How to Build a Personal Lab for Deploying SQL Server on Windows Server Failover Clusters, I asked this question on Twitter. There were various responses, ranging from “very important” to “it helped my career“. While reading one of the responses, I realized that I actually asked the wrong question. […]
The Biggest Challenge I Had in Mastering Windows Server Failover Clustering for SQL Server

I’m re-launching my online course Windows Server Failover Clustering (WSFC) for the Smart SQL Server DBA. The course took a year-and-a-half in the making. But mastering the concepts I covered in the course took over a decade. With the continuous improvement that Microsoft has invested in the WSFC technology over the years, implementing and managing it has […]