Opinions, tips, and news orbiting Microsoft
First published on MSDN on Jul 13, 2018 Recently a customer reported an interesting issue, while querying against recently added readable replica, SELECT statement is shown as suspended and session is shown as waiting on HADR_DATABASE_WAIT_FOR_TRANS… Continue reading AlwaysOn Availability Groups: Wait Type HADR_DATABASE_WAIT_FOR_TRANSITION_TO_VERSIONING
First published on MSDN on Jul 05, 2018
Configure SQL Server Failover Cluster Instance
If you are running a SQL Server Failover Cluster Instance on premises and looking to migrate to Azure, you might be a little intimidated. This architecture is a b… Continue reading Configure SQL Server Failover Cluster Instance on Azure Virtual Machines with MSDTC
First published on MSDN on Jul 05, 2018
What is a Domain Independent Cluster?
Did you know that you can have a Windows cluster that is a domain independent cluster and run a SQL Server Availability Group on top of it? The technology has been a… Continue reading Domain Independent Cluster and Availability Group
First published on MSDN on Jul 05, 2018
What is a Read-Scale Availability Group?
A Read-Scale Availability Group is a Clusterless Availability Group. It’s sole purpose and design is to scale out a read workload. More importantly is what … Continue reading Read-Scale Availability Group Setup
First published on MSDN on Jul 05, 2018
The MSDTC Configuration Conundrum
MSDTC configuration is not as straight forward as you might think. It’s a different choice if you are using a local MSDTC, clustered MSDTC, on-premises, Azure, Failover C… Continue reading MSDTC Supported Configurations
First published on MSDN on Apr 02, 2018 How do you monitor Azure Analysis Services? How many users are connected and who are they? These are great questions to understand around your AAS environment. While metric data is exposed via the Metrics blad… Continue reading Monitoring Azure Analysis Services with Log Analytics and Power BI
First published on MSDN on Dec 08, 2017 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 serv… Continue reading How to Upgrade an AG Cluster to Windows 2016
First published on MSDN on Nov 17, 2017 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… Continue reading SQL Server 2017 Read-Scale Availability Groups