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.
Republished from http://www.sqlserver-dba.com.