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:...
Date: 02/05/2014
AlwaysOn Availability Groups, Listener, Named Instances, Port Numbers, etc.
Cross posting from SQLCAT blog:...
Date: 02/05/2014
AlwaysOn Availability Group in Windows Azure VM: Client Connectivity Scenarios
Cross posting from SQLCAT blog:...
Date: 02/05/2014
Published: Troubleshooting Guide for Availability Group Listener in Windows Azure
Before the holidays, this article was quietly published:...
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...
Date: 12/05/2013
Availability Group Listener in Hybrid IT: End-to-End PowerShell Script Published
Hello, Please check out the script at...
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...
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...
Date: 07/04/2013
AlwaysOn Availability Groups Troubleshooting and Monitoring Guide published!
AlwaysOn Availability Groups Troubleshooting and Monitoring Guide provides information on...
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...
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...
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...
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...
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...
Date: 12/03/2012
AlwaysOn at SQLPASS 2012
SQLPASS is next week at the Washington State Convention Center (Seattle). AlwaysOn will again be a...
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...
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...
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:...
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:...
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:...
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...
Date: 08/20/2012
AlwaysOn Architecture Guides
Newly published: two new architecture guides: AlwaysOn Architecture Guide: Building a High...
Date: 07/03/2012
Quickly Setup SQL Server AlwaysOn Failover Cluster Instance (FCI) in Hyper-V
Date: 06/05/2012
Configure Windows Failover Clustering for SQL Server (Availability Group or FCI) with Limited Security
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...
Date: 04/09/2012
Concurrent ADD NODE operation yields unexpected results in a SQL Server Failover Cluster Instance
Please read:...
Date: 03/30/2012
DO NOT use Windows Failover Cluster Manager to perform Availability Group Failover
Please read:...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
Date: 01/26/2012
AlwaysOn: Comparing Readable Secondary with the similar functionality available in DB2
Please refer to...
Date: 01/22/2012
AlwaysOn: I just enabled Readable Secondary but my query is blocked?
Please refer to...
Date: 01/16/2012
AlwaysOn: Making latest statistics available on Readable Secondary, Read-Only database and Database Snapshot
Please refer to...
Date: 01/16/2012
AlwaysOn: Challenges with statistics on ReadOnly database, Database Snapshot and Secondary Replica
Please refer to...
Date: 01/16/2012
AlwaysOn: Impact of mapping reporting workload on Readable Secondary to Snapshot Isolation
Please refer to...
Date: 01/16/2012
AlwaysOn: Minimizing blocking of REDO thread when running reporting workload on Secondary Replica
Please refer to...
Date: 01/16/2012
AlwaysOn: Impact on the primary workload when you run reporting workload on the secondary replica
Please refer to...
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...
Date: 01/16/2012
AlwaysOn: Why there are two options to enable a secondary replica for read workload?
Please refer to...
Date: 01/16/2012