All editions of SQL Server 2008 hav the new spatial data type geometry and geography (including express) and if you want to know more about doing interesting stuff with spatial data you really need to get to Microsoft’s offices…

Map picture

on 16 April for a dedicated SQL Server community event on this subject given by spatial experts Johannes Kebeck and Simon Sabin. It’s being run twice , once in the afternoon and then again in the evening so hopefully you can make one of these (please follow the links to register). 

However that may not be possible, for example I will be in Sofia at a Bulgarian Microsoft event, so my other top tip is to check out the new Appress book on this subject as I found it very comprehensive and it is the only dedicated work on this I know of.