SQL Server Replication – Merge Replication type step by step

In my previous article, I talked about transactional replication and presented an example of how to configure and use it. Today, I'm going to investigate the second type of replication called Merge Replication. Definition and Mechanism Merge replication allows two or more databases to be kept in sync. Whenever changes happen on one database, they are … Continue reading SQL Server Replication – Merge Replication type step by step

Advertisements

SQL Server Replication – Transactional Replication type step by step

In previous article, I talked about basic concepts and terms of replication using SQL Server. Now, we're going to investigate one of replication types that is called transactional replication. How do we configure this type? When will we use it? Definition and mechanism Transactional replication copies data uni-directionally from the source database to the target database. … Continue reading SQL Server Replication – Transactional Replication type step by step

TSQL: How to use Common Table Expressions and Recursive Algorithm

Problem Parent-Child is one of popular relations when you design a relational database model. Obviously, you need also to retrieve data that will show their parent records from the relationship. Solution The most simplest way is to use Common Table Expressions (CTE) and run recursive process to identify parent records. CTE provides the significant advantage of … Continue reading TSQL: How to use Common Table Expressions and Recursive Algorithm