22-25 April 2026 
MSDTC Highly Available
Proposed session for SQLBits 2026TL; DR
You're looking to configure an MSDTC in your highly available environment, but the different ways to set it up are confusing. The choices and paths they each lead you down are convoluted depending on Availability Groups, Failover Cluster Instances, on-prem versus Azure, and even between versions of both SQL and the OS. This session will give you that clarity as we cover everything from how MSDTC works to why the local MSDTC is NOT highly available and how to avoid getting a Suspect Database.
Session Details
You're looking to configure an MSDTC in your highly available environment, but the different ways to set it up are confusing. The choices and paths they each lead you down are convoluted depending on Availability Groups, Failover Cluster Instances, on-prem versus Azure, and even between versions of both SQL and the OS. This session will give you that clarity as we cover everything from how MSDTC works to why the local MSDTC is NOT highly available and how to avoid getting a Suspect Database.
3 things you'll get out of this session
How to prove you are using a highly available MSDTC because just creating one is not enough.
How does the setup change depending on whether you are using an Availability Group or Failover Cluster Instance.
What changes if you implement it in Azure VMs.
Speakers
Ryan Adams's other proposed sessions for 2026
Data Lake, Data Warehouse, Data Lakehouse an Architectural Discussion - 2026