Day 22 of my virtual advent calendar, about stuff I like in SQL Server 2008..
SQL Server 2008 now has data types to store points lines and polygons in 2 spatial data type, Geometry and Geography. I have already posted quite extensively on spatial data, but it is is one of my favourite new things in SQL Server so all I am going to do here is point you at my blogcasts:
- Geometry based example,
- SQL Server 2008 and Virtual Earth
- SQL Server 2008 Geo-spatial functions and indexes.
Finally all of this is in all editions of SQL Server 2008, including the free Express editions.