Microsoft’s SQL Azure team prepared a new how-to video which talks about basic architectural considerations when developing on SQL Azure.
“This walkthrough provides an overview that you can use to establish best practices and optimize your SQL Azure databases. Specifically, the video discusses standard database optimization techniques, database sharding, and table considerations,” stated the team.
The demo portion of the video shows how to create a clustered index in the Windows Azure portal and shows how to test for latency using SQL Server Management Studio. The conclusion points you to some additional resources to help you get started using SQL Azure.
Take a look at the source code on Codeplex.
[Source: SQL Azure Team Blog]