Introduction to spatial queries in SQL Server 2012

The amount of spatial data captured in databases is increasing exponentially. This includes data from mobile phones, GPS units through to home detention bracelets. Typically these devices capture location information in the form of latitudes and longitudes. The spatial capabilities of SQL Server has been significantly enhanced with the release of Microsoft SQL Server 2012. SQL now has some of the best spatial functionality of all the mainstream databases. Spatial queries use different syntax to the T-SQL that traditional queries use. This tutorial will provide an introduction to creating spatial queries that perform tasks such as

- Viewing shapes within SQL Server.
- Calculating the length of direct and indirect routes.
- Area of shapes such as polygons or buffered points
- Whether coordinates fall within a a predefined area such as a polygon, circle or buffered line string.

Demonstration files are available from my website (link provided in video).

[invest]

It was great, the example files allow me to follow along flawlessly.

[andreeag]

It`s my first time I have played with spatial data in SQL and this video was really helpful.
The analogy between SQL data and the map it`s great and easy to understand. Thank you :)

[caynebyron]

Thanks a lot. Even better since I live in Riverhead.

[bcoshea]

Great tutorial, easy to follow and utilize in my own environment. Thank You

[joefergo]

Thanx for the GREAT tutorial.... KICK ASSS

[rogersantos]

Ótimo tutorial! parabéns!
Great tutorial! Thanks!

[amnesia]

wow nice tutorial, I was looking for this topic, thanks!!!

[HomelessOnline]

Thank you, great introduction! How would we answer the question, "does Point X lay within geography shape N?"

[gardysuman]

Hi, Can you help me setting up an Oracle spatial database from scratch?