Implementing High Availability and Monitoring in Azure SQL Database

Azure SQL Database, a fundamental relational database as a service offering in Azure acts as a source, destination, or even an intermediate storage layer in data engineering pipelines. Azure SQL Database can be used to consolidate data coming from several relational data sources and build mini data warehouses or data marts. Keeping Azure SQL Database in good health and available at all times is of the utmost importance to any organization. In this chapter, we will explore recipes that will help us monitor the health of a database and ensure database availability. By the end of the chapter, you will have learned how to configure replication, an auto-failover group, auditing, monitoring for Azure SQL Database, and high availability for the Hyperscale tier of Azure SQL Database. This chapter has the following recipes:

• Implementing active geo-replication for an Azure SQL database using PowerShell
• Implementing...