Blog Understanding SQL Server High Availability (HA) Features
High availability (HA) is essential for any modern SQL Server deployment. From traditional options like Log Shipping to ...
Blog Blog Understanding SQL Server Security Features
SQL Server offers a wide range of native security features that can help protect your data at rest, in transit, and duri...
Blog Understanding Change Tracking in SQL Server
1. What Is Change Tracking? Change Tracking is a built-in, lightweight feature of SQL Server that enables applications t...
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...
Tutorials 06. Create database and table
This article explains about creating databases and tables in SQL Server.There are multiple objects within a SQL Server i...
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...