Where’s my data? An introduction to Spatial Queries in SQL Server 2008

It is reckoned that 80-90% of data has a spatial component to it. But what do we do with it now? At best, we constrain it to postcodes. Well, that would be great if we were delivering letters, but the majority of us aren’t. In this session we look at Spatial Queries in SQL Server to see how it works and what can be done with it. Here's what Gary Short said about the session when he saw it: - "Colin Mackay's Spatial Data talk last night really rocked! If you get the chance to see it you should."

Colin Angus Mackay

Colin Angus Mackay is a software developer specialising in Microsoft technologies located in Glasgow, Scotland. He is a Member of the British Computer Society, a Microsoft MVP (C#) for three years running, a Microsoft Certified Solutions Developer, the Chairman of Scottish Developers, Code Project MVP for five years running, and has organised two DDD Scotland events (with a third in the making). While not involved in software related pursuits is an amateur photographer (which generally involves wondering why his camera's autofocus mechanism chooses the potted plant off to the side rather than the main subject).

Colin Angus Mackay's blog http://blog.colinmackay.net

---

Downloads

File Type Ext ContentName Presentation .pptx Slide Deck Zip File .zip Demo Code

<< 1 >>

---

Other sessions from this conference

A Testing Time...

A walk down memory lane

Advanced T-SQL (2005 and 2008)

Choices, Choices - Loading and Modelling Slowly Changing Dimensions in the SQL Server 2008 Suite

Data Vizualisation - Make your reports useful to business - No more "Speed Dials"

Does your cube support your users reporting needs?

Don't try this at work !

End to End Report Creation and Management using Microsoft SQL Server 2008

Getting more value from your data through data mining.

Head in the Cloud...

How to approach zero downtime database upgrades

Indexes Basically

Microsoft's integrated end-to-end BI offering.

Performance Monitoring Using SQL Server Management Studio - power of Management Data Warehouse

Small Problem - Simple Solution: Lookup Tables

SQL Server – Under New Management

SQL Server 2008 for Developers

Understanding Query Cache and Query Plans

Useful Sql'y stuff that I've picked up over the years