Tuesday, August 2, 2011

SQL Azure - July 2011 Service Release

In order to improve performance and scaling an update is in process spanning all the global data centers. The upcoming enhancements are not released but will be announced towards the end of the year. This is an important release as it targets the underlying engine. It is also important as it provides a common ground for SQL Azure and the near future release of SQL Server 11 - presently known with the code name  'Denali'.

The new release will support multiple data base administrators (Ye! Windows Azure is not going taking away your jobs, you just need to upgrade your skills). Also much better support for spatial data types making it a perfect fit for location aware apps both mobile and immobile.

The one thing that needs to be done on your side is the following: you should get hold of the latest version of SQL Server Management Tools, because the version number will change. Many users of lower versions might have already noted this while trying to connect to 'Denali' from older versions. The links to get the latest updates available in SQL Server 2008 R2 SP1 are:

    * SQL Server Management Studio (http://www.microsoft.com/download/en/details.aspx?displaylang=en&id=26727)
    * SQL Server Management Studio Express(http://www.microsoft.com/download/en/details.aspx?displaylang=en&id=26729)

If you are using SMO (SQL Server Management Objects) then you should get the
Cumulative Update package 7 for SQL Server 2008 R2                                                              (http://support.microsoft.com/kb/2507770)
When all is said and done your version of SSMS should have a version greater or equal to 10.50.1777.0 in order not to have connectivity issues.

This one is for SSMS that came with SQL Server 2008 R2: No good!

This one is for SSMS installed when CTP1 'Denali' was installed:

Clearly if I use the above I should not have any connectivity problems.

If you are a DBA trying to upgrade your skills to understand SQL Azure, my book is a must read. You could get a free copy by sending an email to me at mysorian@gmail.com with 'SQL Azure' in the subject line. Who knows you may be lucky and get a book or a ebook in the raffle.