SQL Azure Billing Numbers Directly From Transact-SQL

Thanks to Karlo Bartels‘s comment on my previous post, here a detailed blogpost on Microsoft.com about the SQL Azure billing numbers/costs with the use of Dynamic Managed Views.

SQL Azure exposes two Dynamic Managed Views called sys.database_usage and sys.bandwidth_usage that show you the activity for your account. These can queried to understand your account usage from a billing perspective.

Database storage costs:

Bandwidth costs:

Download the code right here.

Thanks to Wayne Walter Berry and his post.