[This article was contributed by the SQL Azure team.]
Jeff Currier, one of our superstar, non-slacker, dev leads has put together some examples for accessing SDS from both C# and Java. The C# example can be found here and the Java one here. In the C# example Jeff also gives a good explanation of our logical server and user database model. Check it out!!!
Any questions, just ask :)