Pro SQL Server 2008 Replication

Sujoy Paul is a results-oriented database and software professional with extensive experience in different relational database management systems like MS SQL Server 2000, Sybase ASA, and Sybase ASE, data modeling, case-based tools like PowerDesigner, and coding and testing in demanding hi-tech environments. Sujoy's background includes expertise in database replication, with special interest in two-way replication, backup and recovery, performance and tuning, and troubleshooting. Sujoy has a demonstrated ability to provide training for replication and Microsoft certifications on design and administration of SQL Server 2000. Sujoy is a Microsoft Certified Professional (installing, configuring, and administering Microsoft SQL Server 2000 Enterprise Edition). He is the author or coauthor of dozens of technical papers, including ""Replicating SQL Server 2000 across Heterogeneous Databases"" (SQLTeam.com, August 2003).

Replication Basics.- Types of Replication.- Configuring Snapshot Replication Using the GUI.- Configuring Snapshot Replication Using T-SQL.- Snapshot Generation.- Internals of Snapshot Replication.- Configuring Transactional Replication Using the GUI.- Configuring Transactional Replication Using T-SQL.- Internals of Transactional Replication.- Configuring Merge Replication Using the GUI.- Web Synchronization with Merge Replication.- Configuring Merge Replication Using T-SQL.- The Internals of Merge Replication.- Backup and Recovery of Snapshot and Transactional Replication.- Backup and Recovery of Merge Replication.- Optimizing Snapshot Replication.- Optimizing Transactional Replication.- Optimizing Merge Replication.- Heterogeneous Replication.