This weekend I had a look at SQL Server 2008 to find out about the new spatial functions and types that it includes. It has taken some time for Microsoft to include spatial capabilities, but it is here now, and it looks great. However there is no way to work with KML files. So I uploaded the source code to let developers read KML files and Shapefiles into a SQL Server 2008 as SqlGeography objects.
Read More...