Select Page
Image result for SQL Server FCI with Availability Groups

Achieving SQL Server HA/DR with a mix of Always On Availability Groups and SANless SQL Server Failover Cluster Instances

Introduction The topic of mixing SQL Server Failover Cluster Instances (FCI) with Always On Availability Groups (AG) is pretty well documented. However, most of the available documentation documents configurations that assume the SQL Server FCI portion of the solution utilizes ... continue reading
image

Tough Questions Answered: How to Move a Physical SQL Always-On Cluster to Different Hardware

Recently I was involved in a troubleshooting on a SQL Always-On failover cluster on a Windows Server 2012R2, and let me say… ”A SPECIAL ALWAYS ON CLUSTER!” PROBLEM DESCRIPTION The customer has a branch office in a remote site, with ... continue reading
LogicalStandard Switch Deployment Failures in System Center Virtual Machine Manager 2016 (UR 6)

LogicalStandard Switch Deployment Failures in System Center Virtual Machine Manager 2016 (UR 6)

___________________________________________________________________________________________________________________________ IMPORTANT ANNOUNCEMENT FOR OUR READERS! AskPFEPlat is in the process of a transformation to the new Core Infrastructure and Security TechCommunity, and will be moving by the end of March 2019 to our new home at https://aka.ms/CISTechComm (hosted at ... continue reading
failover cluster manager console

Configuring Storage Spaces Direct Step by Step: Part 2 Troubleshooting

Introduction This article is the second of a four part series. Configuring Core Cluster Troubleshooting Storage Clusters [this article] Configuring Storage Network Infrastructures Managing Storage Clusters How to Test S2D for Health and Performance This article provides a guideline for performing ... continue reading

Configure SQL Server Failover Cluster Instance on Azure Virtual Machines with MSDTC #SQL #Azure #MSDTC

If you have been following my blog, you probably know that I write a lot of step-by-step guides for building SQL Server Failover Cluster Instances (FCI) on Azure, from SQL Server 2008 through the lastest. Here are some links to ... continue reading

Simplify Always On availability group deployments on Azure VM with SQL VM CLI

Always On availability groups (AG) provide high availability and disaster recovery capabilities to your SQL Server database, whether on-premises, in the cloud, or a combination of both. Manually deploying an availability group for SQL Server on Azure Virtual Machines (VM) ... continue reading
Step-by-Step: How to configure a SQL Server 2008 R2 Failover Cluster Instance in Azure

Step-by-Step: How to configure a SQL Server 2008 R2 Failover Cluster Instance in Azure

Introduction If you are reading this article you probably are still using SQL Server 2008/2008 R2 and want to take advantage of the extended security updates that Microsoft is offering if you move your SQL Server 2008/2008 R2 into Azure ... continue reading
Windows Server 2016/2019 Cluster Resource / Resource Types

Windows Server 2016/2019 Cluster Resource / Resource Types

Over the years, we have been asked about what some of the Failover Cluster resources/resource types are and what they do. There are several resources that have been asked about on multiple occasions and we haven’t really had a good ... continue reading
azure ha

TICK TOCK…6 MONTHS UNTIL SQL SERVER 2008/2008 R2 SUPPORT EXPIRES UNLESS YOU TAKE ACTION

If you are still running SQL Server 2008/2008 R2 you probably have heard by now that as of July 9, 2019, you will no longer be supported. However, realizing that there are still a significant number of customers running on ... continue reading
Windows Admin Center 1809.5 GA Update and Lenovo XClarity extension are publicly available

Windows Admin Center 1809.5 GA Update and Lenovo XClarity extension are publicly available

Windows Admin Center version 1809.5, which was released to Windows Insiders last December, is now publicly available as a GA (Generally Available) update. Version 1809.5 is a cumulative update to our 1809 GA release from last September which includes various ... continue reading