Pro Spatial with SQL Server 2012 and over 2 million other books are available for Amazon Kindle . Learn more

Buy New

Sign in to turn on 1-Click ordering.
Buy Used
Used - Good See details
Price: 29.97

Trade in Yours
For a 6.75 Gift Card
Trade in
More Buying Choices
Have one to sell? Sell yours here
Sorry, this item is not available in
Image not available for
Image not available

Start reading Pro Spatial with SQL Server 2012 on your Kindle in under a minute.

Don't have a Kindle? Get your Kindle here, or download a FREE Kindle Reading App.

Pro Spatial with SQL Server 2012 (Expert's Voice in Databases) [Paperback]

Alastair Aitchison

Price: 47.49 & FREE Delivery in the UK. Details
o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o
In stock.
Dispatched from and sold by Amazon. Gift-wrap available.
Want it Thursday, 31 July? Choose Express delivery at checkout. Details


Amazon Price New from Used from
Kindle Edition 28.89  
Paperback 47.49  
Trade In this Item for up to 6.75
Trade in Pro Spatial with SQL Server 2012 (Expert's Voice in Databases) for an Amazon Gift Card of up to 6.75, which you can then spend on millions of items across the site. Trade-in values may vary (terms apply). Learn more

Book Description

4 May 2012 1430234911 978-1430234913
Microsoft SQL Server implements extensive support for location-based data. Pro Spatial with SQL Server 2012 introduces SQL Server's spatial feature set, and covers everything you'll need to know to store, manipulate, and analyze information about the physical location of objects in space. You'll learn about the geography and geometry datatypes, and how to apply them in practical situations involving the spatial relationships of people, places, and things on Earth. Author Alastair Aitchison first introduces you to SQL Server's spatial feature set and the fundamental concepts involved in working with spatial data, including spatial references and co-ordinate systems. You'll learn to query, analyze, and interpret spatial data using tools such as Bing Maps and SQL Server Reporting Services. Throughout, you'll find helpful code examples that you can adopt and extend as a basis for your own projects. Explains spatial concepts from the ground up no prior knowledge is necessary Provides comprehensive guidance for every stage of working with spatial data, from importing through cleansing and storing, to querying, and finally for retrieval and display of spatial data in an application layer Brilliantly illustrated with code examples that run in SQL Server 2012, that you can adapt and use as the basis for your own projects. What you'll learn The fundamental concepts involved in working with spatial data, including spatial references and co-ordinate systems How to create and store spatial data using the geometry and geography data types How to use of spatial indexes in the design of highly-performant databases Write spatial queries to answer practical, business questions Pass spatial data seamlessly between database and application layers using T-SQL and C# Overcome common issues, including how to deal with invalid, imprecise, or erroneous spatial data Apply advanced techniques such as routefinding and clustering Who this bo

Frequently Bought Together

Pro Spatial with SQL Server 2012 (Expert's Voice in Databases) + Beginning Spatial with SQL Server 2008 (Expert's Voice in SQL Server)
Buy the selected items together

Product details

More About the Author

Discover books, learn about writers, and more.

Product Description

About the Author

Alastair Aitchison has more than eight years of experience as a management information consultant, specializing in the design and deployment of online reporting systems. For the last three years, he has been employed as a reporting and analysis manager at Aviva, the world's fifth largest insurance group. In this role, he has championed the use of spatial data in corporate applications including the geographic analysis of risk patterns, plotting the success of regional marketing campaigns, and understanding the impact of major weather incidents. Alastair is a Microsoft Office Specialist Master Instructor and has delivered numerous training courses to individuals and small groups on a range of software packages.

Inside This Book (Learn More)
Browse Sample Pages
Front Cover | Copyright | Table of Contents | Excerpt | Index
Search inside this book:

What Other Items Do Customers Buy After Viewing This Item?

Customer Reviews

There are no customer reviews yet on
5 star
4 star
3 star
2 star
1 star
Most Helpful Customer Reviews on (beta) 5.0 out of 5 stars  4 reviews
2 of 2 people found the following review helpful
5.0 out of 5 stars Excellent Book, great investment 17 July 2013
By Ricky Brundritt - Published on
Format:Paperback|Verified Purchase
I read Alastair's first book on this topic Beginning Spatial with SQL Server 2008 several times and was really looking forward to reading this new book. It didn't disappoint. Lots of great information contained in here which you will be hard pressed to find anywhere else. A great investment for anyone interested in working with Geography or Geometry types in SQL.
5.0 out of 5 stars Great book for GIS and Computer Science 28 April 2014
By Ana - Published on
This book is great. The author describes topics in clear and understandable fashion. This book is very good for GIS/Computer Science practitioners (who are interested in spatial databases). Management of spatial data in RDBMS is an advanced topic in DBMS and this book greatly explains many important topics on spatial databases (in MS SQL Server 2012 which itself is one of the best commercial DBMSs).
5.0 out of 5 stars Superb GIS Book 30 Jun 2013
By Dave - Published on
Format:Paperback|Verified Purchase
This book begins with a nice background on issues surrounding spatial - projections, ellipsoid, spheroid and geoid concepts that are necessary to move on and use the technology correctly. It's about the perfect level of depth of explanation without delaying getting to SQL Server 2012 implementation.
The book then moves into data types. By chapter 4 you're into practical application along with continued explanation. Expect a dense, lengthy read. The graphics are used appropriately - sparingly and to augment the topics being explained. The examples and exercises are helpful and rich.

The breadth of application that this book covers is really impressive. It's a great read for developers and BI folks. Route finding, clustering analysis, shapefiles, spatial indexing, custom assemblies, Bing Maps API, SSRS. The writing style brings this all to you clearly and concisely, which makes it a pleasure to get through so much content and ensures that you have a better chance of retaining it all.

Very impressive book and highly recommended to anyone from novice to experienced spatial analyst/developer.
0 of 3 people found the following review helpful
5.0 out of 5 stars Good book - recommend 27 Jan 2013
By Stephen Fox - Published on
Format:Kindle Edition|Verified Purchase
Good content with plenty of examples. I have the Kindle version. Only gripe is that the kindle version could do with index.
Were these reviews helpful?   Let us know

Customer Discussions

This product's forum
Discussion Replies Latest Post
No discussions yet

Ask questions, Share opinions, Gain insight
Start a new discussion
First post:
Prompts for sign-in

Search Customer Discussions
Search all Amazon discussions

Look for similar items by category