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 more14 June 2012
Continuous integration is becoming increasingly popular for database development, and when we heard of an implemention of a system based on TeamCity, TFS, SQL Source Control, SQL Compare, and SQL Data Compare, we were interested to find out more. Grahaeme Ross gives a practical guide to how it was achieved.… Read more
Join Simple Talk
Join over 200,000 Microsoft professionals, and get full, free access to technical articles, our twice-monthly Simple Talk newsletter, and free SQL tools.