SQL Server 2008 - Location Awareness via Spatial Technologies

Microsoft SQL Server 2008 delivers comprehensive spatial support that enables organizations to seamlessly consume, use, and extend location-based data through spatial-enabled applications.

Spatial data represents information about the physical location and shape of geometric objects. These objects can be point locations or more complex objects such as countries, roads, or lakes. SQL Server 2008 introduces two new data types for spatial support, both implemented as common language runtime (CLR) data types.

Geometry represents data in a Euclidean (flat) coordinate system such as a building floor plan.
Geography represents data in a round-earth coordinate system such as GPS latitude and longitude coordinates.

The introduction of these .NET CLR spatial types enables direct manipulation in Transact-SQL, programmatic manipulation in .NET, as well as a host of flexible indexing options.

Lessons

Hands On Lab: Using Spatial Data in T-SQL
The new spatial data type support in SQL Server 2008 allows you to model two types of spatial data: Geometry and Geography. The Geometry data type is used to describe a planar (flat) system such as a building floor plan and the Geography data type is used to describe an elliptical system such as…
Hands On Lab: Using Spatial Data in Managed Code
Spatial data types are implemented using the CLR functionality in SQL Server. This approach hides the complexity of the spatial calculations by providing a couple of types on which there are methods that perform the calculations. This hands-on Lab shows how to use SQL Server Spatial types from…
Demo: Introduction to SQL Server 2008 Spatial Data Types
This demo shows how to use the SQL Server spatial data types with data from the Mondial database, which is a sample database that contains geo-political facts about countries. It includes several tables with latitude and longitude information. The demo shows how to use this information to…
Demo: SQL Server 2008 Spatial Demo
This demo presents the spatial capabilities of SQL Server 2008 integrated with an ASP.NET Web application. The demo stores and performs calculations using the new Geography data types and uses Virtual Earth to consume the spatial data and render it on a map.
Presentation: SQL Server 2008 Spatial Support
SQL Server 2008 introduces support for new data types for storing spatial data. This presentation provides an overview of the main features of Spatial Support in SQL Server 2008.

SQL Server 2008 - Location Awareness via Spatial Technologies

Lessons

The Team