Hi,
AlwaysOn Availability Groups (AG) has been around since SQL Server 2012 and today it is widely used in HADR solutions. It also gives us the ability to have readable secondary replicas, allowing read-only access to the respective secondary databases. If you have read-intensive workloads (like reporting, ETL applications, etc.) you can have a significant performance benefit by simply directing those workloads to the secondary replicas.
In this post I’m assuming that you’re already familiar with this “old” feature so I’m not going to elaborate about it.
The thing is that AG is not present in Azure SQL Database (PaaS), so my purpose here is to show how to implement an HADR solution in Azure SQL Database, since we can’t use our well known (and beloved) AG and you’ll see that it’s actually pretty easy 😊
Continue reading “HADR in Azure SQL Database (Part I)”