SQL Serve 2008: Spatial Data Types
I feel so old fashioned not being able to understand the world of SQL going beyond 2D. I found this great post that proved quite enlightening for the layperson like me. Basically it gives an introduction to what exactly Geospatial data is and it describes 2 new data types coming in SQL Server 2008 (codenamed "Katmai") namely the geography, which supports a round-earth model and geometry, which supports flat-earth data.
Also, in this other article from Directions Magazine, Ed Katibah, the Spatial Program Manager with the SQL Server team talks more about the spatial data types. It even shows how a SQL query to spatial data looks like. Check it out!