SQL Server Failover Clustering in SQL Server 2016 with DNS in Azure
As we know that database mirroring is no longer supported in the latest version of SQL Server i.e. in MS SQL Server 2016. So people are moving toward SQL Server failover clustering as they want to achieve High Availability of database. Here we will setup the things in Azure cloud service, you can enjoy your free subscription of Azure cloud for 1 month. So we can do this in two ways: 1. by using DNS Server which will cost you extra server need more money and maintenance. 2. By using workgroup i.e. without DNS Server this will take less cost in comparison to first one. Best way to do implement SQL Server failover clustering Its all up to your requirement if you have low budget then go without DNS and if have sufficient budget then go with DNS Server extra. Both ways have their own pro and cons so we can't rigid with one way. Steps by Steps to create a SQL Server Always On Availability Group on Azure Virtual Machines. Create resource group 1) Sign in to the