Last week at Live360, I have had the opportunity to deliver my workshop on Windows Server Failover Clustering (WSFC) for SQL Server DBAs. The workshop was based on an online course that I am about to re-release.
One of the things I like about delivering presentations is that I learn a lot from the attendees who ask questions. While I anticipate the possible questions that attendees may ask, my response to those questions are limited by my experience and exposure to the technology. One of the workshop attendees asked, “Where can I get additional information to learn more about Windows Server Failover Clustering?”
I started writing articles about WSFC for MSSQLTips.com back in 2009. Throughout the years, I’ve managed to compile resources that have helped me dig deeper into the technology and have used them to implement solutions and solve customer problems. I’d like to share those resources with you and hope you find them valuable. I’ve used these resources to create content for my workshop and online course.
I’m constantly looking for valuable resources about WSFC so if you have anything to add, feel free to send me an email so I can add it to the list. And feel free to share this with your colleagues, your team or anyone else in the community who would like to learn more about WSFC in the context of SQL Server.
My online course: Windows Server Failover Clustering (WSFC) for the Smart SQL Server DBA
Resources to get started with Windows PowerShell for the SQL Server DBA and managing Windows Server Failover Clusters
- Introduction to Windows PowerShell for the SQL Server DBA Part 1
- Introduction to Windows PowerShell for the SQL Server DBA Part 2
- Installing, Configuring and Managing Windows Server Failover Cluster using PowerShell Part 1
- Installing, Configuring and Managing Windows Server Failover Cluster using PowerShell Part 2
- Installing, Configuring and Managing Windows Server Failover Cluster using PowerShell Part 3
- Installing, Configuring and Managing Windows Server Failover Cluster using PowerShell Part 4
For testing some of the high availability features, in case you don’t want to setup your own lab
- Microsoft Learning Center Virtual Labs (select Mission-critical in the Subject drop-down list)
- Installing a SQL Server Failover Clustered instance
- Installing and Configuring a Multi Subnet SQL Server (2012 and higher) Failover Clustered Instance
- Failover Clustering in Windows Server 2012 R2 Course on Microsoft Virtual Academy
- SQL Server 2014 Upgrade Technical Guide (when you’re about upgrade your failover clustered instances or Availability Groups)
- AlwaysOn Architecture Guide: Building a High Availability and Disaster Recovery Solution by Using AlwaysOn Availability Groups
- AlwaysOn Architecture Guide: Building a High Availability and Disaster Recovery Solution by Using Failover Cluster Instances and Availability Groups
- SQL Server 2012 AlwaysOn Availability Groups (video)
- SQL Server high availability with AlwaysOn – First Look Webcast (video)
- Enable SQL Server 2012 AlwaysOn Availability Groups Using Windows PowerShell
- Configure SQL Server 2012 AlwaysOn Availability Groups Read-Only Routing using PowerShell
- Configure SQL Server 2012 AlwaysOn Availability Groups Read-Only Routing using T-SQL
- Configuring Volume Mountpoints on a SQL Server 2008 Failover Cluster running on Windows Server 2008 (concepts still apply to Windows Server 2012/SQL Server 2012 and higher)
- Clustering SQL Server Analysis Services Part 1
- Clustering SQL Server Analysis Services Part 2
- Using the Cluster Preparation Checklist for Deploying SQL Server Failover Clustered Instances and Availability Groups
- Build Guide: SQL Server 2012 Single-Subnet Cluster
- Build Guide: SQL Server 2014 MultiSubnet Cluster
- Build Guide: SQL Server 2016 Single-Subnet Cluster on Windows Server 2016
Feeling helpless and confused when dealing with Windows Server Failover Clustering (WSFC) for your SQL Server databases?
You’re not alone. I’ve heard the same thing from thousands of SQL Server administrators throughout my entire career. These are just a few of them.
“How do I properly size the server, storage, network and all the AD settings which we do not have any control over?”
“I don’t quite understand how the Windows portion of the cluster operates and interacts with what SQL controls.”
“I’m unfamiliar with multi-site clustering.”
“Our servers are setup and configured by our parent company, so we don’t really get much experience with setting up Failover Clusters.“
If you feel the same way, then, this course is for you. It’s a simple and easy-to-understand way for you to learn and master how Windows Server Failover Clusters can keep your SQL Server databases highly available. Be confident in designing, building and managing SQL Server databases running on Windows Server Failover Clusters.
But don’t take my word for it. Here’s what my students have to say about the course.
“The techniques presented were very valuable, and used them the following week when I was paged on an issue.”
“Thanks again for giving me confidence and teaching all this stuff about failover clusters.”
“I’m so gladdddddd that I took this course!!”
“Now I got better knowledge to setup the Windows FC ENVIRONMENT (DC) for SQL Server FCI and AlwaysON.”