Blog Understanding Change Data Capture(CDC) in SQL Server
What is Change Data Capture?In SQL Server, Change Data Capture (CDC) is a feature that automatically captures and record...
Blog
Blog Blog How does “sync with backup” work in transaction replication?
Transaction replication has an option called "sync with backup". This option can be configured for both the publication ...
Blog Understanding Peer-to-Peer Transaction Replication in SQL Server
Peer-to-Peer Transaction replication is a kind of bidirectional replication. It operates in a way that transaction repli...
Blog Understanding Snapshot Replication in SQL Server
In this article, I explain how Snapshot Replication works. It is easy to understand how snapshot replication works. It p...
Blog Understanding Merge Replication in SQL Server
In this article, I will explain how merge replication works.PrerequisitesIn merge replication, the following two jobs ar...
Blog Understanding Transaction Replication in SQL Server
Replication can be a challenging feature to understand at first. In this article, I will explain how transaction replica...
Blog How to establish a connection to SQL Server?
In SQL Server, data communication is conducted in the diagram below. ...