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

  • Article

Writers: Ed Katibah (Microsoft) and Milan Stojic (Microsoft)

Technical Reviewers: Marko Tintor (Microsoft), Michael
Kallay (Microsoft), Michael Rys (Microsoft) and Bob Beauchemin (SQLSkills)

Summary

The new spatial features in SQL
Server Code-Named “Denali” CTP3 augment the spatial features presented in
“Denali” CTP1. Collectively, the spatial features in CTP1 and CTP3 represent a
significant milestone in the evolution of SQL Server spatial data support. New
features include support for full globe spatial objects and circular arcs on
the ellipsoid, industry firsts for relational database systems. The geography data
type has achieved parity relative to the function and variety of methods that
support the geometry data type. Overall performance, from spatial indexes to
methods, has been significantly increased. These and other improvements to
promise a significant step forward in spatial prowess of the next generation of
SQL Server.

To review the white paper, please
download the New Spatial Features in SQL Server Code-Named
"Denali" Word document.