[EN] Sample database to play with geography data type
So, you want to see some nice maps in Spatial Results tab of your SSMS console of just installed SQL Server 2008 RTM?
Perhaps something like below:
Well, it’s not that hard :-) Just use sample SpatialDB database I have prepared. It contains just one table – dbo.Countries. The data comes from FreeGIS Worlddata and has been loaded with Shapefile Uploader.
So, step by step:
1. Download and restore backup of SpatialDB database (1.5MB zip, backed up with compression).
2. Execute some simple query, e.g.: SELECT name, geom FROM SpatialDB.dbo.Countries.
3. Use your imagination and Books Online to play with all methods of geography data type.
4. Send all bugs and suggestions to http://connect.microsoft.com :-)
Have fun with spatials!
And for Polish readers - some thoughts on SQL Server 2008 RTM by Marcin Guzowski: http://strefa.guzowski.info/archives/112,2008,08,08.html.