Learn AI, Data Science & Business — Earn Certificates That Get You Hired
You’re only 3 weeks away from a new language
Overview
AI, Data Science & Cloud Certificates from Google, IBM & Meta — 40% Off
One plan covers every Professional Certificate on Coursera. 40% off Coursera Plus Annual.
Unlock All Certificates
Explore the critical concept of cluster quorum in database administration through this comprehensive conference talk. Delve into the importance of quorum, dynamic quorum, and various witness types including file share and cloud witnesses. Learn how to implement witnesses for simple 2-node Failover Cluster Instances (FCI) and Availability Groups (AG). Discover techniques for changing quorum models and witnesses, and understand the complexities of quorum in multi-site deployments. Gain valuable insights into maintaining high availability and disaster recovery in SQL Server environments.
Syllabus
Intro
Session Evaluations
Quick Terminology Guide
Why Do You Need Quorum?
Dynamic Quorum
Witness Type Comparison File Share
Cloud Witness 1
Cloud Witness 2
Example: Witness for "Simple" 2-Node FCI
Example: Witness for "Simple" 2-Node AG
Changing Quorum Model & Witness
Multi-Site Deployments and Quorum
Witness for Multi-Site Deployments
Taught by
PASS Data Community Summit