The July 2011 SQL Azure Service Release is coming up with significant upgrades to the underlying engine designed to increase overall performance and scalability. This upgrade is also significant in that it represents a big first step towards providing a common base and feature set between the cloud SQL Azure service and upcoming release of SQL Server Code Name "Denali"," revealed Windows Azure team.
"The upgrades will be done in coming weeks in all global datacenters. As the datacenters get upgraded, the version number of the database engine will increase and co-administrator support will enable customers to specify multiple database administrators, and SQL Azure will have increased capability for using spatial data types, making it the perfect cloud database for location-aware cloud and mobile applications," the team stated.
"To prepare for the service release, customers and developers must download latest updates to SQL Server Management Studio tools to avoid connectivity issues connecting to database and for managing your SQL Server and SQL Azure databases. Users who only use the database manager tools in Azure developer portal will be unaffected."
Applications running in Azure, on-premises, or with a hoster that interact with data in SQL Azure will be unaffected and will continue to work normally.
The links to get the latest updates available in SQL Server 2008 R2 SP1 are:
Applications that utilize SQL Server Management Objects (SMO) will need to apply the Cumulative Update Package 7 for SQL Server 2008 R2.
"If you encounter connectivity issues with SSMS over the next few weeks, please double-check that you've the latest updates. To verify you've latest version of SSMS, open the tool, click on the help menu, and select "About". You'll get a dialog box listing version numbers of various SQL Server components. The first row, "Microsoft SQL Server Management Studio" should have a version greater or equal to 10.50.1777.0 once you've installed the updates," explained Azure team.
[Source: Windows Azure]