Interested in using the newly-available GEOGRAPHY data type?  This well-written article provides a detail explanation, with code examples of how to do just that. 

rdoherty's WebLog : Demystifying Spatial Support in SQL Server 2008