About the Presentation
When GEO meets SQL: Hotwiring Data to Locations
Spatial fields, operators, and functions were introduced in SQL 2008. I will detail how these can be integrated with location-based information in existing data warehouses and marts - and on the cheap. We will briefly discuss the basics (geometry versus geography, geocoding), then move on to the common problems with this task and the remedies.
Session Level: Beginner
Michael Clifford
I started with SQL Server in the late 80’s (and have the version 1 disks to prove it). Most of my focus in the last few years has been in Business Intelligence and health care and spent several years consulting with Analysis Services. Later, I was in the first group to attend the week long BI labs at Microsoft. One of my latest tasks has been to integrate spatial technology into an existing MSSQL data warehouse for a large health plan.
Contact URL:
http://www.mssql-healthit.com