Just like SQL Server, SQL Azure fully supports local transactions. TechNet has released an interesting wiki article more about how SQL Azure handles transactions, as well as describing some of the basics. I would suggest taking a look, just to get more up to date on what capabilities SQL Azure has to offer.
Click here for the article.
Let me know if you would like more article highlights like this in the future. We love hearing from our readers about what topics they want to see next.
Got a suggestion for next time.
Now that we got the Traffic manager that can route traffic between multiple Azure Service in case of a failure in one data center.
How would you handle the SQL Azure part of a application?
Thanks for the feedback. Using the Data Sync Service would be a great way to keep the databases that are collocated in the different datacenters in sync. You can find out more about it at http://www.sqlazurelabs.com.
Hope that helps.
Go TechNet Wiki Go!