O'Reilly logo

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

SQL Server Replication Fundamentals LiveLessons (Video Training)

Video Description

Nearly 4 Hours of Video Instruction

Everything you need to know in order to implement and work with SQL Server Replication!
Replication is a common method of moving from one SQL Server to another. It enables moving data to a reporting server, creating a basic failover site, providing data to development environments, and addresses many other issues. Most DBAs have or will encounter Replication when working with SQL server. The Replication system is large enough that it is often difficult to master without some form of training. SQL Server Replication Fundamentals LiveLessons provides the information needed in order to work with replication.

Description

Every SQL Server Admin in the market needs to understand Replication in order to do their jobs. Individuals in the accidental DBA category who find Replication installed on their system, also need to understand how to use it. This LiveLesson covers all the basic building blocks of Replication. Expert Eric Johnson begins with a basic overview of the components and terms and progress into advanced configuration and troubleshooting. There is a lot to learn in order to use Replication correctly. The configuration is very visual and often more easily explained with this medium than any other delivery mechanism. This LiveLesson uses the most current version of SQL Server, but almost all the content can be applied to SQL Server versions as far back as 2005, and in some cases, even older versions of SQL Server.

About the Instructor

Eric Johnson (MCSE, MCDBA, MCSD, CCNP) is a co-founder of Consortio Services, and the primary Database Technologies Consultant. His background in information technology is diverse, ranging from operating systems and hardware to specialized applications and development. He has even done his fair share of work on networks. Since IT is really just a way to support business processes, he has also acquired his MBA. All in all, he has 10 years of experience with IT, a great amount of which has been working with Microsoft SQL Server. Eric has managed and designed databases of all shapes and sizes. He has delivered numerous SQL Server training classes and webcasts as well as presentations at national technology conferences. Most recently, he presented at TechMentor on SQL Server 2005 Replication, Reporting Services, and Integration Services. He also does a good deal of writing, including the recent four-part series, Tour de SQL, published in Redmond magazine. In addition, he is active in the local SQL Server community, serving as the president of the Colorado Springs SQL Server Users' Group.

Skill Level

Beginner to Intermediate

What You Will Learn

  • Help admins understand replication so they are able to configure and administer it in their environments.
  • Teach crucial replication topics like troubleshooting, transactional publications, and monitoring.
  • Provide the basic knowledge needed to be able to select an appropriate replication topology to solve the problem at hand.
  • Give detailed knowledge of the parts of replication so that they may customize the configuration for their needs.
  • Offer the ability to identify the type of replication in use and make the correct decisions regarding the administration of the servers running replication.
Who Should Take This Course
  • SQL Server admins
  • SQL Server developers
  • Any developer, Administrator, or DBA that has to work with SQL Server
Course Requirements
  • Some familiarity with SQL Server
About LiveLessons Video Training

The LiveLessons Video Training series publishes hundreds of hands-on, expert-led video tutorials covering a wide selection of technology topics designed to teach you the skills you need to succeed. This professional and personal technology video series features world-leading author instructors published by your trusted technology brands: Addison-Wesley, Cisco Press, VMware Press, IBM Press, Pearson IT Certification, Prentice Hall, Sams, and Que. Topics include: IT Certification, Programming, Web Development, Mobile Development, Home & Office Technologies, Business & Management, and more. View All LiveLessons at http://www.informit.com/livelessons.

Table of Contents

  1. Introduction
    1. SQL Server Replication Fundamentals LiveLesson: Introduction 00:04:20
  2. Lesson 1: Overview of SQL Server Replication
    1. Learning Objectives 00:00:37
    2. 1.1 Define Replication 00:03:12
    3. 1.2 Identify Replication Types 00:02:24
    4. 1.3 Understand Server Roles 00:03:48
    5. 1.4 Identify Replication Agents 00:04:20
  3. Lesson 2: Configuring Replication
    1. Learning Objectives 00:00:31
    2. 2.1 Set up Distribution 00:04:06
    3. 2.2 Set up Publishing 00:02:43
    4. 2.3 Set up Subscribers 00:03:08
  4. Lesson 3: Working with Snapshot Replication
    1. Learning Objectives 00:00:36
    2. 3.1 Configure Snapshot Replication 00:04:57
    3. 3.2 Work with Snapshot Options and Settings 00:06:09
    4. 3.3 Generate Snapshots 00:03:17
    5. 3.4 Configure Snapshot Agent Profiles 00:04:21
  5. Lesson 4: Working with Transactional Replication
    1. Learning Objectives 00:00:43
    2. 4.1 Configure Transactional Replication 00:13:36
    3. 4.2 Create Subscriptions 00:12:45
    4. 4.3 Synchronize Transactional Subscriptions 00:10:25
    5. 4.4 Modify Publications 00:06:54
    6. 4.5 Understand Replication Stored Procedures 00:06:39
    7. 4.6 Configure Distribution Agent Profiles 00:04:08
  6. Lesson 5: Working with Merge Replication
    1. Learning Objectives 00:00:39
    2. 5.1 Configure Merge Replication 00:06:29
    3. 5.2 Synchronize Merge Subscriptions 00:06:02
    4. 5.3 Understand Replication Triggers 00:07:34
    5. 5.4 Configure Merge Agent Profiles 00:02:26
  7. Lesson 6: Working with Peer-to-Peer
    1. Learning Objectives 00:00:33
    2. 6.1 Configure Peer-to-Peer 00:08:23
    3. 6.2 Work with Peer-to-Peer Replication 00:10:05
  8. Lesson 7: Special Considerations for Replication
    1. Learning Objectives 00:00:42
    2. 7.1 Use Identities in Replication 00:07:12
    3. 7.2 Replicate Indexes and Foreign Keys 00:07:58
    4. 7.3 Understand the NOT FOR REPLICATION Option 00:07:36
    5. 7.4 Backup Replication with Scripts 00:05:48
  9. Lesson 8: Configuring Replication Security
    1. Learning Objectives 00:00:36
    2. 8.1 Configure the Publication Access List 00:03:55
    3. 8.2 Identify Accounts with Replication Access 00:07:18
    4. 8.3 Set up Permissions 00:05:58
  10. Lesson 9: Troubleshooting and Monitoring Replication
    1. Learning Objectives 00:00:40
    2. 9.1 Use Replication Monitor 00:10:48
    3. 9.2 Identify Replication System Tables 00:05:56
    4. 9.3 Use the Ignore Error Option 00:09:08
    5. 9.4 Understand the MSdistribution_status View 00:04:13
  11. Summary
    1. SQL Server Replication Fundamentals LiveLesson: Summary 00:01:34