Wiki: Billing Numbers Directly From Transact-SQL
[This article was contributed by the SQL Azure team.]
SQL Azure exposes two Dynamic Managed Views called sys.database_usage and sys.bandwidth_usage that show you the activity for your account. This wiki article shows you how to use them to understand your account usage from a billing perspective.