How much space does each table take up?

In the DevOps world space matters, especially when you are using PAAS databases in the cloud such as Azure SQL Database (aka SQL Azure) where there can be tight space limits per database.  One useful way to keep track of how much space each table (and accompanying indexes) take up is to use a query…


SQL Azure Management Pack CTP2 Now Available on the Download Center

The first exciting news I have in the operations and manageability space is that there is now a management pack for monitoring SQL Azure based databases available as a public customer technology preview (CTP)! You can find the bits on the download center here: http://www.microsoft.com/download/en/details.aspx?id=28951 If you haven’t heard of SQL Azure definitely go to…


AdventureWorks Community Sample Databases available for SQL Azure

It is a delight to announce the availability of the AdventureWorks Community Sample Databases for SQL Azure.  You can download the scripts and data files from CodePlex.  To install the databases on your SQL Azure server just follow the directions on the release page at CodePlex or in the ReadMe.htm file which is included in…