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…


SQL Azure Federations is open for business!

Wooohooowwwy! Finally the day arrives! The year end update to SQL Azure is live and you can now use federations across all geographies of SQL Azure. There also a great new surprise we have been working on; we are making Federations available through open specification promise. OSP (open specification promise) is a promise not to…


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….


Federation Metadata in SQL Azure Part 3 – Monitoring Ongoing Federation Operations

In part 2 we talked about federation metadata history views. Federation history views only report operation that completed. For monitoring ongoing operations federations provide a separate set of dynamic management views under sys.dm_federation_operation*. All federation operations such as CREATE, ALTER or DROP consist of a set of steps that are executed async. With all async…


Great work Herve!

Not sure if you all know Herve Roggero but he has been a great community leader and MVP driving scalable programming models for the cloud. Here is a quick video he and I recorded to thank him for all the work he put in on SQL Azure and especially on federations. By MVP Award Program…


Coming up at the end of the year in 2011 with SQL Azure…

Hi everyone, hope you enjoyed the keynote this morning on SQL Azure. You can watch the azure section of the keynote here at the 1:25:00 mark. You can also look at that great 3D pie chart over and over again! Had to put that in there! 5 mins taking you through ‘What’s coming to a…


New sample shows how to build multi-tenant apps with Federations in SQL Azure

Nice fresh sample from Full Scale180’s guys called Cloud Ninja. “The Cloud Ninja – SQL Azure Federations Project is a sample demonstrating the use of SQL Azure Federations in creating multi-tenant solutions. SQL Azure Federations can be a useful tool for migrating existing single tenant solutions to multi-tenant cloud solutions, as well as building new…


SQL PASS in Oct, SQL Rally and SQL Server Days in Nov

  Federations is on its way out the door with the next update of SQL Azure. With that, I’ll be on the road performing. Here is the schedule. Stop by, say hi and speak up to talk about your own “federation” stories! SQL PASS – Seattle, WA – Oct 11-14th Migrating Large Scale Application to…