SQL Server 2019 AlwaysOn is intended to be a quick start guide for DBAs who need to
implement high availability and disaster recovery for their SQL Server workloads.
The book begins with a discussion of high availability concepts and methodologies,
before a high-level overview of HA/DR technologies. Then, it’s into the detail. We will
discuss how to create Windows clusters, before looking at how to create SQL Server
AlwaysOn Failover Clustered Instances.
The focus of the book then turns to AlwaysOn Availability Groups. Here, the book
discusses how to create and configure Availability Groups for high availability and
disaster recovery, both on Windows and Linux operating systems.
We then look at atypical use cases for AlwaysOn Availability Groups, such as
clusterless and domain-independent availability groups, as well as configuring
Availability Groups on Azure IaaS and Basic Availability Groups, for SQL Server Standard
Finally, the book looks at the operational side of AlwaysOn, with chapters covering
the administration, monitoring, and troubleshooting of the technology.