Geospatial Data Types in SQL Server 2012

The geospatial capabilities in SQL Server are not only powerful, but easy and fun to use! In this session, Lenni shows you how to integrate location-awareness into your own applications with the geometry and geography data types. We’ll explore the planar and geodetic spatial models, spatial markup languages such as WKT and GML, and then put these concepts to use and build several spatial desktop and web applications. Demos show how to integrate with Bing Maps, and how to use the geospatial methods to easily calculate area, length, and distance, and project new shapes based on intersection and overlap. We’ll also cover the latest geospatial enhancements in SQL Server 2012. Attend this session and embrace spatial programming today!
Presented by Leonard Lobel at SQLBits XI
  • Downloads
    Slide deck available Slide Deck 2.4 MB
    Video available MP4 Video Low 105 MB
    Samples available Demo Code 362 KB
    Video available MP4 Video Med 198 MB
    Video available MP4 Video HD 547 MB
  • SpeakerBIO
    Leonard Lobel is a SQL Server MVP and cofounder/CTO of Sleek Technologies, Inc., a New York-based development shop with an early adopter philosophy toward new technologies. Programming since 1979, He is also a consultant, trainer, author, and frequent speaker at local usergroup meetings, VSLive, SQL PASS, SQL Bits, CodeCamp, and other industry conferences worldwide. Lenni is also lead author of three MS Press books, including "Programming Microsoft SQL Server 2012" and "Windows Azure SQL Database Step-by-Step." He can be reached at
  • Video