SQL Clustered Instance

SQLServerCentral Article

Windows Clustered MSDTC and SQL Server 2019 mishap

  • Article

Introduction As you may know, in the early days of SQL Server Clustering, Microsoft advised to provide each clustered SQL Server instance with its own Microsoft Distributed Transaction Coordinator (MSDTC) resource. Since SQL Server 2012 this advice has been withdrawn. Microsoft now recommends to provide your instance with its own MSDTC resource, once you notice the […]

5 (4)

You rated this post out of 5. Change rating

2025-04-04

2,385 reads

Blogs

Free SQL Practice: 9 Killer Resources to Boost Your Query Skills

By

So, you want to get your SQL skills razor-sharp without dropping any cash? You're...

DevOps Devour Hour Slides

By

Here are the slides from my talk today at the Redgate NYC Devour Hour:...

Advice I Like: Take Two Trips

By

If you have any doubt about being able to carry a load in one...

Read the latest Blogs

Forums

Is there an ISERROR equivalent in SS?

By water490

Hi everyone I have a SP that just failed.  Format of SP is: Select...

Analyzing Tempdb Spills and Usage Across Recursive Queries

By shukla.chandan12

Comments posted to this topic are about the item Analyzing Tempdb Spills and Usage...

Creating a new API in Data API Builder

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Creating a new API in...

Visit the forum

Question of the Day

Creating a new API in Data API Builder

If I run "dab init" to create a new API over a database, what parameters are required?

See possible answers