• Interests: SQL Server Performance and Code-Quality

Stairway to SQL Server Replication

Stairway to SQL Server Replication: Level 3 - Transactional Replication – The Publisher

The Publisher is the database where all
replicated data originates. Each Publisher can have multiple publications
defined within it. Each publication contains a set of articles that all need to
reside in a single database. Each article corresponds to all or part of a single
database object. A single database object can map to an article in more than one
publication.

You rated this post out of 5. Change rating

2023-01-04 (first published: )

11,993 reads

Stairway to SQL Server Replication

Stairway to SQL Server Replication: Level 2 - The Role of the Distributor

In this Stairway, Sebastian will be covering the details of SQL Server transactional and merge replication, from understanding the basic terminology and methodology of setting up replication, to describing how it works and how the basic replication processes can be monitored.

You rated this post out of 5. Change rating

2022-12-28 (first published: )

18,687 reads

Stairway to SQL Server Replication

Stairway to SQL Server Replication: Level 1 - Introduction to SQL Server Replication

In this Stairway, Sebastian will be covering the details of SQL Server transactional and merge replication, from understanding the basic terminology and methodology of setting up replication, to describing how it works and how the basic replication processes can be monitored.

5 (1)

You rated this post out of 5. Change rating

2019-08-14 (first published: )

37,594 reads

Stairway to SQL Server Replication

Stairway to SQL Server Replication: Level 4 - Transactional Replication – The Subscriber

The Subscriber is the server where all the changes that are published by replication get delivered to. Every publication needs to have at least one subscriber, but a publication can have many subscribers. This level assumes that you have followed the first three levels and that you have a publication set up, to which you can subscribe.

You rated this post out of 5. Change rating

2013-12-11

13,991 reads

SQLServerCentral Article

The Fundamentals of SQL Server Replication by Sebastian Meine

Many of my clients need to make data that lives on one server available on another server. There are many reasons for such a requirement. You might want to speed up cross-server queries by providing a local copy of the data. Or you might want to make the data available to resource intensive reporting queries without impacting the OLTP load, maybe even with an intentional delay so you're always reporting against complete days only. Finally, you might be looking to implement high availability. In all these situations, SQL Server Replication is a viable option to look at when planning for the implemen­tation of such a requirement.

2 (7)

You rated this post out of 5. Change rating

2013-09-30

6,494 reads

Stairway to SQL Server Replication

Stairway to SQL Server Replication - Level 7: Merge Replication – Subscription

This level of the Stairway will cover the details of SQL Server transactional and merge replication, from understanding the basic terminology and methodology of setting up replication, to describing how it works and how the basic replication processes can be monitored.

You rated this post out of 5. Change rating

2012-02-03

7,246 reads

Blogs

Why the masters and what lies ahead

By

I recently graduated with a Master’s in Strategic Communication from the University of Delaware....

Copilot Reminded Me How To Find a File Handle

By

Recently I was trying to delete a folder and kept getting the “something is...

Planview Portfolios REST API with ADF – Retrieving Actual Data

By

In the introduction of this blog post series, I explained the use case: extracting...

Read the latest Blogs

Forums

singleton is interferring with getting multiple nodes in xml

By stan

Hi we have an xml doc shaped essentially as shown in image 2 below. ...

The backup to one location fails but is successful on another

By Arsh

Dear Friends, Would be glad if any of you can help in a backup...

How to set execution timeout in SSMS for SQL Server

By IT researcher

I tried to set the execution timeout in SSMS for SQL Server 2017 using...

Visit the forum

Question of the Day

Implementing Change Data Capture

I have a complex environment that uses quite a few SQL Server 2022 servers. We have a powerful SQL Server running Enterprise that hosts most of our transaction data. However, there are remote locations that run Standard, Web, Express, and Express with Advanced Services editions for local collection of data before the data is transferred to our central Enterprise Edition server. We are considering using Change Data Capture (CDC) to lower the amount of data we transfer from clients. Which editions can we implement this feature on?

See possible answers