Chris Pietschmann has released Web.Maps.VE v2.0 . Some of the key features in Web.Maps.VE v2.0 are: Plot Pushpins, Polylines and Polygons with Multiple Shape Layer Support Perform "Find"...
A nice article by Mike Ormond explain SQL Server 2008 native support for spatial datatypes. Read it at Mike Ormond's Blog [Update] You can also refer to the spatial data section and more information about the SQL Server Support for this datatype ...