-
Module 1: High availability overview
12 Lessons-
StartModule introduction
-
StartWhat is high availability ?
-
StartWhat is disaster recovery ?
-
StartDefining RTO
-
StartDefining RPO
-
StartDefining 9s of availability
-
StartPartial availability
-
StartHA and DR options in SQL Server
-
StartFeature interactions
-
StartSQL Server editions and HA features
-
StartChoosing the best solution
-
StartQuiz 1
-
-
Module 2: Infrastructure foundations
9 Lessons-
StartModule introduction
-
StartInfrastructure basics for HA
-
StartWindows Server Failover Clustering (WSFC)
-
StartShared vs non-shared storage models
-
StartNetworking and DNS considerations
-
StartAD dependencies and permissions
-
StartDemo: Hyper-V Lab Setup (Exercises 1 and 2)
-
StartLab 2: Exercises 1 and 2
-
StartQuiz 2
-
-
Module 3: Failover clustering concepts
21 Lessons-
StartModule introduction
-
StartWhat is an FCI ?
-
StartCore concepts
-
StartFCI architecture diagram
-
StartWhen to use an FCI
-
StartMulti-node configuration
-
StartMulti-node vs multi-instance
-
StartDemo: Domain Controller and Prerequisites (Exercises 3, 4, 5)
-
StartMaintaining quorum
-
StartCluster failover process
-
StartResource DLL
-
StartFailover policy
-
StartWindows clustering support
-
StartMount points and drive letters
-
StartDemo: Add 2 SQL VMs (Exercises 6, 7)
-
StartiSCSI and SMB
-
StartDemo: Create WSFC and add shared disk (Exercises 8, 9)
-
StartPlanning a cluster
-
StartVirtualization support
-
StartClient and application design
-
StartLab 3: Exercises 3, 4, 5, 6, 7, 8, 9
-
-
Module 4: FCI implementation and monitoring
12 Lessons-
StartModule introduction
-
StartDemo: Install SSMS Offline (Exercise 10)
-
StartHeartbeat configuration
-
StartCluster validation
-
StartDemo: SQL Server FCIs on WSFC (Exercise 11)
-
StartTroubleshooting configuration
-
StartPost-installation tasks
-
StartCluster-related DMVs
-
StartAdding a node
-
StartRemoving a node
-
StartRepairing clusters
-
StartLab 4: Exercises 10, 11
-
-
Module 5: FCI advanced concepts
11 Lessons-
StartModule introduction
-
StartNode failure detection
-
StartManaging failover and health
-
StartMulti-site clustering
-
StartGeo-located clusters
-
StartWindows Core support
-
StartDNS/WINS configuration
-
StartInteractions with DTC
-
StartClustering Analysis Services
-
StartDemo: Reset VMs and Install SQL Server (Exercise 12)
-
StartLab 5: Exercise 12
-
-
Module 6: Database snapshots
12 Lessons-
StartModule introduction
-
StartWhat are database snapshots ?
-
StartImplementing database snapshots
-
StartDatabase snapshot structure
-
StartDemo: Database Snapshots (Exercise 13)
-
StartTypical usage scenarios
-
StartRevert from a snapshot
-
StartDemo: Revert from a snapshot (Exercise 14)
-
StartPerformance implications
-
StartLimitations
-
StartRefreshing a snapshot
-
StartLab 6: Exercises 13, 14
-
-
Module 8: Log shipping
16 Lessons-
StartModule introduction
-
StartWhat is log shipping ?
-
StartHow log shipping works
-
StartLog shipping components
-
StartLog shipping configuration
-
StartDependent objects
-
StartDelayed log restore
-
StartStandby option
-
StartSetup using SSMS
-
StartDemo: Log Shipping (Exercise 16)
-
StartMonitoring and alerts
-
StartLog shipping failover
-
StartRolling upgrades
-
StartAgent security for log shipping
-
StartCommon pitfalls
-
StartLab 8: Exercise 16
-
-
Module 9: Database mirroring for legacy systems
24 Lessons-
StartModule introduction
-
StartWhat is database mirroring ?
-
StartCore process
-
StartRoles - Principal, mirror, witness
-
StartHA modes for mirroring
-
StartSync vs async
-
StartSetup prerequisites
-
StartSetup
-
StartWitness configuration
-
StartClient partner caching
-
StartServer dependencies
-
StartCross-domain implementation
-
StartDNS/WINS configuration
-
StartReporting on mirrors
-
StartManual failover
-
StartAutomated failover
-
StartForcing service
-
StartMonitoring and miroring states
-
StartDemo: Database Mirroring (Exercises 17)
-
StartAutomatic page repair
-
StartUpgrade considerations
-
StartInteractions with backup
-
StartLimitations
-
StartLab 9: Exercise 17
-
-
Module 10: Availability Groups concepts
21 Lessons-
StartModule introduction
-
StartAlways On branding
-
StartWhat are availability groups ?
-
StartAGs vs mirroring
-
StartAGs vs transactional replication
-
StartCommon AG topologies
-
StartActive secondaries
-
StartApplication failover
-
StartConfiguring an AG
-
StartReadable secondaries
-
StartReadable secondary impacts
-
StartDemo: Availability Groups (Exercise 18)
-
StartAG node configuration
-
StartRouting URLs
-
StartRouting secondaries
-
StartQuery statistics on secondaries
-
StartLicensing and editions
-
StartInteractions with backup
-
StartBackup role preferences
-
StartDemo: Destroy the WSFC and Exit the Domain (Exercise 19)
-
StartLab 10: Exercise 18, 19
-
-
Module 11: Domain independent AGs
13 Lessons-
StartModule introduction
-
StartWhat are domain independent AGs ?
-
StartWSFC dependency
-
StartMirroring to AG upgrade issues
-
StartAD-detached clusters
-
StartWorkgroup clusters
-
StartShared DNS
-
StartDemo: Configure Workgroup DNS (Exercise 20)
-
StartNode topology examples
-
StartConfiguration steps
-
StartDemo: Domain Independent AG (Exercise 21)
-
StartLimitations
-
StartLab 11: Exercises 20, 21
-
SQL Server High Availability for Developers and DBAs
Master the skills to keep SQL Server available for users
Keep your SQL Server running - no matter what !
Are you ready to work with SQL Server high availability options?
Our comprehensive course is your gateway to mastering the skills needed to keep SQL Server available for users.
Ask Yourself:
- Do you want to eliminate downtime and keep your SQL Server running 24/7?
- Would you like to confidently design and implement failover solutions that work when it counts?
- Do you want to understand how Always On, clustering, and log shipping actually work — and when to use each?
- Would you like to troubleshoot high availability issues without relying solely on infrastructure teams?
- Do you want to protect your organization from data loss during system failures or disasters?
- Would you like to be the person that everyone turns to when uptime is on the line?
If any of these sound like you, then this course is designed to give you practical, real-world skills — fast.
You'll get hands-on experience with configuring and managing SQL Server high availability solutions, including failover clustering, Always On availability groups, log shipping, database mirroring, and more.
Whether you're a developer wanting to understand HA from the inside out, or a DBA looking to strengthen your uptime strategy, this course delivers deep technical instruction, guided labs, real-world scenarios, and knowledge checks to reinforce your learning.
Don't miss this opportunity to future-proof your SQL Server environments, minimize downtime, and gain the confidence to keep your systems online — even under pressure. This is one of the most comprehensive and up-to-date courses available today.
Course Curriculum
Greg Low
