Grahaeme Ross

Grahaeme has worked for 25 years in IT, and has experience in application and web development as well as database development and administration. He is currently working at easyJet as a BI DBA.

11 April 2015
11 April 2015

Understanding Cross-Database Transactions in SQL Server

Microsoft 'Always On' technology does not support distributed or cross-database transactions. Why not? Grahaeme Ross shows how to investigate cross-database transactions to understand the problem in more detail, and concludes that a Cross-Database transaction can cause loss of data integrity in the commit phase of the two-phase commit… Read more