Article – Virtual Earth and SQL 2008 Spatial, a first impression.

johnWeeGo.jpgI just finished my first SQL 2008 Spatial Article for Virtual Earth.

http://www.viawindowslive.com/Articles/VirtualEarth/SQL2008Spatialafirstimpression.aspx

diag2.jpg

It is very introductory taking you though creating a table, importing some basic data and a VE application based on a well structured ASP.NET AJAX Web service model. I do a simple query for points within the current map view. I also add a spatial index. I hope you enjoy it, the full source code and data to import is available.