Autoplay
Autocomplete
Previous Lesson
Complete and Continue
SQL Server Always On Availability Groups: The Senior DBA’s Ultimate Field Guide (PowerShell Edition)
Program Introduction
What this training is all about (5:48)
How to get the most out of this training course (22:38)
Setting up your DBA workstation
SQL Server Management Studio + SqlServer PowerShell Module (6:24)
Failover Clustering Management Tools (7:43)
dbaTools (9:19)
Visual Studio Code with PowerShell (8:37)
Environment for the training (3:52)
Installing a Windows Server Failover Cluster
Cluster Preparation Checklist (4:48)
Preparing The Servers: Adding the Failover Cluster Feature and Failover Cluster Validation (32:27)
Creating the Windows Server Failover Cluster (5:56)
Windows Server Failover Cluster Configuration
Verifying and Modifying Quorum Configuration (10:38)
Configuring Windows Server Failover Cluster Networking (16:09)
Testing Failover (7:29)
Configuring DNS Registration Behavior for Multi-subnet Windows Server Failover Clusters (6:36)
Configuring Cluster Heartbeat Settings (17:19)
Applying the Concepts of Site-awareness for Multi-Subnet/Site Configuration (40:24)
Deploying SQL Server Always On Availability Groups
Building a 4-replica SQL Server Always On Availability Group (31:13)
Viewing Availability Group Properties (13:04)
Testing Application Connectivity and Availability Group Failover (18:02)
Configuring Dedicated Network for Availability Group Replication Traffic (21:15)
Configuring a Distributed Availability Group
Configuring Basic Availability Groups
My Favourite Tool for Network Connectivity Testing (18:39)
Configuring SQL Server Always On Availability Groups
A Note on Change Management (6:05)
Replicating SQL Server Logins (8:39)
Replicating SQL Server Agent Jobs (8:53)
Availability Groups as Failover Cluster Resource Groups (14:58)
Viewing Cluster Resource Dependencies (7:32)
Configuring Resource Group-level Policies (11:15)
Configuring Resource-level Policies (16:14)
Configuring Availability Groups Listener Name DNS settings for Multi-subnet Failover Clusters (16:42)
Configuring Readable Secondary Replicas (10:46)
Configuring Read-Only Routing (16:28)
Configuring Load Balancing of Read-Only Workloads (10:22)
Managing SQL Server Always On Availability Groups
Running Integrity Checks: DBCC CHECKDB (9:02)
Configuring Backup Preferences (9:04)
Adding or Removing a Database in the Availability Group (5:53)
Adding or Removing a Secondary Replica (7:28)
Modifying Availability/Replication Modes (4:12)
Temporarily Suspending and Resuming Data Synchronization (5:18)
Performing Planned Manual Failover of Availability Groups (3:28)
Performing Forced Manual Failover of Availability Groups (6:36)
Configuring Flexible Failover Policy (4:02)
Modifying Session Timeout Period (6:32)
Performing Index Maintenance (5:34)
Managing Statistics (5:49)
Installing Service Packs and Cumulative Updates (54:39)
Monitoring SQL Server Always On Availability Groups
Using dbaTools to do an Always On Availability Group Health Check (15:14)
Troubleshooting Common Issues in SQL Server Always On Availability Groups
Workflow Process for Troubleshooting Availability Issues (18:59)
Zero Downtime Blueprint
Force Start a Failover Cluster Without Quorum (30:30)
Troubleshooting Exercise #1 (9:00)
Troubleshooting Exercise #2 (5:08)
Troubleshooting Exercise #3 (7:49)
Summary
dbaTools
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock