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.