Query Spatial Data for Nearest Neighbor. Query the seven closest cities to a given location.
STDistance (geography Data Type). Calculate the distance between two geographic points.
OGC Methods on Geography Instances. More spatial query parameters for SQL Server.
Walkthrough: Creating a Map Report with SQL Server Spatial Queries.