SQL Server AlwaysOn Team Blog

The official SQL Server AlwaysOn team blog.

AlwaysOn Availability Groups: Comparing On-Premises Deployments and Azure VM Deployments

Cross posting from SQLCAT blog:...

Author: Sanjay Mishra Date: 02/05/2014

AlwaysOn Availability Groups, Listener, Named Instances, Port Numbers, etc.

Cross posting from SQLCAT blog:...

Author: Sanjay Mishra Date: 02/05/2014

AlwaysOn Availability Group in Windows Azure VM: Client Connectivity Scenarios

Cross posting from SQLCAT blog:...

Author: Sanjay Mishra Date: 02/05/2014

Published: Troubleshooting Guide for Availability Group Listener in Windows Azure

Before the holidays, this article was quietly published:...

Author: Cephas Lin Date: 01/06/2014

More Windows Azure E2E Scripts!

In case you're not already aware, I've written additional scripts for Windows Azure deployment of...

Author: Cephas Lin Date: 12/05/2013

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

Hello, Please check out the script at...

Author: Cephas Lin Date: 11/22/2013

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...

Author: Cephas Lin Date: 08/06/2013

AlwaysOn in SQL Server 2014 CTP1

Failover Cluster Instances as well as Availability Groups have some great features coming up in SQL...

Author: Sanjay Mishra Date: 07/04/2013

AlwaysOn Availability Groups Troubleshooting and Monitoring Guide published!

AlwaysOn Availability Groups Troubleshooting and Monitoring Guide provides information on...

Author: Cephas Lin Date: 06/06/2013

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...

Author: Cephas Lin Date: 05/30/2013

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...

Author: Cephas Lin Date: 02/14/2013

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...

Author: Cephas Lin Date: 01/23/2013

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...

Author: Cephas Lin Date: 12/18/2012

WSFC Cluster Configuration on Windows Azure Virtual Machines

Windows Azure Virtual Machines (VMs) are currently in preview at www.windowsazure.com. SQL Server...

Author: Cephas Lin Date: 12/03/2012

AlwaysOn at SQLPASS 2012

SQLPASS is next week at the Washington State Convention Center (Seattle). AlwaysOn will again be a...

Author: luis vargas [MSFT] Date: 10/31/2012

How To: Migrate to AlwaysOn from Prior Deployments Combining Database Mirroring and Log Shipping – Part 2

Writer: Cephas Lin (Microsoft) Contributors: Oleg Bulanyy (Microsoft), Jimmy May (Microsoft) This...

Author: Cephas Lin Date: 10/16/2012

How To: Migrate to AlwaysOn AlwaysOn from Prior Deployments Combining Database Mirroring and Log Shipping – Part 1

Writer: Cephas Lin (Microsoft) Contributors: Oleg Bulanyy (Microsoft), Jimmy May (Microsoft) This...

Author: Cephas Lin Date: 10/16/2012

How To: Migrate from Failover Cluster Instances and Database Mirroring to SQL Server AlwaysOn – Part 3

Writer: Cephas Lin (Microsoft) Contributors: Oleg Bulanyy (Microsoft), Jimmy May (Microsoft) NOTE:...

Author: Cephas Lin Date: 09/28/2012

How To: Migrate from Failover Cluster Instances and Database Mirroring to SQL Server AlwaysOn – Part 2

Writer: Cephas Lin (Microsoft) Contributors: Oleg Bulanyy (Microsoft), Jimmy May (Microsoft) NOTE:...

Author: Cephas Lin Date: 09/28/2012

How To: Migrate from Failover Cluster Instances and Database Mirroring to SQL Server AlwaysOn – Part 1

Writer: Cephas Lin (Microsoft) Contributors: Oleg Bulanyy (Microsoft), Jimmy May (Microsoft) NOTE:...

Author: Cephas Lin Date: 09/28/2012

Migration Guide: Migrating to AlwaysOn Availability Groups from Prior Deployments Combining Database Mirroring and Log Shipping

Writer:Cephas Lin (Microsoft) Contributors: Sanjay Mishra (Microsoft) Technical Reviewers: Aditya...

Author: Cephas Lin Date: 08/20/2012

AlwaysOn Architecture Guides

Newly published: two new architecture guides: AlwaysOn Architecture Guide: Building a High...

Author: Sanjay Mishra Date: 07/03/2012

Quickly Setup SQL Server AlwaysOn Failover Cluster Instance (FCI) in Hyper-V

Author: Cephas LinContributors: Oleg Bulanyy Applies to: SQL Server 2008, SQL Server 2008 R2, SQL...

Author: Cephas Lin Date: 06/05/2012

Configure Windows Failover Clustering for SQL Server (Availability Group or FCI) with Limited Security

Author: Cephas LinReviewer: Jimmy May Windows Server Failover Clustering (WSFC) is the new name for...

Author: Cephas Lin Date: 06/05/2012

NOW AVAILABLE: Migration Guide: Migrating to SQL Server 2012 Failover Clustering and Availability Groups from Prior Clustering and Mirroring Deployments

