Administering Microsoft SQL Server Availability Groups

Focused View

Russ Thomas

3:51:33

7 View

00 - Course Overview

01 - Course Overview.mp4

01:40

01 - Exploring the Capabilities of SQL Server Availability Groups

02 - Course Intro.mp4

03:14

03 - Course Checklist.mp4

05:16

04 - Evolution of Sql Server HA and DR.mp4

03:41

05 - Availability Groups.mp4

03:50

06 - Building Our Lab Environment.mp4

04:54

02 - Building an Always On Foundation for Availability Groups

07 - Intro to Always On.mp4

01:55

08 - Cluster Setup Demo.mp4

07:19

09 - Quorum Concept.mp4

04:12

10 - Quorum Modes.mp4

03:47

11 - Quorum Best Practices.mp4

05:16

12 - Quorum Configuration Demo.mp4

05:55

13 - Troubleshooting Demo.mp4

06:25

14 - Always on without a Domain.mp4

06:00

15 - Availability Groups without a Cluster.mp4

04:53

03 - Establishing an Availability Group

16 - Module Summary.mp4

02:05

17 - AG Prerequisites on Windows and Linux.mp4

04:06

18 - Creating Endpoints.mp4

02:20

19 - Create Availability Group Wizard.mp4

05:32

20 - Create Availability Group TSQL.mp4

05:58

21 - Adding Additional Databases and Replicas.mp4

04:28

04 - Configuring and Tuning an Availability Group

22 - Intro.mp4

03:05

23 - Asynchronous and Synchronous Replicas.mp4

06:02

24 - Overview of Adding AG to a Linux Cluster.mp4

02:51

25 - Module Summary and What Remains.mp4

01:51

26 - Automatic and Manual Failovers.mp4

02:46

27 - Availability Group Failover Configuration.mp4

05:37

28 - Flexible Failover Policy and Advanced Configuration.mp4

02:16

29 - Configuring Read Only Replicas.mp4

05:10

30 - Understanding Secondary Read Latency and Isolation Levels.mp4

03:31

31 - Configuring Backup Location Models.mp4

05:09

32 - Configuring a Listener.mp4

04:14

33 - Read Routing URLs and Read Routing Lists.mp4

02:32

05 - Monitoring and Troubleshooting SQL Server Availability Groups

34 - Monitoring and Troubleshooting.mp4

03:10

35 - Firewalls, Ports, and Endpoints.mp4

04:19

36 - The Availability Group Dashboard.mp4

02:47

37 - Latency, Waits, Queues, and Bottlenecks.mp4

06:49

38 - Instance Level Object Troubleshooting.mp4

05:21

39 - Extended Events.mp4

05:13

40 - Policy Based Management.mp4

07:24

41 - RPO, RTO, Error Logs, and Health Logs.mp4

04:55

42 - Course Summary and 2019 Feature Preview.mp4

05:33

06 - Advanced Networking and Distributed Availability Groups

43 - Introduction.mp4

02:57

44 - Distributed Availability Groups.mp4

05:17

45 - Creating Two Availability Groups.mp4

04:49

46 - Creating a Distributed Availability Group.mp4

05:53

47 - Script Review and Troubleshooting.mp4

04:11

48 - Failing Over a Distributed Availability Group.mp4

05:49

49 - Failover Cluster Heartbeats and Networks.mp4

07:06

50 - Heartbeat Thresholds and Cost Metrics.mp4

06:07

51 - PowerShell to the Rescue.mp4

06:03

Description

In this course, you'll learn the critical skills to install, administer, support, and troubleshoot SQL Server Availability Groups. You will cover a variety of environments including Windows, Linux, and Always On, with or without a domain.

What You'll Learn?

An Availability Group is the most advanced and feature-rich approach to both high availability and disaster recovery in SQL Server. In this course, Administering Microsoft SQL Server Availability Groups, you will learn foundational knowledge and the ability to install, support, administer and troubleshoot Availability Groups. First, you will learn to establish an Always On foundation for this feature. Next, you will discover how easy it is to install Availability Groups. Finally, you will explore how to customize your installation, address specific needs, and troubleshoot unexpected issues. When you’re finished with this course, you will have the skills and knowledge of SQL Server Availability Groups needed to comfortably consider this feature for your most critical SQL Server databases and applications.

More details

User Reviews

Rating

average 0

Total votes0

Focused display

Microsoft SQL

Russ Thomas

Instructor's Courses

Currently an IT leader in Denver Colorado's financial sector Russ has focused on database engineering, modelling, administration, and BI since 1997 across the Microsoft stack. Russ is a passionate trainer and SQL community volunteer presenting regularly at PASS SQL Saturday events and local user groups around the US. In 2019 much of Russ' focus turned to cloud based data lakes specifically on Google BigQuery.

Pluralsight

View courses Pluralsight

Pluralsight, LLC is an American privately held online education company that offers a variety of video training courses for software developers, IT administrators, and creative professionals through its website. Founded in 2004 by Aaron Skonnard, Keith Brown, Fritz Onion, and Bill Williams, the company has its headquarters in Farmington, Utah. As of July 2018, it uses more than 1,400 subject-matter experts as authors, and offers more than 7,000 courses in its catalog. Since first moving its courses online in 2007, the company has expanded, developing a full enterprise platform, and adding skills assessment modules.