Always On Availability Groups in production.
From architecture to failover, from monitoring to two-site DR, down to real failures and how to fix them. Written by a senior DBA who has run AGs in production for years.
- 96-page PDF manual
- Three-VM lab on free software
- SQL Server 2022 and 2025
The programme
Eight modules that follow the life of a real AG, plus two bonus chapters and a set of appendices to keep on your desk.
- Module 1Always On architecture7 lessons + lab
- Module 2Building the lab6 lessons + scripts
- Module 3Your first Availability Group6 lessons + lab
- Module 4Failover6 lessons + lab
- Module 5Monitoring and diagnosis6 lessons + lab
- Module 6Day-to-day operations6 lessons + lab
- Module 7Multi-site DR6 lessons + lab
- Module 8Real cases and troubleshooting7 lessons + lab
- BonusAdvanced topics and a full case studyTDE, DTC, SSISDB, DAG
- AppendicesGlossary, script kit, runbooks, 30 interview questionsA–G
Who it is for
- DBAs who inherited an Availability Group and want to know what really happens underneath.
- Windows engineers who have to design high availability for SQL Server.
- Developers and team leads who want to know what an AG promises, and what it does not.
- Anyone preparing a senior DBA interview: the appendix has 30 questions with answers.
The lab costs nothing
Three virtual machines on your own PC: a domain controller and two SQL Server 2025 Enterprise Developer nodes. Windows Server evaluation, Hyper-V or VirtualBox, and PowerShell scripts that build it all. No licences to buy.
Read Module 1 before you buy
Cover, programme, lab overview and the whole of Module 1 with its lab and solution. 20 pages, free (in Italian).

Vincenzo Petrucci, founder of Pacific IT Solutions. Senior DBA and T-SQL developer with more than twenty years on critical SQL Server and PostgreSQL systems for banks, insurers and telecom operators.
About us →Questions
What language is the course in?
The first edition is in Italian. The SQL, PowerShell and screenshots are the same in any language, but the explanations are Italian.
What format is it?
A 96-page PDF manual and a ZIP archive with the lab scripts. Read it on any device or print it.
Which SQL Server version do I need?
The course targets SQL Server 2022 and 2025. Almost everything applies from 2016 onwards, and the differences are flagged in the text.
Do I need licences for the lab?
No. The lab uses SQL Server 2025 Enterprise Developer, free for development and testing, and Windows Server evaluation.
Can I get a business invoice?
Yes. Add your company name and VAT number to the order. Pacific IT Solutions s.r.o. is a VAT-registered Czech company.
Can I get a refund?
This is digital content delivered immediately. With your explicit consent to immediate delivery, the right of withdrawal lapses under Directive 2011/83/EU. If the file is faulty or never arrives, we replace it or refund you.
Ready to get your AGs in order?
The full manual, the lab scripts and updates to this edition, for EUR 39.