I am starting to explore Microsoft's SQL Azure service. After reading the SQL Azure documentation, I thought that the SQL Azure service offered a way to get one or more MS SQL databases on a server without having to manage the SQL Server itself. In particular, I assumed that my database would be sharing a SQL Server with strangers. The Microsoft web site says, in part, that SQL Azure is a "multi-tenant database service hosted by Microsoft in the cloud".
So why is it that when I first log into the Windows Azure Platform management page and want to create a database I have to create a new SQL Azure server first? Does this mean that I get my very own SQL Azure server? What if I only want to host one tiny database? Isn't that horribly inefficient?
Perhaps someone can clarify this and give a reference to a Microsoft document or help page that explains this.