I've always thought that the support for spatial data types that was added in SQL Server 2008 was one of the best parts of that release.
In SQL Server 2012, a great set of enhancements were made to the spatial support.
We've had lots of interest lately in SQL Server spatial so we've been working on a new course that targets it specifically. We're pleased that we've now added a brand new one day SQL Server Spatial Core Skills course to our list of regularly scheduled courses. It covers a wide variety of topics from understanding the data types, to loading data, geolocation, indexing, etc. It also covers the enhancements that were made in 2012.
The first public schedule for this course is April 14th in Melbourne. Details are here: http://www.sqldownunder.com/Training/Courses/21