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…

0

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

Hello, Please check out the script at http://gallery.technet.microsoft.com/scriptcenter/Create-Availability-Group-3fc1ca5e. 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 http://msdn.microsoft.com/en-us/library/dn425027.aspx. As always, feedback is welcome.

2

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…

5

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: http://blogs.technet.com/b/dataplatforminsider/archive/2013/06/27/alwayson-in-sql-server-2014-ctp1.aspx      

3

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!

2

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.

1

Connecting to Availability Group Listener in Hybrid IT

In this blog, I’d like to explore client connectivity strategy when you have an availability group that spans both your on-premise servers and Windows Azure VMs. From the outset, I should clarify that the availability group listener is not supported in Windows Azure at the moment, which contributes to the interesting scenario in hybrid IT…

3

Test Lab: Create an AlwaysOn Availability Group in Windows Azure End-to-End

In this blog, you will learn how to configure AlwaysOn Availability Groups end-to-end using Windows Azure VMs. The steps here are the GUI near-equivalent of the script-based tutorial, which has been published at Tutorial: AlwaysOn Availability Groups in Windows Azure. The end-to-end test lab is designed to help you go through all the basic paces…

13