Congratulations, you’re the DBA. Along with all the rights, privileges, and prestige that comes with that. It also means you are responsible for not only the uptime and guaranteed availability of your database servers but also the ability for any of those servers to quickly recovery from any disaster imaginable. Supporting these two areas are without a doubt some of the most fundamental skill-sets necessary to being a successful senior level DBA. This course will compare and contrast the many features, techniques, and concepts available in SQL Server that will meet your individual needs whether you work in a multi-million dollar enterprise or a “strapped for cash” start-up.
Author Name: Russ Thomas
Author Description:
Currently an IT leader in Denver Colorado’s FinTech sector Russ has focused on database engineering, modelling, administration, and BI since 1997. Russ is a passionate trainer and community volunteer presenting regularly at tech events and local user groups around the US. In 2019 much of Russ’ focus turned to cloud based data lakes specifically on Google BigQuery, and the emerging world of large language models.

Table of Contents

• Understanding High Availability vs. Disaster Recovery
  11mins
• Getting Familiar with the Transaction Log
  19mins
• Taking Backups and Implementing Log Shipping
  39mins
• Setting up Failover Clustering
  59mins
• Supporting Legacy Mirrors
  36mins
• Installing and Supporting AlwaysOn Availability Groups
  64mins
• Understanding Additional Approaches
  34mins
• Bringing It All Together
  14mins