Posted on

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 […]

Posted on

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 […]

Posted on

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. […]

Posted on

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 […]

Posted on

Exploring The Windows Server Failover Cluster Dependency Report

Troubleshooting Availability of SQL Server Workloads Running on Windows Server Failover Cluster - Part 1

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 Renting a car is something that I do quite frequently as I travel. Different rental car companies have a variety of car models […]