If you want to see how much size has you used in your SQL Azure database, you can definitely see it on the SQL Azure Developer Portal as shown below.
However, for some reason, sometimes you would either need to get the size more precisely or retrieve the numbers programmatically.
Calculating Database Size
Here’s the query for you to retrieve the size of your database.
After running in on my SQL Server Management Studio R2, here’s the result:
Calculating Each Table in the Database
If you need to explore in more detail how much size for each table, you can also use the following query to see.
You may want to learn more about SQL Azure tips and tricks, be sure to check out the following posts:
Hope this helps.