Distributed transactions are one of the more powerful and important functions within SQL Server. A distributed transaction is just like any other transaction within the SQL Server database, with a ...
TiDB is a prime example of an intrinsically scalable and reliable distributed SQL database architecture. Here’s how it works. In the good old days, databases had a relatively simple job: help with the ...
Microsoft SQL Server MVP Denny Cherry breaks down multiple ways on how to troubleshoot a type -2 blocking session ID error. When we look at sessions being blocked in ...