Work with spatial data in SQL Server using geography, geometry, matching SRIDs, distance queries, and an index designed for location searches.