I just had some time on my hands to try out the new Windows Azure feature called SQL Azure Federations. While it is not fully obvious from the name, SQL Azure Federation basically enables building elastic and scalable database tiers.
Your application can now scale beyond a single SQL Azure database and use the capacity of 10s or 100s of nodes. The nicest part is that administrators can play with federations and database capacity without any application downtime (pretty amazing! – try that in your database cluster if you dare ).
As stated on this great blog post, SQL Azure Federations provide four key benefits:
Besides the blog I would also encourage you to invest 5-minutes to view this video about SQL Azure Federations.
With this feature set relational databases on top of Windows Azure platform really don’t have any (size) limitations… even the sky can’t be the limit as we are already in the clouds .