Configuring SQL Server AlwaysOn Availability Groups in Azure RM Virtual Machines

This week on a project I came up against the need to set up some AlwaysOn Availability Groups (AG’s) for SQL Server 2014 in an Azure IaaS environment, using v2 (or Resource Manager/ARM) based VMs as opposed to the v1 (or Service Manager/ASM) based ones. I came across varying bits of documentation to do with this, but it either didn’t have the ARM PowerShell cmdlets or it was a mix and match of scripts and UI actions which didn’t help me scripting the deployment, so after working through this, there are a few things that I learned. Continue reading “Configuring SQL Server AlwaysOn Availability Groups in Azure RM Virtual Machines”

Cross server DSC dependency options with Azure Resource Manager templates

One of the topics I have been discussing a little lately around the use of the DSC extension for Azure virtual machines is how to create dependencies for DSC configurations that work between servers.If you’re not familiar with how to use the DSC extension in Azure ARM templates have a read of my previous blog post on the topic. Continue reading “Cross server DSC dependency options with Azure Resource Manager templates”

Opening RDP session to an Azure VM with PowerShell

UPDATE (4 March 2015): The method described in this post is now obsolete as a new PowerShell cmdlet Get-AzureRemoteDesktopFile provides this functionality! Check out the documentation at

One of the things I have found myself doing a lot lately is tearing down and rebuilding environments in Windows Azure (using the virtual machines functionality, which is very cool). One of the problems I came across with this approach was that when I would manually create a VM that I planned to keep there I would be able to specify the RDP port to use for remote communication, but the scripts I’m using to prepare several machines at once don’t give me that luxury (although I could probably script updating the end points, I haven’t done that yet). Continue reading “Opening RDP session to an Azure VM with PowerShell”

Managing Windows Azure VMs through PowerShell

I make no secret of the fact that I love PowerShell – all the jokes about it being a mechanism to turn IT Pro’s into developers without them realising it aside, you can do some seriously powerful stuff with it. This week I got my head around a few more things I can script up with it, and the area of focus was on managing my Windows Azure virtual machines. There is an Azure PowerShell module that you can install and configure to be able to easily connect to your subscription (only takes a couple of minutes to set up, the instructions are at and once that’s done you can start getting in to some scripting Continue reading “Managing Windows Azure VMs through PowerShell”