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:      


AlwaysOn Availability Groups Troubleshooting and Monitoring Guide published!

AlwaysOn Availability Groups Troubleshooting and Monitoring Guide provides information on troubleshooting the common AlwaysOn Availability Groups issues and monitoring the availability group health. We will try to keep updating this guide as new troubleshooting scenarios are documented so that you can conveniently find all the information in one place. Please send us feedback on it!


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.