How to Upgrade an AG Cluster to Windows 2016

Starting in Windows Server 2012 R2 you now have a way to upgrade a cluster to Windows 2016.  The best part is it’s not an OS upgrade, but a rebuild.  The magic is that you can join a Windows 2016 server to a Windows 2012 R2 cluster.  You can upgrade your cluster with as little…

0

SQL Server 2017 Read-Scale Availability Groups

SQL Server 2017 was recently launched, having multiple new features. One of these included something called “Read-Scale Availability Groups”. There was a good bit of discussion about this feature and one of the feedback items was that the details in Docs was very light. I hope to rectify the minimal amount of information through this…

3

SQL Server Workgroup Cluster FCM Errors

Background One of the new features of SQL Server 2016 is the ability to use SQL Server with Failover Cluster in a workgroup rather than joined to Active Directory. When working with SQL Server and Failover Clustering in a workgroup, many of the abilities that are normally used with Active Directory are no longer available,…

0

Finding Which Connections Have Been Read Only Routed

This is a follow up to my first post Finding What Availability Group Listeners Applications Are Using To Connect, where a question was posed about knowing which connections have been read only routed. Background Information SQL Server Availability Groups allow for something called “Read Only Routing” which allows for severs that are currently a secondary…

0

Finding What Availability Group Listeners Applications Are Using To Connect

Background Information While on site helping with AlwaysOn Availability Groups, it was tasked to a DBA to meet with all of the application owners and figure out what listener they were currently using in their connection strings. The DBA looked over at me and said, “I wish there was a DMV that showed me connection…

5

Azure RM: SQL Server AlwaysOn Availability Groups Listener configuration with Azure External Load Balancer

I want to thank to Ruben Gonzalez for his guidance.   This blog post explains how to configure SQL Server AlwaysOn AG with an External Listener in Azure VMs running in Resource Manager model. Pre-requisites Before to start ensures that the environment is ready, deploy VMs in Azure RM model: Create a Resource Group. Create a Virtual…