- Shopping Bag ( 0 items )
Microsoft SQL Server 2008 introduces new geography and geometry spatial datatypes that enable the storage of structured data describing the shape and position of objects in space. This is an interesting and exciting new feature, with many potentially useful applications.
Beginning Spatial with SQL Server 2008 covers everything you need to know to begin using these new spatial datatypes, and explains how to apply them in practical situations involving the spatial relationships of people, places, and things on the earth.
SQL Server developers who wish to use spatial data in Microsoft SQL Server 2008.
Posted October 12, 2010
I picked up this book because I was doing a project for work that uses geocoding, maps and using some of the SQL 2008 spatial features such as selecting records with geo coordinates with in the bounds of a defined polygon. Of course at the time I didn't know anything about the way SQL spatial features worked so I had a lot of trial and error. Had I read just the first 2 chapters of this book back then, I would have saved so much time.
The first two chapters covers everything you need to know about geo spatial. Most interesting was the coverage of elipsoids and geoids that model the unique shape of the earth (no, it isnt round).
I skipped ahead a few times to look at chapters covering geocoding. Unfortuneatley, SQL does not geo code, but the chapter does cover how to write your own .NET CLR function to provide geocoding. Seems like it should have been part of SQL server, but oh well.
The book goes into great detail about each sub topic and the coverage is excellent. It does get into some .NET development, but not to the point that non developers wouldnt be able to handle it.
I recommend this book because it just works. It's an easy and interesting read. I truely thought it would be dry but it isnt.