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.
Here is an introductory video on the geography and geometry datatype in SQL Server 2008.
The Shape2SQL tool allows you to easily upload data contained in shapefiles to Microsoft’s SQL Server 2008.
SAP BW users have two solution options for integrating SAP BW and ArcView. Both options include SAP’s BExMAP and Esri’s OLAP for ArcGIS Add-on.
The APOS Location Intelligence Solution (APOS LIS) integrates Esri ArcGIS with SAP BusinessObjects to create fully bi-directional, pervasive, enterprise location intelligence for numerous industries.