SQL Azure July 2011 Service Release

15 July,2011 by Tom Collins

Azure sql server

Key Points

Creating a common foundation between SQL Azure Cloud and Denali. Denali is SQL Server version 11 of the SQL Server Code.
Expanding capability for spatial data types - Geometry data type (Euclidean - flat-earth) and Georgraphy data type (ellipsoidal – round earth).

To interact with the new release , download SQL Server Management Studio (SSMS) , ensuring the version is at minimum 10.50.1777.0.  This allows SSMS to connect with the latest database version.

SQL Azure is the cloud-based version of SQL Server. Based on clustered SQL Servers.
An application, using client libraries such as ODBC, connect through Internet , using TCPIP and TDS to Load Balanced  servers. The Load Balancer forwards sticky sessions to the the TDS protocol tier in the Gateway. 

The Gateway has a TDS protocol layer , enforcing Authorisation, proxy to SQL servers

Billing is based on usage.

Related Posts

SQL Server Version with Powershell

SQL Server Versions

For full details go to :

MSDN announcement

Author: Jack Vamvas (http://www.sqlserver-dba.com)

Author: Tom Collins (http://www.sqlserver-dba.com)


Verify your Comment

Previewing your Comment

This is only a preview. Your comment has not yet been posted.

Your comment could not be posted. Error type:
Your comment has been posted. Post another comment

The letters and numbers you entered did not match the image. Please try again.

As a final step before posting your comment, enter the letters and numbers you see in the image below. This prevents automated programs from posting comments.

Having trouble reading this image? View an alternate.


Post a comment on SQL Azure July 2011 Service Release

sqlserver-dba.com | SQL Server Performance Tuning | SQL Server DBA:Everything | FAQ | Contact|Copyright & Disclaimer