Select Page
business-critical-service-tier.png

User initiated manual failover on SQL Managed Instance

High availability is a fundamental part of SQL Managed Instance (MI) platform that works transparently for your database applications.  As such, failovers from primary to secondary nodes in case of node degradation or fault detection, or during our regular monthly software ... continue reading
Image 02.PNG

User initiated manual failover of SQL Managed Instance

High availability is a fundamental part of SQL Managed Instance (MI) platform that works transparently for your database applications. As such, failovers from primary to secondary nodes in case of a fault or node degradation, or during our regular monthly ... continue reading
JoshuaLent_0-1586198850488.jpeg

Create a SQL FCI with a Tertiary AG Replica

Procedure The purpose of this guide is to provide the steps needed to deploy a 2-node Windows Server Failover Cluster (WSFC) hosting a clustered instance of SQL Server 2019. A 3rd Windows server running on a separate subnet will also ... continue reading

Windows Server 2019 Failover Clustering New Features

Greeting Failover Cluster fans!! John Marlin here and I own the Failover Clustering feature within the Microsoft product team. In this blog, I will be giving an overview and demo a lot of the new features in Windows Server 2019 ... continue reading
Lab Architecture.png

Build a SQL Cluster Lab Part 4

You are going to create a SQL Server Failover Cluster Instance in Part 4 of our series on how to build a SQL Cluster Lab. The FCI will only be installed on Node1 and Node2. FCIs require shared storage so ... continue reading
Lab Architecture.png

Build a SQL Cluster Lab Part 3

You are going to create a multi-subnet Availability Group in Part 3 of our series on how to build a SQL Cluster Lab. First you give the Cluster Name Object rights in Active Directory and then install your AG. You ... continue reading
Lab Architecture.png

Build a SQL Cluster Lab Part 2

You are going to create a Windows Cluster in Part 2 of our series on how to build a SQL Cluster Lab. You will run cluster validation followed by creating the Windows Server Failover Cluster. In addition, you configure the ... continue reading
Lab Architecture.png

Build a SQL Cluster Lab Part 1

This article is Part 1 in a series of articles showing how to build a SQL Cluster Lab. It covers building a Windows Cluster in Hyper-V that supports both Availability Groups and Failover Cluster Instances. Once you build the environment, ... continue reading

Site-aware Failover Clusters in Windows Server 2016

Windows Server 2016, debuts the birth of site-aware clusters. Nodes in stretched clusters can now be grouped based on their physical location (site). Cluster site-awareness enhances key operations during the cluster lifecycle such as failover behavior, placement policies, heartbeating between ... continue reading
clip_image002

Installing System Center 2012 Configuration Manager RC2 with SQL Server 2008 R2 Cluster

First published on TECHNET on Feb 05, 2012 Authored by Santos Martinez During the past couple of months I have been working with ConfigMgr 2012 RC2 in many ways. Now on in the past couple of days I decide to ... continue reading