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

Buy New

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

or
 
   
Trade in Yours
For a 9.95 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
Colour:
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 Saturday, 26 April? Choose Express delivery at checkout. Details

Formats

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

Book Description

11 Jun 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 book is for

Pro Spatial with SQL Server 2012 is the go-to book for anyone involved in spatial applications involving Microsoft SQL Server 2012. The book helps database administrators create and optimize the performance of spatial database. The book gives developers what they need to know in order to make effective use of the extensive support for location-based data provided by SQL Server, T-SQL, and C#.

Table of Contents

1. Spatial Reference Systems

2. Spatial Features

3. Spatial Datatypes

4. Creating Spatial Data

5. Importing Spatial Data

6. Geocoding

7. Precision, Validity, and Errors

8. Transformation and Reprojection

9. Examining Spatial Properties

10. Modification and Simplification

11. Aggregation and Combination

12. Testing Spatial Relationships

13. Clustering and Distribution Analysis

14. Route Finding

15. Triangulation and Tesselation

16. Visualization and User Interface 

17. Reporting Services

18. Indexing

19.

  






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 Amazon.co.uk.
5 star
4 star
3 star
2 star
1 star
Most Helpful Customer Reviews on Amazon.com (beta)
Amazon.com: 5.0 out of 5 stars  3 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 Amazon.com
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 Superb GIS Book 30 Jun 2013
By Dave - Published on Amazon.com
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 Amazon.com
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
ARRAY(0xabd6a480)

Customer Discussions

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

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

Search Customer Discussions
Search all Amazon discussions
   


Look for similar items by category


Feedback