It’s your fault if the SQL Server goes down.
You don’t build a lot of clusters or AGs, and you aren’t confident that your SQL Servers will survive a patching problem, a SAN outage, or a corruption hiccup. Our 6+ hour course has advanced modules on:
- Choosing the right HA/DR features for your needs
- Learning pitfalls to avoid so you can be confident your server will stay up
- Troubleshooting advanced features when they fall apart
- 01. Choosing the Right HA/DR Features: Defining Your RPO and RTO (17m)
- 02. Choosing the Right HA/DR Features: Why Some Options Look So Expensive (12m)
- 03. Choosing the Right HA/DR Features: HA/DR Features Explained (23m)
- 04. Transaction Log Shipping: Log Shipping Overview (17m)
- 05. Transaction Log Shipping: Unplanned Failovers (16m)
- 06. Transaction Log Shipping: Planned Failovers (18m)
- 07. Transaction Log Shipping: Fixing a Lagging Log Shipping Secondary (9m)
- 08. Transaction Log Shipping: Log Shipping Gotchas and Tools (10m)
- 09. Transaction Log Shipping: “Extreme” Log Shipping and Hidden Costs (10m)
- 10. Database Mirroring: Why Database Mirroring is Still Your Friend (13m)
- 11. Database Mirroring: Database Mirroring Rescue Scenarios (12m)
- 12. Database Mirroring: Demo: Failing over a Mirror; Automatic Page Repair (20m)
- 13. Database Mirroring: Monitoring Database Mirroring (8m)
- 14. Database Mirroring: Learning Plan (5m)
- 15. Quorum for Clusters and AGs: What Quorum Is, Why it Matters, and How to Configure It (21m)
- 16. Quorum for Clusters and AGs: Dynamic Quorum and Dynamic Witness (23m)
- 17. Cluster Validation for Clusters and AGs: Demo (11m)
- 18. Failover Clustered Instances: Features, Requirements, and Licensing (20m)
- 19. Failover Clustered Instances: Demo – Failing Over (18m)
- 20. Failover Clustered Instances: Links to Free Online Labs, Install Instructions, Articles
- 21. Always On Availability Groups Planning: Introduction and Sample Deployments (16m)
- 22. AlwaysOn Availability Groups Planning: Horror Stories and Successes (19m)
- 23. AG Failure Triage: Welcome to Triaging AGs (5m)
- 24. AG Failure Triage: Demo: Tour the AG Before It Breaks (7m)
- 25. AG Failure Triage: Demo: Triaging the Broken AG (34m)
- 26. AG Failure Triage: Recap: Why Did Quorum Fail? (5m)
- 27. AG Failure Triage: How You Can Triage Failures in AGs (14m)
- 28. Real-Life Lessons Learned: Brent’s Bug-Out Bag (5m)
- 29. Real-Life Lessons Learned: Role Swap Lessons Learned (9m)