Published: Troubleshooting Guide for Availability Group Listener in Windows Azure

Before the holidays, this article was quietly published: This is a troubleshooting guide for all those going through the joys and pains of configuring the availability group listener in the cloud. There are already guidance on how to configure the listener in Windows Azure or hybrid IT, but no known content that helps you…


More Windows Azure E2E Scripts!

In case you’re not already aware, I’ve written additional scripts for Windows Azure deployment of AlwaysOn Availability Groups for you to play with. Windows Azure provides an ever-expanding set of PowerShell cmdlets, which make automated deployments and administration of SQL Server on IaaS a reality. These scripts are there as proofs of concept to you…


Availability Group Listener in Hybrid IT: End-to-End PowerShell Script Published

Hello, Please check out the script at This script creates a listener for an availability group with replicas both on-premise and in Windows Azure. For information on how to configure the hybrid availability group listener without the script, see As always, feedback is welcome.


Availability Group Listener in Windows Azure Now Supported! (And Scripts for Cloud-Only Configuration)

If you haven’t noticed, AlwaysOn Availability Groups in Windows Azure now supports availability group (AG) listeners. Configuring the AG listener in Windows Azure is a multi-step process that includes: Creating a load-balanced endpoint for the Windows Azure VMs that host AG replicas. Ensuring that hotfix KB2854082 is installed on all cluster nodes (including any node…


AlwaysOn in SQL Server 2014 CTP1

Failover Cluster Instances as well as Availability Groups have some great features coming up in SQL Server 2014. Take a look at Luis’ post on what you can try out with publicly available CTP1:      


Upgrade and Update Guide for AlwaysOn Availability Groups published!

The upgrade/update guide for availability group servers is now live on MSDN. Upgrade and Update of Availability Group Servers with Minimal Downtime and Data Loss It shows how to upgrade/update to any major, minor, service pack, or update release with minimal downtime in multiple deployment scenarios.


HADR Tutorials for SQL Server in Windows Azure VMs

Hi Folks, For those interested in how to do SQL Server HADR in Windows Azure VMs, we have published a set of tutorials on Azure Documentation. A conceptual article gives you the overview for the subject and the tutorials show you how to set up specific scenarios end-to-end. The docs are currently in pre-release mode….