SQL Server

Explore SQL Server’s Change Data Capture: how to enable CDC, capture INSERT/UPDATE/DELETE operations from the transaction log, and retrieve change data efficiently for auditing, ETL, and integration workflows.

Transaction replication has an option called "sync with backup". This option can be configured for both the publication ...

Peer-to-Peer Transaction replication is a kind of bidirectional replication. It operates in a way that transaction repli...

In this article, I explain how Snapshot Replication works. It is easy to understand how snapshot replication works. It p...

In this article, I will explain how merge replication works.PrerequisitesIn merge replication, the following two jobs ar...

Replication can be a challenging feature to understand at first. In this article, I will explain how transaction replica...

In SQL Server, data communication is conducted in the diagram below.　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　...