THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |
in Search

John Paul Cook

SQL Server 2008 Spatial Data

Once you start investigating SQL Server 2008 spatial features, you quickly discover that there are three problems:

  1. Loading useful data.
  2. Writing spatial queries.
  3. Seeing the results.

It's very easy to experience scope creep while sorting things out. For the absolute novice beginner, it's best to keep things simple. Loading real world datasets is something that can be deferred until a later day. The examples in SQL Server Books Online are simple and demonstrate what can be done. So, to get started, the only missing piece is a tool to let you see the query results visually. Free is a very appealing price point, so I recommend downloading and using Morton Nielsen's free viewer.


Published Tuesday, January 22, 2008 12:21 AM by John Paul Cook

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS



ktegels said:

Morten also has a Shape File to SQL Server tool data thats very useful for problem number one. So is SSIS, but it takes some code.

Querying is the fun thing to learn, I agree, but once you have the OGC methods down, its pretty cool.

Visualization is key thing. Somebody with a big brain is going to figure out how to render maps in Reporting Services. And they are going to make a pretty penny selling it... :)

January 23, 2008 4:48 PM

Leave a Comment


About John Paul Cook

John Paul Cook is a database and Azure specialist in Houston. He previously worked as a Data Platform Solution Architect in Microsoft's Houston office. Prior to joining Microsoft, he was a SQL Server MVP. He is experienced in SQL Server and Oracle database application design, development, and implementation. He has spoken at many conferences including Microsoft TechEd and the SQL PASS Summit. He has worked in oil and gas, financial, manufacturing, and healthcare industries. John is also a Registered Nurse currently studying to be a psychiatric nurse practitioner. Contributing author to SQL Server MVP Deep Dives and SQL Server MVP Deep Dives Volume 2. Connect on LinkedIn

This Blog



Privacy Statement