SQL Server High Availability and Disaster Recovery (HA/DR)

Course Curriculum

Chapter 1: Practical SQL Server HA/DR Show

Lecture 1: Patching and Maintaining HA Solutions

Lecture 2: Monitoring SQL Server High Availability Solutions

Lecture 3: High Availability Basics for the DBA – What SQL Server CANNOT Do For You

Lecture 4: Backups

Lecture 5: Migrating SQL Server High Availability Solutions

Lecture 6: Migrating SQL Server High Availability Solutions – Part 2

Lecture 7: Focus on Windows Server Failover Clustering

Lecture 8: Are You Asking The Most Important Question About Your Availability Groups?

Lecture 9: The A.R.T. of Dealing with a Crappy Environment That You Just Inherited

Lecture 10: The Curse of SILOs

Lecture 11: What To Do When You Have Too Many Incidents In Your HA Environments

Lecture 12: 3 Biggest Mistakes DBAs Make When Deploying and Managing SQL Server Always On

Lecture 13: Dealing With A Black Box Even When You Don't Have Access

Lecture 14: How Learning and Mastering SQL Server Always On Can Lead To Your Next Promotion

Lecture 15: Succeeding as a SQL Server DBA Even Without Production Experience

Lecture 16: The Secret to Becoming a Subject Matter Expert

Lecture 17: Why "Is This Supported?" Is the Wrong Question to Ask About Your SQL Server HA

Lecture 18: H.O.W. to Handle Emergencies When You Have Very Limited Resources

Lecture 19: 3 Reasons Why Focusing on Tech is the WORST WAY to Deploy SQL Server HA/DR

Lecture 20: Do you have these 3 THINGS to properly support a HA/DR Solution?

Lecture 21: How Your Problem Solving Skills Can Cause More Problems If Not Done Right

Lecture 22: How Being an Operational DBA For So Long Is Hurting Your Career

Lecture 23: Your Responsibilities as an IT Pro for Dealing with Disasters

Lecture 24: Deadly SQL Server Always On Availability Group Deployment Mistakes to Avoid

Lecture 25: 3 Things Preventing You From Working with Always On Availability Groups

Lecture 26: Being A Jack-Of-All-Trades Puts Your High Availability Solution At Risk

Lecture 27: Why A Technical Answer Is NEVER The Right Response to a Technical Question

Lecture 28: What Experts & Consultants Are Not Telling You About Your HA/DR Solution

Lecture 29: Eliminate the Headaches of Upgrading & Migrating your SQL Server Databases

Lecture 30: Maximizing Your Change Freeze Period

Lecture 31: Making The Most of Your HA/DR Solutions in the New Year

Lecture 32: Impacts of Outdated Legacy Systems in HA/DR

Lecture 33: Protecting SQL Server from Unexpected Disasters

Lecture 34: Beyond Licenses and Hardware: The Hidden Costs of HA/DR

Lecture 35: 3 Common Mistakes IT Pros Make When Working with Backups

Lecture 36: 3 Biggest Blunders from My Botched Backups

Lecture 37: Making the Right Decision: What 3rd-party Backup Tools CANNOT Do For You

Lecture 38: Backup Strategies That Can Cause Unexpected Disasters

Lecture 39: 3 Things Your SQL Server HA/DR Solutions Need to Work

Lecture 40: Dealing With External Dependencies The Right Way

Lecture 41: Is Your HA/DR Solution a By-product of Technical Malpractice?

Lecture 42: March 31st is #WorldBackupDay

Lecture 43: Designing and Building Resilient HA/DR Solutions

Lecture 44: Why Developers Need to be Included in HA/DR Discussions

Lecture 45: Backend Developers and Data Engineers: Your Responsibilities in HA/DR

Lecture 46: HA/DR Disconnect: The Cost of Not Being On The Same Page with Other IT Teams

Lecture 47: "Supported" HA/DR Solutions: What It Really Means

Lecture 48: Unwritten Expectations That Come with HA/DR Solutions

Lecture 49: Business Impact Analysis: What It Means To Your HA/DR Solutions

Lecture 50: Risks of Having Untrained Operational Staff in Your HA/DR Solutions

Lecture 51: Considerations When Upgrading and Migrating HA/DR Solutions

Lecture 52: Business Continuity: What You Need to Know as an IT Professional

Lecture 53: Starting the Year Right: Re-evaluating Your Existing HA/DR Solutions

Lecture 54: HA/DR Tasks In The Beginning Of The Year

Lecture 55: Dealing with the "New VMWare": What You Need to do for your HA/DR Solutions

Lecture 56: Beyond the Database: HA/DR for your Multi-tier Solutions

Chapter 2: Introduction

Lecture 1: Introduction

Lecture 2: The Need for High Availability and Disaster Recovery

Chapter 3: Non-Technology Aspects of High Availability and Disaster Recovery

Lecture 1: Non-Technology Aspects of HA/DR

Lecture 2: The Alphabet Soup of HA/DR

Lecture 3: S.M.H. Those Things That You're not Aware Of But Part of HA/DR

Chapter 4: SQL Server Recovery Models

Lecture 1: SQL Server Database Recovery Models

Lecture 2: Demo: SQL Server Database Recovery Models

Lecture 3: Demo: The Risk of Switching Recovery Models

Chapter 5: SQL Server Database Backups

Lecture 1: Database Backups

Lecture 2: Demo: Understanding Multi-base Differential Backups

Chapter 6: SQL Server Transaction Log Internals

Lecture 1: Inside the SQL Server Transaction Log

Lecture 2: Demo: Inside the SQL Server Transaction Log

Lecture 3: Demo:Effects of the Transaction Log Filling Up

Chapter 7: SQL Server Database Restore and Recovery

Lecture 1: Database Restore and Recovery

Lecture 2: Factors Affecting Restore And Recovery

Lecture 3: DEMO:Effects of Instant File Initialization

Lecture 4: Demo: Database Recovery Techniques

Chapter 8: SQL Server System Databases

Lecture 1: Protecting System Databases

Lecture 2: Demo: Protecting System Databases

Chapter 9: SQL Server Database Mirroring

Lecture 1: Understanding and Implementing SQL Server Database Mirroring

Lecture 2: Demo: Implementing Database Mirroring – The Simple Way

Lecture 3: Demo: Implementing Database Mirroring on Workgroup Servers – The Hard Way

Chapter 10: SQL Server Log Shipping

Lecture 1: Understanding and Implementing SQL Server Log Shipping

Lecture 2: Demo: Implementing SQL Server Log Shipping

Chapter 11: SQL Server Failover Clustering

Lecture 1: SQL Server Failover Clustering Fundamentals

Lecture 2: Demo: Implementing SQL Server Failover Clustered Instances From Start to Finish

Lecture 3: Demo: SQL Server 2012 Multi-Subnet/Geographically-Dispersed Failover Clusters

Lecture 4: Implementing SQL Server Failover Clustered Instances (2022 Edition) – Part 1

Lecture 5: Implementing SQL Server Failover Clustered Instances (2022 Edition) – Part 2

Lecture 6: Implementing SQL Server Failover Clustered Instances (2022 Edition) – Part 3

Chapter 12: SQL Server Availability Groups

Lecture 1: Understanding and Implementing SQL Server Availability Groups

Lecture 2: Demo: SQL Server 2012 Availability Groups Configuration