SQL Azure Update – Ability to Move Between SQL Azure Editions Added [News]

SQL Azure Database Service Update 1 has just gone live with several improvements to SQL Azure. Most importantly it is now possible to programatically move between the 1GB and 10GB SQL Azure editions (previously users were forced to do a migration!). This can be done using the following syntax:

ALTER DATABASE database_name

{

MODIFY (MAXSIZE = {1 | 10} GB)

}

Dynamic Management Views (DMVs) have also been added for health and performance monitoring.

In addition, Database Service Update 1 reduces some of the throttling limits – idle connections are now terminated after 30 minutes instead of 5 minutes and long running transactions can be run for longer (but no news on the exact  threshold although it will be longer than the previous 5 minutes).

Related Articles:

• No Related Articles