SQL Server Always On Availability Groups: The Senior DBA’s Ultimate Field Guide

Worried and nervous about meeting deadlines on deploying your SQL Server Always On solution? Struggling with lack of confidence on your design? Are outages taking over your personal life that you can no longer focus on the things that really matter?

I’ve got you covered.

You need to deploy or manage a SQL Server Always On Availability Group but do not have a clue about where to start. The Microsoft documentation isn’t helping and you are wasting a lot of time figuring things out on your own. You lack the confidence to deal with it because you feel like you have inadequate knowledge. What’s worse is that unexpected Always On Availability Group outages are taking over your personal life, causing too much stress and anxiety. And you’re worried that the next outage could cost the company loss of revenue and, potentially, your job.

This is specifically for you. This program is specifically designed for senior database administrators and systems engineers responsible for deploying and managing a SQL Server Always On Availability Group.

In this live 10-week hybrid training, consulting, and coaching program, you will learn:

- 1) The simple and easy way to understand Windows Server Failover Clustering (WSFC) – the underlying platform that makes SQL Server Always On Availability Group possible – from the external dependencies like Active Directory and DNS to quorum and cluster configuration

- 2) How to design and implement a stable, reliable and highly available Windows Server Failover Cluster to meet both high availability and disaster recovery requirements

- 3) How to design and implement a stable, reliable and highly available SQL Server Always On Availability Group solution for a single- or multi-data center deployments from the most common topologies without reinventing the wheel

- 4) How to leverage additional SQL Server Always On Availability Group capabilities such as readable secondary replicas, backup preferences, distributed availability groups and basic availability groups while minimizing Total Cost of Ownership (TCO)

- 5) Effective management and monitoring of SQL Server Always On Availability Group implementations

6) The secret to effective troubleshooting of availability issues for both the Windows Server Failover Cluster and the SQL Server Always On Availability Group

About the instructor: Edwin M Sarmiento is a 12-year former Microsoft Data Platform MVP and Microsoft Certified Master from Ottawa, Canada specializing in high availability, disaster recovery and system infrastructures running on the Microsoft server technology stack. He is very passionate about technology but has interests in music, professional and organizational development, leadership and management matters when not working with databases.

Consulting Time: You can share your (sanitized) architecture diagram with the group for open consulting. You can ask for feedback about why the design might not be achieving your objectives, and get Edwin’s recommendations to improve your uptime. Don’t want to share your company’s design? No problem – you can still learn from watching the architectures and questions from other members. You can even ask about urgent production-facing issues that need quick solutions.

OPTION #1: Payment plan – 50% now and 50% in 30 days

US$ 10,000

OPTION #2: One-time Payment

US$ 9000

This is a live online program. We host it in GoToMeeting, live with Edwin M Sarmiento on webcam, with a 10-minute break. Audio can come through either your computer audio, or by dialing into a US phone number – headset recommended either way.