SQL Server features like Availability Groups and Failover Clustered Instances rely heavily on Windows Server Failover Clustering. A deep understanding of the underlying principles and fundamental technologies spell the difference between successful implementations and horrible disasters.
This advanced, deep-dive course is designed for both beginners as well as advanced senior IT administrators, SQL Server DBAs and system architects to tackle the challenges of architecting, deploying and managing mission-critical and highly available SQL Server databases with Windows Server Failover Clustering from the ground up – with primary focus on SQL Server failover clustered instances (FCIs.) The course also covers how non-technology aspects need to drive a solid HA/DR solution, how Windows Server Failover Clustering works and how they can be implemented in the context of SQL Server HA/DR solutions. This course is designed, created and delivered by Data Platform MVP, SQL Server Microsoft Certified Master, author and consultant Edwin M Sarmiento.
Course Prerequisites
In order to take full advantage this course, attendees need to have
- A working knowledge of basic relational database concepts
- Experience with administering and managing a SQL Server instance
- Basic knowledge of the Windows Server 2008 and higher server operating system
Course Objectives
With focus on SQL Server 2008 and higher versions running on Windows Server 2008 and higher, this course aims to provide the fundamentals of what it takes to design, implement and maintain a SQL Server High Availability and Disaster Recovery solution using Windows Server Failover Clustering. At the end of the course, senior IT administrators, SQL Server DBAs and system architects will be able to correctly define recovery objectives that align with the business requirements, architect and deploy the appropriate solution and build the appropriate framework for supporting it.
Course Outline
- Introduction to Microsoft® High Availability Technologies (FREE). Providing high availability and fault tolerance to technology solutions require an understanding of the different clustering technologies.
- Windows Server Failover Clustering (WSFC) Fundamentals (US$ 59). Building a solution requires understanding of the different components and how they work together. How Windows Server Failover Clustering (WSFC) works will be the focus of this course.
- Planning and Installing a Windows Server Failover Cluster (WSFC) (US$ 59). Every successful installation of a complex architecture start with a carefully, well-thought-out plan.
- Deep Dive on Windows Server Failover Cluster Quorum (US$ 59). The quorum is the most important yet overly complex and confusing component in a Windows Server Failover Cluster (WSFC.) Understanding its function and behavior can help properly design and configure a highly available WSFC environment that can be used for any type of supported workload.
- Windows Server Failover Cluster (WSFC) Configuration (US$ 69). Once a Windows Server Failover Cluster (WSFC) system has been deployed, proper configuration is necessary to achieve high availability and disaster recoverability.
- Planning and Installing SQL Server Failover Clustered Instance (US$ 79). Only after the Windows Server Failover Cluster has been properly installed and configured can we start working with SQL Server. SQL Server Failover Clustered Instances simply takes advantage of the underlying Windows Server Failover Cluster platform to provide instance-wide availability and fault tolerance.
- Configuring SQL Server Failover Clustered Instances (US$ 79). Once the SQL Server failover clustered instance has been installed, we need to properly configure it according to Microsoft best practices. This includes assigning appropriate permissions for local tempdb, configuration of the cluster resource group and the clustered MS DTC.
- Managing SQL Server Failover Clustered Instances (US$ 79). Highly available SQL Server instances need proper care and feeding to make sure they stay that way. This module covers the common operational tasks necessary to maintain a highly available SQL Server instance like maintaining clustered disks and dependencies, changing virtual server names and IP addresses and installing service packs to name a few.
| Product | Price |
|---|---|
Windows Server Failover Clustering (WSFC) for the Smart SQL Server DBA | $420.00 per year |
