Use SET XACT_ABORT ON to prevent client timeouts from leaving transactions and locks open, with TRY CATCH and a sleeping-session query.
MSDTC and Distributed Transactions Across Linked Servers
Understand MSDTC for linked-server transactions, inspect RPC promotion settings, diagnose coordination errors, and compare simpler designs.
The Outbox Table: Publishing Changes Reliably From a Transaction
Orders commit and the message vanishes? Save both in one transaction, then let a worker claim, send and retry with a lease. Duplicates are still possible.
Idempotent Deployment Scripts: Safe to Run Twice
Build idempotent deployment scripts with guarded schema changes, versioned data fixes, and repeat-run checks for the intended state.
Stopping Duplicate API Requests With an Idempotency Key Table
Store an idempotency key with its order in one transaction, return the committed result on retries, and define key reuse and expiry rules.
SQL SERVER – Identify Oldest Active Transaction with DBCC OPENTRAN
How do you know if there is an open transaction before you restart a server? DBCC OPENTRAN shows the oldest active transaction in your database.
What Is NewSQL? Distributed SQL Databases Explained
What is NewSQL? It’s the name for relational databases that spread data over many servers and still give you SQL and ACID transactions. This post walks one orders table through key ranges, replicas and a majority vote.