Writer: Cephas Lin (Microsoft) Contributors: Sanjay Mishra (Microsoft), David Smith (ServiceU...

Author: Sanjay Mishra Date: 04/09/2012

Concurrent ADD NODE operation yields unexpected results in a SQL Server Failover Cluster Instance

Please read:...

Author: Sanjay Mishra Date: 03/30/2012

DO NOT use Windows Failover Cluster Manager to perform Availability Group Failover

Please read:...

Author: Sanjay Mishra Date: 03/30/2012

Quorum vote configuration check in AlwaysOn Availability Group Wizards (Andy Jing)

Quorum vote configuration check in AlwaysOn Availability Group Wizards By Andy Jing In this blog, I...

Author: Qiang Wang Date: 03/13/2012

Install the latest AlwaysOn features for ADO.NET(Matt Neerincx)

Matt Neerincx from the SQL Server Data Programmability team discusses installing thelatest AlwaysOn...

Author: Qiang Wang Date: 02/29/2012

Dealing With an Unjoined Database On a Primary Replica

Suppose you force your availability group to failover to a secondary replica, and when you open...

Author: Will Snavely Date: 02/28/2012

Supporting SQL Server 2012 AlwaysOn® in .NET Framework 4 (by Luiz Fernando Santos)

One of the most common questions I get from customers is which version of .NET supports SQL Server...

Author: Qiang Wang Date: 02/17/2012

Monitoring AlwaysOn Health with PowerShell - Part 4 : Integration with SQL Server Agent

Part 4 – Scheduling and Notification with SQL Agent In Part 3, we introduced the problem of...

Author: Will Snavely Date: 02/15/2012

Monitoring AlwaysOn Health with PowerShell - Part 3 : A Simple Monitoring Application

Part 3 – A Simple Monitoring Application for AlwaysOn In Part 1 and Part 2 of this series, we...

Author: Will Snavely Date: 02/14/2012

Monitoring AlwaysOn Health with PowerShell - Part 1: Basic Cmdlet Overview

Introduction The AlwaysOn Dashboard is a very useful tool for determining the overall health of your...

Author: Will Snavely Date: 02/13/2012

Monitoring AlwaysOn Health with PowerShell - Part 2: Advanced Cmdlet Usage

Part 2 – Advanced Usage of AlwaysOn Health Cmdlets In this part, I’ll cover some...

Author: Will Snavely Date: 02/13/2012

The AlwaysOn Health Model Part 2 -- Extending the Health Model

In the first part of this series, we gave a general overview of the AlwaysOn Health model. In this...

Author: Will Snavely Date: 02/13/2012

The AlwaysOn Health Model Part 1 -- Health Model Architecture

After successfully deploying a high availability solution using SQL Server 2012 AlwaysOn, monitoring...

Author: Will Snavely Date: 02/08/2012

How to create multiple listeners for same availability group (Goden Yao)

Blog : How to create multiple listeners for the same availability group As the PM who designed the...

Author: Qiang Wang Date: 02/03/2012

Configuring AlwaysOn with SQL Server PowerShell

In this post, I’ll give examples of PowerShell scripts for configuring your SQL server...

Author: Will Snavely Date: 02/03/2012

Add a Log Shipping Primary Database and Secondary Database(s) to an Existing Availability Group

Add a Log Shipping Primary Database and Secondary Database(s) to an Existing Availability Group by...

Author: Qiang Wang Date: 02/01/2012

NOW AVAILABLE: Microsoft SQL Server AlwaysOn Solutions Guide for High Availability and Disaster Recovery

Microsoft SQL Server AlwaysOn Solutions Guide for High Availability and Disaster Recovery...

Author: Sanjay Mishra Date: 01/26/2012

AlwaysOn: Comparing Readable Secondary with the similar functionality available in DB2

Please refer to...

Author: Sunil Agarwal Date: 01/22/2012

AlwaysOn: I just enabled Readable Secondary but my query is blocked?

Please refer to...

Author: Sunil Agarwal Date: 01/16/2012

AlwaysOn: Making latest statistics available on Readable Secondary, Read-Only database and Database Snapshot

Please refer to...

Author: Sunil Agarwal Date: 01/16/2012

AlwaysOn: Challenges with statistics on ReadOnly database, Database Snapshot and Secondary Replica

Please refer to...

Author: Sunil Agarwal Date: 01/16/2012

AlwaysOn: Impact of mapping reporting workload on Readable Secondary to Snapshot Isolation

Please refer to...

Author: Sunil Agarwal Date: 01/16/2012

AlwaysOn: Minimizing blocking of REDO thread when running reporting workload on Secondary Replica

Please refer to...

Author: Sunil Agarwal Date: 01/16/2012

AlwaysOn: Impact on the primary workload when you run reporting workload on the secondary replica

Please refer to...

Author: Sunil Agarwal Date: 01/16/2012

AlwaysOn: Readable Secondary and data latency

Please refer to https://blogs.msdn.com/b/sqlserverstorageengine/archive/2011/12/22/alwayson.aspx...

Author: Sunil Agarwal Date: 01/16/2012

AlwaysOn: Why there are two options to enable a secondary replica for read workload?

Please refer to...

Author: Sunil Agarwal Date: 01/16/2012

Next>