SQL Azure Federations: Robust Connectivity Model for Federated Data

In this post I wanted to focus on connectivity enhancements that come with SQL Azure Federations. SQL Azure Federation comes with a special FILTERING connection option that makes is safe to work with federated data and is critical for the fully-available-repartitioning component of federations. We’ll take an in depth look at this and build towards…


Great New Whitepaper on SQL Azure and Sharding

Just out… This whitepaper summarizes the sharding technique and highlights the new application modeling best practices for best scalability and economics. Most importantly it focuses on how you can build sharded applications today on SQL Azure. http://social.technet.microsoft.com/wiki/contents/articles/sharding-with-sql-azure.aspx Happy reading…


Evaluating Application Performance and Throughput in SQL Azure

The discussion of performance and throughput came up a few times in discussion with customers at PDC this year. Here are a few important things to understand when evaluating SQL Azure performance. SQL Azure Architecture and Provisioning Model: The details of the SQL Azure architecture and the provisioning model are here: http://msdn.microsoft.com/en-us/library/ee336256.aspx  Key takeaways; SQL…