Geoweb Guru offers a book review of "Beginning Spatial with SQL Server 2008" by Alastair Aitchison.
From the review: "In conclusion, this is recommended for those who are already familiar with SQL Server but who are looking to us it for geospatial applications or to use it as a backend database for a geospatial web application. It should also prove useful for those with geospatial knowledge who need to use SQL Server's geospatial extensions for the first time. Such readers may find that a general SQL Server book will prove to be a good complement to this text."
On Amazon:[amazon 1430218290 full]