Obtaining data changes with Change Tracking in SQL Server 2008

This article illustrated how to obtain data changes using the CHANGETABLE function. Two algorithms were presented. You can implement these two algorithms in your .NET application using Sync Services.

Introducing Change Tracking in SQL Server 2008

This article introduced Change Tracking, and illustrated how to enable Change Tracking on database, table and turn on various options, for example, AUTO_CLEANUP, TRACK_COLUMNS_UPDATED.

Peer-to-Peer Replication in SQL Server 2008 – Add a node and resolve conflict

The article shows you how to add a third node to the two-node peer-to-peer replication topology, and demonstrates how to resolve an update-update conflict.

Peer-to-Peer Replication in SQL Server 2008 – Configure a two-node topology

This article shows you how to set up a two node Peer-to-Peer replication topology in SQL Server 2008.

Working with FILESTREAM using VB .NET

FILESTREAM is a useful new feature in SQL Server 2008 that allows you to work more efficiently and easily with unstructured data, such as image files, text files, and videos. This article discusses the benefits of FILESTREAM, and demonstrates how to enable FILESTREAM on a SQL Server instance and create FILESTREAM-enabled database and table. Sample VB .NET code is also presented to demonstrate how to stream FILESTREAM data with the SqlFileStream class.