MSDN Code Gallery

Microsoft Sync Framework is a comprehensive synchronization platform that enables collaboration and offline access for applications, services, and devices with support for any data type, any data store, any transfer protocol, and any network topology.

msdb database project samples for Visual Studio Team System - Database Edition You can create or import database objects that refer to objects in other databases(or with MSDB database projects). These cross-database references require that you define a corresponding reference in the properties of your database project. If you refer to objects in other databases but you do not define the corresponding references in your project, warnings will appear. For each database that you reference, you can define SETVAR variables that correspond to the server and database that you want to reference. When you modify an object definition to include the reference, you can define it by using these variables instead of the explicit names of the server and the database. When you build the database project, the variables are replaced by the values that you specified. To make cross-database references specific to a particular build configuration, you must define the SETVAR variables for those references in terms of MSBuild variables. For example, you can use one set of MSBuild variables when you build and deploy a database project to a staging server and another set when you build and deploy the same project to a production server. If you define the SETVAR variables for a cross-database reference in terms of server and database names, the reference will function the same way, regardless of which build configuration you specify.

A white paper that covers methods for managing metadata in SQL Server Integration Services, Analysis Services and Reporting Services using built-in features including data lineage, business and technical metadata and impact analysis. A sample application: Microsoft SQL Server 2005 Business Intelligence Metadata Dependency Viewer and Analyzer Sample

Samples for SQL Server Compact Edition 3.5

SANMan is a service that helps automate the use of Xiotech Storage Area Networks (SANs). Xiotech is an industry leader and offers direct access to their SANs through Web Services. SANMan leverages these web services to automate the ability to Create, Delete and Move VDisks. This includes mounting; partition and volume management and drive formating on the server. SANMan also can be used to montiror the health of the SANs. Keeping a watch over Power Supplies, Temperature Sensor, Bay/Controller/Driver health and more. SANMan is built using Microsoft Visual Studio 2008. Written in C# using .NET Remoting and SQL Server as a data store. Microsoft Web Services 2.0 is used to communicate with the Xiotech Web Services.