Updated Spatial Features in the SQL Azure Q4 2011 Service Release

The Q2 2011 Service Release of SQL Azure introduced the updated spatial data platform from SQL Server 2012. SQL Server 2012 spatial features are being released in SQL Azure in increments, beginning with Q2 2011 Service Release. With the introduction of the Q4 2011 Service Release for SQL Azure, a new TechNet Wiki post, Updated…

1

Potential Side-Effects of Improved Spatial Precision in SQL Server 2012 and the SQL Azure September 2011 Service Release

In Microsoft SQL Server 2012 (previously known as SQL Server Code-Name “Denali”), all constructions and relations are now done with 48 bits of precision, compared to 27 bits used in SQL Server 2008 and SQL Server 2008 R2. This can result in differences that range from how individual coordinates (vertices) in spatial objects appear (rounding)…

1

New Spatial Features in SQL Server Code-Named “Denali” Community Technology Preview 3

We have just released a new white paper, New Spatial Features in SQL Server Code-Named “Denali”.  This white paper covers the spatial improvements added to both CTP1 and CTP3 and becomes the definitive spatial guide to this release of SQL Server. You can download the new server from this location: Microsoft SQL Server code-named ‘Denali’…

3

Spatial Support Coming to the SQL Server Entity Framework

Some of you may not have heard that spatial support is coming in the next version of the SQL Server Entity Framework. Here is the first paragraph from a post on this subject: “One of the highly-anticipated features coming in the next version of Entity Framework is Spatial support. The team has been hard at…

0

Spatial Aggregates in SQL Server Denali

  SQL Server Code-named “Denali” is currently available as a Community Technology Preview (CTP).  Denali introduces 4 new aggregates to the the suite of spatial operators in SQL Server: Union Aggregate Envelope Aggregate Collection Aggregate Convex Hull Aggregate All aggregates are implemented as static methods which work for either the Geography or the Geometry data…

6

Spatial Support for Persisted Computed Columns In Denali CTP1

A few weeks ago, in the whitepaper, New Spatial Features in SQL Server Code-Named “Denali” Community Technology Preview 1, new spatial support for persisted computed columns was presented.  This post will elaborate on this new feature, describing how it is different from prior support in SQL Server 2008. In SQL Server 2008 you could create…

0

Database Compatibility Levels: Getting Existing Spatial Databases Ready For Denali

With the availability of the new SQL Server code-named “Denali” CTP1 release, some of you will be moving existing SQL Server 2008 databases into the new server.  In order to enable the new spatial features in Denali, you will need to update the database compatibility level for existing SQL Server 2008 databases.  For Denali, the…

0