22-25 April 2026 
SQLBits 2013
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, learn how to integrate location-awareness into your own applications with the geometry and geography data types.
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!
Speakers
Leonard Lobel's previous sessions
Securing Azure Cosmos DB
Implement network security with the IP firewall, VNet access, and private endpoints, understand the various authentication options using master keys, resource tokens and Azure AD integration, learn about built-in server-side encryption, and how to configure client-side encryption using Always Encrypted.
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, learn how to integrate location-awareness into your own applications with the geometry and geography data types.
Native File Streaming with SQL Server 2012
This dynamic session will teach you how to use FILESTREAM and FileTable using T-SQL and the OpenSqlFileStream API. We’ll also cover the hierarchyid data type, full-text search improvements and the new Statistical Semantic Search.