MSDN Webcast: Building Spatial Applications with SQL Server 2008 (Level 300)
The word's getting out there (a little too slowly for my liking, but anyway ...): SQL Server 2008 will have spatial data support built-in. The first CTP to have this feature enabled should be CTP5 (due out any day now).
In the mean time, Isaac Kunen and Michael Rys have recorded a webcast with some great information.
View it here