SQL Server Replication in the Real World
4.2 (10 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
69 students enrolled
Wishlisted Wishlist

Please confirm that you want to add SQL Server Replication in the Real World to your Wishlist.

Add to Wishlist

SQL Server Replication in the Real World

A Practical Approach to Using SQL Server Replication
4.2 (10 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
69 students enrolled
Created by Mike West
Last updated 1/2017
English
Curiosity Sale
Current price: $10 Original price: $20 Discount: 50% off
30-Day Money-Back Guarantee
Includes:
  • 1 hour on-demand video
  • 5 Articles
  • 1 Supplemental Resource
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • You'll understand the architecture behind SQL Server replication.
  • You'll be able to make decisions on which replication topology is right for any scenario your in.
  • You'll be able to set up all three flavors of SQL Server Replication.
View Curriculum
Requirements
  • You'll need a basic understanding of SQL Server.
  • This isn't an entry level course.
  • You'll need to have access to a SQL Server version that enterprise level. (Standard would be best)
  • Please download a copy of the Adventureworks database.
  • Additionally, you'll need two separate instances installed to test replication.
Description

Review from similar course: 

"The trainer has a nice clear voice and the most important is that he does not rush through the subject, which is the problem with many instructors. By speaking slowly and displaying every step, it saves us time by not having to replay every section over and over, thanks for this." - Andres

Welcome to SQL Server Replication in the Real World.

In this course, you’ll learn how to correctly configure the three replication topologies specific to SQL Server.

Replication is a way of distributing data automatically from a source database to one or more destination databases.

In this course, we are going to cover three core topologies.

They are, Snapshot Replication, Transactional Replication and Merge Replication.

It has also been used to for high availability solution but that’s not recommend.

Replication is for continuous data transfer and is not used for simply copying data.

The two most common real world applications for replication are reporting and data warehousing.

I’ve also seen it used for off-loading nightly batch processing tasks.

Replication uses a Magazine Publishing vocabulary. Anything from an article to an entire database can be replicated.

In the course, we are going to cover all the nomenclature, architecture and real world tips and tricks you’ll need to keep replication functioning without issue.

Thanks for your interest in SQL Server Replication in the Real World.  We will see you in the course!!!

Who is the target audience?
  • Anyone using SQL Server who needs to move data between two environments.
Students Who Viewed This Course Also Viewed
Curriculum For This Course
29 Lectures
01:14:33
+
Understanding SQL Server Replication
10 Lectures 17:29

What are we going to learn in this course?

This video outlines our course goals. 

Preview 01:26

In this lecture let's talk about why you might want to use replication. 

There are some very good use cases for SQL Server Replication.

Preview 01:50

In this lesson let's learn how we decide which topology to use for any given business use case. 

What Topology Should I Use?
00:20

In this lecture let's discuss the basics of the replication architecture model. 

Preview 02:19

The replication topology isn't complicated but it does have a lot of new vernacular if you're new to SQL Server. 

In this lecture let's look at how the distributor and subscriber work. 

The Replication Architecture model - Part 2
02:11

In this lecture  let's' the discuss the agents used in the replication process. 

The Replication Agents
02:35

In this lecture let's install an instance of SQL Server with replication. 

We are also going to add replication to an existing instance that doesn't have it installed. 

Preview 03:37

In this lecture let's learn the nomenclature behind replication. 

Rep Speak
01:47

This is where you'll download the code for the course. 

There are only three code segments for this course. 

Course Downloads
00:06

Let's go over the key ideas we learned in this section. 

There were a lot of new terms so it might be a good idea to watch this section more than once.

Summary
01:17

Quiz
10 questions
+
The Big 3 - Setting up all the Types of Replcation
13 Lectures 40:00

In this lecture let's define what snapshot replication is. 

It's the least used but the easiest to set up. 

Snapshot Replcation
01:12

In this lecture let's script out the snapshot process. 

We can actually script out the entire replication process and save the files in case replication fails. 

Demo - Scripting Out Replication
02:47

In this lecture let's walk through the steps to setting up Snapshot replication. 

We do encounter two failures that we remedy. 

Demo - Setting Up Snapshot Replcation
09:39

In this lecture let's look at the jobs associated with the snapshot agent. 

The Jobs - Snapshot Replication
02:53

The distributor plays a crucial role in the replication process. 

Let's learn what it does in this lecture. 

Preview 01:30

What is transactional replication? 

Let's find out in this video. 

Transactional Replcation
01:34

In this lecture let's demonstrate how to set up transactional replication.

Demo - Setting up Transactional Replication
05:17

In this lecture let's define what Merge Replication is. 

Merge Replcation
01:21

In this lesson let's learn how to set up Merge Replication. 

Demo - Setting Up Merge Replcation
06:19

In this lesson let's go over the jobs created when we set up transactional replication. 

The Jobs - Transactional Replication
01:21

In this video let's test our set up to see if we can indeed merge data from two different databases on two separate instances. 

Testing Merge Replication
02:16

It's not one of the prettiest tools in the world but it does give us critical insight into the health of replication.

Quick Overview of Replication Monitor
02:41

Summary
01:10

Quiz
10 questions
+
Additional Replication Features and Fixes
6 Lectures 17:05

In this lecture we delete transactional replication. 

We do run into a little snag we have to correct.

Removing Replication and Cleaning Up Jobs
03:44

In this lesson let's filter row by specifying a where clause from within the replication wizard. 

Replication Row Filtering
04:08

In this lecture let's remove two columns from the synchronization of the article. 

Replcation Column Filters
01:09

In this lecture let's fix an out of control distribution database. 

Shrink Very Large Distribution Database
04:04

Basically the cleanup job internally calls sp_MSdelete_publisherdb_trans to remove records from the MSrepl_commandstable. If a publication has "immediate_sync" set to 1 in the MSpublications table, then the MSrepl_commands records will not be removed until the commands are older than the max retention setting (3 days by default).

Let's fix this issue. 

Correct Immediate Sync Issue
03:02

Summary
00:58

Quiz
10 questions
About the Instructor
Mike West
4.2 Average rating
2,606 Reviews
43,103 Students
40 Courses
SQL Server and Machine Learning Evangelist

I've been a production SQL Server DBA most of my career.

I've worked with databases for over two decades. I've worked for or consulted with over 50 different companies as a full time employee or consultant. Fortune 500 as well as several small to mid-size companies. Some include: Georgia Pacific, SunTrust, Reed Construction Data, Building Systems Design, NetCertainty, The Home Shopping Network, SwingVote, Atlanta Gas and Light and Northrup Grumman.

Experience, education and passion

I learn something almost every day. I work with insanely smart people. I'm a voracious learner of all things SQL Server and I'm passionate about sharing what I've learned. My area of concentration is performance tuning. SQL Server is like an exotic sports car, it will run just fine in anyone's hands but put it in the hands of skilled tuner and it will perform like a race car.

Certifications

Certifications are like college degrees, they are a great starting points to begin learning. I'm a Microsoft Certified Database Administrator (MCDBA), Microsoft Certified System Engineer (MCSE) and Microsoft Certified Trainer (MCT).

Personal

Born in Ohio, raised and educated in Pennsylvania, I currently reside in Atlanta with my wife and two children.