Tag: lsn_time_mapping

Walk through of Microsoft SQL Server Change Data Capture

Chris Skorlinski [MSFT] ReplTalk Blog September 30, 2010

This sample script walks through some of the Microsoft Change Data Captures functions. Copy and past the script into SQL Server Management Studio and execute each command. Sample output is included in the script. This demo is based on the [AdventureWorksLT2008] database USE [AdventureWorksLT2008] GO -- Create Sample table used for CDC Demo CREATE TABLE
Read More »

Change Data Capture Best Practices

Chris Skorlinski [MSFT] Best Practices April 19, 2010

Here is a quick list of CDC Best Practices. Search “CDC” tags for other BLOG posting on designing, supporting and troubleshooting CDC. These recommendation come from various sources including the MSDN CDC White Paper, a recommended read for anyone interesting in tuning CDC performance. Recommendation: Try to avoid scenarios where a row needs to be
Read More »