MSDN Magazine: Under The Table
Under The Table: Spatial Data Support In SQL Server 2008
Bob Beauchemin - February 2009
New spatial data support in SQL Server 2008 opens the door to mapping and querying geometric and geographic data, allowing you to build exciting new applications.