This content is not currently approved and is visible here for review only.

Pro Spatial with SQL Server 2012

Pro Spatial with SQL Server 2012
Authors
Alastair Aitchison
ISBN
1430234911
Published
16 Apr 2012
Purchase online
amazon.com

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.

Editorial Reviews

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.

Pro Spatial with SQL Server 2012 goes beyond just the database. You’ll learn about standard formats for data interchange, including how to syndicate location-based data using GeoRSS. You’ll learn to visually present query results using outside tools such as Bing Maps and SQL Server Reporting Service’s new Map component. The book also covers C# and .NET support for spatial data, helping you to move data seamlessly between your database and application layers.

  • 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 on all versions of SQL Server 2012
  • Includes the freely-available Express Edition

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
  • Visualize query results through tools such as Microsoft Virtual Earth, Bing Maps, and the SQL Server Reporting Services Map component
  • Pass spatial data seamlessly between database and application layers using T-SQL and C#
  • Overcome common issues with spatial data, 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#.

You might also like...

Comments

Contribute

Why not write for us? Or you could submit an event or a user group in your area. Alternatively just tell us what you think!

Our tools

We've got automatic conversion tools to convert C# to VB.NET, VB.NET to C#. Also you can compress javascript and compress css and generate sql connection strings.

“The greatest performance improvement of all is when a system goes from not-working to working.” - John Ousterhout