Tag Archives: sql azure

The Search for a SQL Azure UI Administration Tool

After messing around with a few side projects built on SQL 2008 R2 hosted on DiscountASP, I moved to SQL Azure to test out our new cloud platform.  On DiscountASP, I was spoiled by the fact screenshot_01[1]that they had licenses for myLittleAdmin, which is a web-based UI for SQL server administration. Sure, SQL Management Studio will work, but sometimes it’s great to just have a UI table view to view and edit a single value without writing a SQL statement. Smile

I searched high and low for an alternative that would work against SQL Azure, and found some potential candidates like SQL Maestro but none of them worked against Azure. I kept getting all sorts of random errors.

Microsoft’s own SQL Server 2008 Management Studio is an excellent product that fully supports SQL Azure and has infinite flexibility to create and design tables and stored procedures, but it lacks a good visual way to view and edit table data. Sure, I could write my own SQL queries, but it’s far simpler and faster to edit it in a data-grid like view.

Thanks to Robert McLaws on Twitter, I found out that Microsoft has a community preview of a Silverlight-based admin tool called Project Houston.

The UI is written entirely in Silverlight very slick and easy to use, but the designers definitely went a little overboard with the gratuitous the Silverlight animation effects (ugly cubes that pivot anyone?).  Other than that, it does everything I need from some basic table and stored procedures creation and administration, to browsing and editing data.  For example, I can quickly jump in, view and edit a single value in a specific table or change the properties on a column of a table.

Here are some videos about Project Houston:

Create and modifying tables:

Create, modify, execute, save and open a T-SQL query:

You can read about Project Houston on the SQL Azure team blog or just jump in and try it out if you already have a SQL Azure account.