Session Abstracts

Here are the content details for this event's available sessions.
Title
Speaker
     All Sessions   |   Room 1

  • Session 1: Replication Overview
    In this opening session, we will look at the structure of the class and what to expect for the next twelve sessions. We begin our tour with an overview of replication and a look at the different roles and agents involved in replication. After this session you should understand the different types of replication and have a working knowledge of the various moving parts, which we will dive more deeply into in later sessions.
  • Session 2: Replication Topologies and Configuration
    This session will provide you with an overview of the various topologies and configurations in replication. We will look at some of the more common topologies and also begin working hands on with replication. We will cover the initial configuration of replication and look at setting up distribution, publication, and subscriptions.
  • Session 3: Snapshot Replication
    In session 3, we will look at the simplest type of replication, Snapshot Replication. We will discuss basic configuration, the file locations used by snapshot replication, and some of the more common snapshot options. Since snapshot is used by the other replication types, we will be looking at it in more detail in later sessions as well.
  • Session 4: Transactional Replication
    In this session, we look at the most common replication type, transactional replication. We will look at how you set up a transactional replication from a publication to a subscription. We will also look at the options available to perform the initial synchronization of your subscriptions. Lastly, we will look at the procedures that are created for transactional replication and look at the various options that you can set with agent profiles.
  • Session 5: Merge Replication
    This session covers Merge Replication in all its glory. We look at the configuration and initial sync in addition to peaking under the covers at how merge tracks changes. Lastly, we will look at Merge Agent Profiles and talk a little about the Web Sync option.
  • Session 6: Special Replication Considerations
    This session will cover things that you need to consider in replication outside of the data itself. We will look at how replication handles identities, indexes, and foreign keys. We will also talk about the NOT FOR REPLICATION option and tell you how you can backup your replication configuration with scripts.
  • Session 7: Using Transactional Replication for High Availability
    This session will touch on a common use of replication, specifically setting up transactional replication to create a highly available environment. We will discuss the settings in replication that should be considered when setting up high availability, as well as the non-data elements that also have to be considered.
  • Session 8: Understanding Other Transactional Replication Options
    In transactional replication, you can also set advanced options for updating subscribers and even peer-to-peer replication. This session will focus on these special areas of transactional replication and how they can fit into your replication environment.
  • Session 9: Replication Security
    Replication moves a lot of your data around and as such it must be secure. This session will cover the basics of replication security and arm you with the knowledge you need to correctly lock down your replication, and ultimately, your data.
  • Session 10: Optimizing Replication
    Like anything that involves moving large amounts of data, replication is susceptible to performance degradation if it is not properly cared for. In this session, we will look at things you can do to keep your replication performing in top shape.
  • Session 11: Maintenance on Replicated Database
    When you replicate a database, there are a few things that you need to consider when it comes to maintenance on that database. This session will talk about areas of concern and offer advice for keeping your maintenance going on your replication databases.
  • Session 12: Troubleshooting and Monitoring Replication
    Nothing is perfect and replication is certainly no except to this rule. This will break from time to time and you will need to know how to fix them. This session will provide you with some troubleshooting techniques for replication as well as some advice of how to monitor replication so you will know when a problem occurs.
Panel Bottom