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

Posted on

Creativity Thru Scarcity: Behind the Scenes of Creating My Online Course

In a previous blog post, I wrote about the back story behind the best-selling solo album in jazz history and the all-time best-selling piano album – The Köln Concert. As we all face a form of scarcity in one way or another, we need to be creative in finding ways to leverage our lack and achieve our […]