Last month we held an ISV Innovation Briefing on SQL Server 2008.  One of the great new features in SQL Server 2008 is support for geospatial types.  Working with these new types can be a little tricky at times.  These following links can help you generate the corresponding SQL queries:

Shapefile to SQL Server 2008 - http://www.sharpgis.net/post/2007/12/Shapefile-to-SqlServer-2008-to-WPF.aspx

Virtual Earth to SQL Server 2008 Geospatial Data Generator - http://mikeo.co.uk/demo/sqlspatial/default.aspx

And these two blog post are useful to keep a eye on:

http://blogs.msdn.com/isaac/

http://virtualearth.spaces.live.com/

Thanks,

Jamie