Part VIII: WiE uses SQL Server Integration Services (SSIS) to synchronize SQL Data Services (SDS) with SQL Server 2008.

  In the previous article we covered using the use of INSERT triggers along with the new Spatial data-type support in SQL Server 2008 to implement “spatial rules” for our location-based service.  All that remained was to implement a mechanism to make all the location data hosted by SQL Data Services visible SQL Server 2008. …

2

Part VII – WiE Goes Spatial: Using SQL Server 2008 as a Spatial Rules Engine for Location-based Services.

In this second to last chapter in the series I’ll discuss leveraging SQL Server 2008’s support for spatial data types to implement the “spatial rules” for the WiE Community.    Specifically, this article will implement 2 examples of simple proximity rules that drive most location-based service scenarios: –          Proximity to a Point of Interest (fixed) –         …

2