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 TSQL 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).
I also have a comprehensive 60 minute TSQL course available at Udemy : https://www.udemy.com/tsqlfordata...