A practical and comprehensive guide to learning techniques and implementations of the Always On Availability Failover Cluster Instance and Always On Availability Group features in SQL Server from start to finish for High Availability and Disaster Recovery solutions. The discussion in this book starts from the installation of virtual machines (VMs) in Hyper-V, the installation of windows server 2022, the installation of SQL server 2022, the installation of failover clusters in windows, the configuration of always on failover cluster instances, always on availability groups, to real simulations that test the reliability of the always on availability that has been configured.
This book is one of the resources that can be used as a reference to learn techniques and implementation of HA and DR solutions which are compiled with an emphasis on direct practice and based on the author's teaching experience so far, so that readers are expected to better understand it by directly doing many practices. The exercises or simulations performed in this book use SQL Server 2022 Developer Edition for use on the Windows Server 2022 operating system. Of course, it can also be implemented on SQL Server 2025 and Windows Server 2025 or maybe versions below 2022.
Here are the table of contents:
For more information visit the following link on Google Play:
https://play.google.com/store/books/details?id=3_jLEQAAQBAJ
After doing all the practices in this book, it is hoped that readers can implement HA and DR solutions in a real environment so that database services can be accessed anytime and when needed.