SQL Server Availability Groups in Azure VM setup with AAD Domain Services

Reviewed by: Steven Schneider, Sanjay Mishra, Mike Weiner, Kun Cheng, Dimitri Furman, Arvind Shyamsundar, Mahesh Unnikrishnan, and Luis Carlos Vargas Herring Deploying SQL Server Availability Groups in Azure VMs typically involved provisioning two additional VMs to host an Active Directory Domain Controller. With Azure Active Directory (AAD) Domain Services (aka managed domain services on Azure), it… Read more

Large SQL Server database backup on an Azure VM and archiving

Applicable VersionsSQL Server 2014 and lower versions. Background Azure Virtual Machines (VM) allows the capability to install SQL Server and lift/shift an application or data warehouse to the cloud. The largest disk size Azure currently allows is 1tb (or more accurately 1023GB). Larger VMs such as A9 and D14 allows 16 and 32 of these… Read more

Extending AlwaysOn Availability Group to Remote Azure Datacenter (PowerShell)

Author: Steven Schneider Reviewers: Sanjay Mishra, Shep Sheppard, Mike Weiner, Kun Cheng, Rama Ramani, Yorihito Tada, Hongyi Wang If you are looking for multi region continuous availability, by extending your current availability group to a remote Azure datacenter, then this blog is for you. We start with an existing availability group already setup within Azure,… Read more