Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
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