Spatial data represents the shape and physical location of an object. For example, the object can be a house, business, sub-division, or a county. SSQL Server 2008 has two new data types GEOMETRY and GEOGRAPHY. GEOMETRY works with flat objects. GEOGRAPHY considers the shape of the earth.
GEOGRAPHY and GEOMETRY or CLR data types. Though to implement them you do not need to have CLR enabled on the SQL Server instance. Microsoft has provided a long list of OGC methods. These are methods that are part of the independent Open Geospatial Consortium list of specifications.
Here is a PDF of my presentation SQLSaturday.pdf (806.55 kb)