SQL Server Replication in the Real World

[mitsumi]

h264, yuv420p, 1280x270 |ENGLISH, aac, 48000 Hz, 2 channels | 1h 14 mn | 193.25 MB
Created by: Mike West
A Practical Approach to Using SQL Server Replication

What you'll 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.

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 this course is for:

Anyone using SQL Server who needs to move data between two environments.

Download link:

Só visivel para registados e com resposta ao tópico.

Only visible to registered and with a reply to the topic.

Links are Interchangeable - No Password - Single Extraction