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

• Patching and Maintaining HA Solutions

• Monitoring SQL Server High Availability Solutions

• High Availability Basics for the DBA - What SQL Server CANNOT Do For You

• Backups

• Migrating SQL Server High Availability Solutions

• Migrating SQL Server High Availability Solutions - Part 2

• Focus on Windows Server Failover Clustering

• Are You Asking The Most Important Question About Your Availability Groups?

• The A.R.T. of Dealing with a Crappy Environment That You Just Inherited

• The Curse of SILOs

• What To Do When You Have Too Many Incidents In Your HA Environments

• 3 Biggest Mistakes DBAs Make When Deploying and Managing SQL Server Always On

• Dealing With A Black Box Even When You Don't Have Access

• How Learning and Mastering SQL Server Always On Can Lead To Your Next Promotion

• Succeeding as a SQL Server DBA Even Without Production Experience

• The Secret to Becoming a Subject Matter Expert

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

• H.O.W. to Handle Emergencies When You Have Very Limited Resources

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

• Do you have these 3 THINGS to properly support a HA/DR Solution?

• How Your Problem Solving Skills Can Cause More Problems If Not Done Right

• How Being an Operational DBA For So Long Is Hurting Your Career

• Your Responsibilities as an IT Pro for Dealing with Disasters

• Deadly SQL Server Always On Availability Group Deployment Mistakes to Avoid

• 3 Things Preventing You From Working with Always On Availability Groups

• Being A Jack-Of-All-Trades Puts Your High Availability Solution At Risk

• Why A Technical Answer Is NEVER The Right Response to a Technical Question

• What Experts & Consultants Are Not Telling You About Your HA/DR Solution

• Eliminate the Headaches of Upgrading & Migrating your SQL Server Databases

• Maximizing Your Change Freeze Period

• Making The Most of Your HA/DR Solutions in the New Year

• Impacts of Outdated Legacy Systems in HA/DR

• Protecting SQL Server from Unexpected Disasters

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

• 3 Common Mistakes IT Pros Make When Working with Backups

• 3 Biggest Blunders from My Botched Backups

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

• Backup Strategies That Can Cause Unexpected Disasters

• 3 Things Your SQL Server HA/DR Solutions Need to Work

• Dealing With External Dependencies The Right Way

• Is Your HA/DR Solution a By-product of Technical Malpractice?

• March 31st is #WorldBackupDay

• Designing and Building Resilient HA/DR Solutions

• Why Developers Need to be Included in HA/DR Discussions

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

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

• "Supported" HA/DR Solutions: What It Really Means

• Unwritten Expectations That Come with HA/DR Solutions

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

• Risks of Having Untrained Operational Staff in Your HA/DR Solutions

• Considerations When Upgrading and Migrating HA/DR Solutions

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

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

• HA/DR Tasks In The Beginning Of The Year

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

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

• Introduction

• The Need for High Availability and Disaster Recovery

• Non-Technology Aspects of HA/DR

• The Alphabet Soup of HA/DR

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

• SQL Server Database Recovery Models

• Demo: SQL Server Database Recovery Models

• Demo: The Risk of Switching Recovery Models

• Database Backups

• Demo: Understanding Multi-base Differential Backups

• Inside the SQL Server Transaction Log

• Demo: Inside the SQL Server Transaction Log

• Demo:Effects of the Transaction Log Filling Up

• Database Restore and Recovery

• Factors Affecting Restore And Recovery

• DEMO:Effects of Instant File Initialization

• Demo: Database Recovery Techniques

• Protecting System Databases

• Demo: Protecting System Databases

• Understanding and Implementing SQL Server Database Mirroring

• Demo: Implementing Database Mirroring - The Simple Way

• Demo: Implementing Database Mirroring on Workgroup Servers - The Hard Way

• Understanding and Implementing SQL Server Log Shipping

• Demo: Implementing SQL Server Log Shipping

• SQL Server Failover Clustering Fundamentals

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

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

• Implementing SQL Server Failover Clustered Instances (2022 Edition) - Part 1

• Implementing SQL Server Failover Clustered Instances (2022 Edition) - Part 2

• Implementing SQL Server Failover Clustered Instances (2022 Edition) - Part 3

• Understanding and Implementing SQL Server Availability Groups

• Demo: SQL Server 2012 Availability Groups Configuration

• Demo: Multi-Site/Geographically Dispersed SQL Server 2012 Availability Groups

• Demo: Successfully Implement SQL Server Always On Availability Groups with FCI

• SQL Server Licensing for your Always On Availability Groups

• SQL Server Replication

• Course Summary