We have to build custom solution at application level that can handle scale out of underlying SQL Azure databases.
But Microsoft has announced, SQL Azure Federations that will assist scaling out of SQL Azure databases. And scale out means that we are splitting the data into smaller subsets spread across multiple databases.
