Directions Media has learned that Microsoft has just released, internally, the first public beta of SQL Server 2008 (code named “Katmai”) with support for spatial. This Community Technology Preview (CTP) is the long-awaited CTP-5 and should show up on the Microsoft web site as the “November CTP.” Read more…
Here are the highlights of CTP-5 with particular emphasis on their support for spatial datatypes:
The new GEOGRAPHY and GEOMETRY datatypes provide spatial data support for location-aware applications. These types can be used to store locations, as well as paths and regions in space, and provide a set of functionality for comparing and manipulating these objects.
Users will utilize the GEOGRAPHY type when working with latitude and longitude coordinates in a true round-earth model; use of the GEOMETRY type will be utilized when working in projected planar surfaces, as well as naturally planar systems such as interior spaces.
These types are supported by new spatial indexes, which provide for fast execution of queries involving spatial data. The query optimizer has been enhanced to build-in knowledge of spatial indexes and types, so that appropriate cost-based plan decisions can be made.
Other specific enhancements to the CTP-5 release include: