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

Intent Based Management – SQL Server 2008 Policies

SQL Server 2008 will introduce several features that will assist DBAs in their quest to efficiently manage an ever growing number of databases and database server instances.  Policy based management is one of these new features and it represents the beginning of a shift from the historical monitoring based management to a proactive or intent based management, empowering DBAs to…

0