What's the Quarantine state in Windows Failover Clusters

In this article we cover why Windows Failover Cluster nodes can go into a quarantined state, how to resolve this as well as how to set threshold values for this cluster node state.

Preferred Node Policy-Setting on Traditional SQL Cluster

Preferred node setting facilitates instances on traditional cluster to be on the correct nodes which will lead to load-balancing of the resources.

Change the Collation Setting for Clustered SQL Server 2014 Instance

In this post I will show a procedure to change collation settings of SQL Server 2014 cluster instance.

SQL Server Restart or Cluster Failover Notification

How to create an automatic SQL restart or failover notification.

How to Add a Drive as a Clustered Physical Disk Resource in Windows

This article is covers how to add a drive as a Clustered Physical Disk Resource in Windows 2003.

SQL Server 2014 Clustered Maximums

Managing MaxMemory Values on an Active-Active Two Node Cluster

How to manage your MaxMemory values on an Active-Active two node cluster.

Error during installation of an SQL server Failover Cluster Instance

A common issue I've run into while helping with SQL Server Failover Cluster (FCI) installations is the failure of the Network Name. In the following post I'll discuss a bit of background, the common root cause, and how to resolve it.

Monitor SQL Instance Balance across Windows Cluster Nodes Using PowerShell

This tip will demonstrate how to monitor SQL Failover Cluster Instances if they become unbalanced using Windows PowerShell.

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

This paper provides guidance for customers who prior to SQL Server 2012 have deployed SQL Failover Clustering for local high availability and database mirroring for disaster recovery, and who want to migrate to SQL Server AlwaysOn. It describes the corresponding SQL Server AlwaysOn scenario and the migration paths to SQL Server AlwaysOn. It also contains the important knowledge and considerations that you must know in order to successfully migrate to a HADR solution based on SQL Server AlwaysOn technology, which implements AlwaysOn Failover Cluster Instances for high availability and AlwaysOn Availability Groups for disaster recovery.