MyPage is a personalized page based on your interests.The page is customized to help you to find content that matters you the most.


I'm not curious

SQL Server: Transactional Replication Fundamentals

Course Summary

SQL Server replication remains a viable data distribution and availability feature that has inherent advantages that are not entirely covered by other out-of-the-box SQL Server features. This course will briefly examine the various replication types befor


  • +

    Course Syllabus

    ● Course Introduction
        ◦ Course Introduction
        ◦ Course Structure
    ● Replication Types and Scenarios
        ◦ Module Introduction
        ◦ Terminology - Publishing Industry Metaphor
        ◦ Types of Replication (1)
        ◦ Types of Replication (2)
        ◦ Types of Replication (3)
        ◦ Common Transactional Replication Topologies
    ● Setup and Configuration
        ◦ Module Introduction
        ◦ Transactional Replication Components
        ◦ Transactional Replication Initial Dataset
        ◦ Transactional Replication Log Reader Agent
        ◦ Transactional Replication Distribution Agent
        ◦ Deployment: Wizard or Scripts?
        ◦ Configuring the Distributor
        ◦ Demo: Configuring the Distributor via Wizard
        ◦ Demo: Configuring the Distributor via T-SQL
        ◦ Creating the Publication
        ◦ Demo: Creating the Publication via Wizard
        ◦ Demo: Creating the Publication via T-SQL
        ◦ Creating the Push Subscription
        ◦ Creating the Pull Subscription
        ◦ sp_addsubscription @sync_type
        ◦ Demo: Creating a Subscription via Wizard
        ◦ Demo: Testing a Transactional Replication Topology
        ◦ Demo: Creating a Subscription via T-SQL
        ◦ Deploying with Least Privilege (1)
        ◦ Deploying with Least Privilege (2)
    ● Performance Considerations
        ◦ Module Introduction
        ◦ Factors that Affect Replication Performance (1)
        ◦ Factors that Affect Replication Performance (2)
        ◦ Demo: Replication Multiplier Effect
        ◦ Distribution Database
        ◦ sp_addpublication's immediate_sync
        ◦ Demo: Checking Distribution Database Settings
        ◦ Demo: Validating immediate_sync options
        ◦ Log Reader and Transaction Log Activity
        ◦ Hidden Costs of a Single Command
        ◦ Demo: Measuring Agent Reader vs. Writer Time
        ◦ Demo: Wait Statistics by Agent
    ● Combining Replication with other Technologies
        ◦ Module Introduction
        ◦ Transactional Replication and Database Mirroring
        ◦ Transactional Replication and Failover Clustering
        ◦ Transactional Replication and Availability Groups
    ● Monitoring
        ◦ Module Introduction
        ◦ Setting Warnings and Thresholds
        ◦ Demo: Replication Monitor Warnings and Thresholds
        ◦ Alerts (1)
        ◦ Alerts (2)
        ◦ Demo: Replication Alerts
        ◦ Demo: Using Tracer Token Stored Procedures
        ◦ Establishing Replication Baselines
    ● Troubleshooting
        ◦ Module Introduction
        ◦ Tools and General Troubleshooting Steps (1)
        ◦ Tools and General Troubleshooting Steps (2)
        ◦ Data Not Being Delivered to Subscribers
        ◦ Demo: Replication Validation
        ◦ Publisher and Subscriber Data Does Not Match
        ◦ Danger of -SkipErrors
        ◦ Demo: Skipping a Failed Command
        ◦ Skipping Specific Commands
        ◦ Process Could Not Execute sp_repldone/sp_replcounters
        ◦ Impact of DBCC CHECKDB Repair
        ◦ Error 2812: Could not find stored procedure %.*ls
        ◦ Course Summary

     


Course Fee:
USD 29

Course Type:

Self-Study

Course Status:

Active

Workload:

1 - 4 hours / week

Attended this course?

Back to Top

Awards & Accolades for MyTechLogy
Winner of
REDHERRING
Top 100 Asia
Finalist at SiTF Awards 2014 under the category Best Social & Community Product
Finalist at HR Vendor of the Year 2015 Awards under the category Best Learning Management System
Finalist at HR Vendor of the Year 2015 Awards under the category Best Talent Management Software
Hidden Image Url

Back to Top