SQL SERVER – What is Spatial Database? – Developing with SQL Server Spatial and Deep Dive into Spati
- by pinaldave
What is Spatial Database?
A spatial database is a database  that is optimized to store and query data related to objects in space, including points, lines and polygons. While typical databases can understand various numeric and character types of data, additional functionality needs to be added for databases to process spatial data types. (Source: Wikipedia)
Today I will be talking about the same subject at Microsoft TechEd  India. If you want to learn about how to spatial aspect of data and how to integrate them with SQL Server this is the perfect session for you. Spatial is very special concept of SQL Server and I really like how it is implemented in SQL Server. In general Performance Tuning and Query Optimization is something I always have enjoyed in my professional life. Index are my best friends and many time, by implementing and many time by removing I have improved the performance of the system. In this session, I will be talking about Index along with Spatial Data. As Spatial Database is  very interesting concept, I will cover super short but very interesting  10 quick slides about this subject. I will make sure in very first 20  mins, you will understand following topics
Introduction to Spatial Database
One line definition
Understanding Spatial Indexing
Index Internals
Query/Performance Tuning
Query Hinting/Cost Analysis
Spatial Index Catalog Views
Performance Troubleshooting
Finding Optimal Index using Spatial Index SP
Common Errors
Index Maintenance
This slides decks will be followed by  around 30 mins demo which will have story of geometry, geography, index internals and performance tuning. If you are interested in learning how GIS works and how SQL Server out of the box supports this wonderful tools, you will really like how the story is told. I am sure all people who attend the event will know how the Bangalore is positioned on the map of India. I will take example of Bangalore and Hyderabad and demonstrate how index can improve the performance. Well there are lots of story to tell in the session, and I will be opening this session with the beautiful script of Botticelli’s Birth of Venus created by Michael J. Swart.
I will also demonstrate few real life  scenario where I will be talking about Spatial Database and its usage.
Do not miss this session. At the end of  session there will be book awarded to best  participant.
My session details:
Session 3: Developing with SQL Server Spatial and Deep Dive into  Spatial Indexing
Date: April 14, 2010 Time: 5:00pm-6:00pm
Microsoft SQL Server 2008 delivers new spatial data types that enable   you to consume, use, and extend location-based data through   spatial-enabled applications. Attend this session to learn how to use   spatial functionality in next version of SQL Server to build and   optimize spatial queries. This session outlines the new geography data   type to store geodetic spatial data and perform operations on it, use   the new geometry data type to store planar spatial data and perform   operations on it, take advantage of new spatial indexes for high   performance queries, use the new spatial results tab to quickly and   easily view spatial query results directly from within Management   Studio, extend spatial data capabilities by building or integrating   location-enabled applications through support for spatial standards and   specifications and much more.
Reference: Pinal Dave (http://blog.SQLAuthority.com)
Filed under: Pinal Dave, SQL, SQL Authority, SQL Index, SQL Optimization, SQL Performance, SQL Query, SQL Server, SQL Tips and Tricks, SQLAuthority Author Visit, T SQL, Technology Tagged: Spatial Database