When I wrote the Spatial SQL (or SQL Spatial, whatever you want to call it, I use both interchangeably for better or worse) blog posts I never mentioned a set of tools that are available which greatly expand the capabilities of the spatial analysis within SQL.
http://sqlspatialtools.codeplex.com/
If you are working with spatial data within SQL Server I encourage you to check this out. I know this works in SQL Server 2008 R2, but I cannot vouch for its usefulness in SQL Server 2012, as I have not used it yet. For a complete list of the functionality available on Codeplex click here.
Until next time, keep on geo-ing!
Pingback: Spatial SQL Tools from Codeplex « Gisdude’s Weblog