Introduction to Fan-out Queries for Federations in SQL Azure (Part 1): Scalable Queries over Multiple Federation Members, MapReduce Style!

Happy 2012 to all of you! 2011 has been a great year. We now have federations live in production with SQL Azure. So lets chat about fanout querying. What is a fan-out query? Federations provide a model for partitioning parts of your schema over to multiple member databases for harnessing scalability of many nodes. However…


Pricing and Billing Model for Federations in SQL Azure Explained!

Note: the article has been updated with the new pricing model that went into effect in Feb 2012. Now that Federations is live in production, lets talk about how the billing model works for federations. Good news is the model is very simple; With federations, every member can be considered a regular SQL Azure database….


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…