SQL Server: Transactional Replication Fundamentals [2013, ENG]

Обучающие видео » Компьютерные видеоуроки и обучающие интерактивные DVD » ОС и серверные программы Microsoft

SQL Server: Transactional Replication Fundamentals

Год выпуска: 2013
Производитель: Pluralsight
Автор: Joe Sack
Продолжительность: 1h 52m
Тип раздаваемого материала: Видеоклипы
Язык: Английский
Описание:
Научитесь конфигурировать, отслеживать и решать проблемы SQL transaction replecation.

Learn how to configure, monitor, and troubleshoot SQL Server transactional replication, as well as the fundamentals of how it works and key performance considerations.

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 before delving more deeply into transactional replication.
In addition to the fundamentals, this course will also review the key performance considerations, monitoring techniques and troubleshooting scenarios.
After viewing this course you should be ready to use transactional replication in the appropriate contexts, as well as deploy, support and troubleshoot issues accordingly.
This course is perfect for developers, DBAs, and anyone responsible for SQL Server replication, from complete beginners through to those with more experience.
The information in the course applies to all versions from SQL Server 2005 onwards.
[spoiler="Содержание"]
FileName Size Length Bit rate Data rate Resolution Frame Rate Parent Folder
01.Course Introduction 1.61 MB 0:01:04 ‎128kbps 143.00 1024x768 ‎15 frames/second 01.Course Introduction
02.Course Structure 853 KB 0:00:38 ‎128kbps 50.00 1024x768 ‎15 frames/second 01.Course Introduction
01.Module Introduction 1.21 MB 0:00:51 ‎128kbps 110.00 1024x768 ‎15 frames/second 02.Replication Types and Scenarios
02.Terminology - Publishing Industry Metaphor 1.62 MB 0:01:06 ‎128kbps 146.00 1024x768 ‎15 frames/second 02.Replication Types and Scenarios
03.Types of Replication (1) 1.80 MB 0:01:21 ‎128kbps 87.00 1024x768 ‎15 frames/second 02.Replication Types and Scenarios
04.Types of Replication (2) 1.53 MB 0:01:05 ‎128kbps 121.00 1024x768 ‎15 frames/second 02.Replication Types and Scenarios
05.Types of Replication (3) 2.54 MB 0:01:55 ‎128kbps 106.00 1024x768 ‎15 frames/second 02.Replication Types and Scenarios
06.Common Transactional Replication Topologies 1.29 MB 0:00:54 ‎128kbps 137.00 1024x768 ‎15 frames/second 02.Replication Types and Scenarios
01.Module Introduction 1.20 MB 0:00:50 ‎128kbps 99.00 1024x768 ‎15 frames/second 03.Setup and Configuration
02.Transactional Replication Components 1.47 MB 0:01:02 ‎128kbps 127.00 1024x768 ‎15 frames/second 03.Setup and Configuration
03.Transactional Replication Initial Dataset 1.08 MB 0:00:44 ‎128kbps 115.00 1024x768 ‎15 frames/second 03.Setup and Configuration
04.Transactional Replication Log Reader Agent 1.66 MB 0:01:13 ‎128kbps 144.00 1024x768 ‎15 frames/second 03.Setup and Configuration
05.Transactional Replication Distribution Agent 706 KB 0:00:30 ‎128kbps 84.00 1024x768 ‎15 frames/second 03.Setup and Configuration
06.Deployment - Wizard or Scripts 2.00 MB 0:01:24 ‎128kbps 155.00 1024x768 ‎15 frames/second 03.Setup and Configuration
07.Configuring the Distributor 926 KB 0:00:41 ‎128kbps 67.00 1024x768 ‎15 frames/second 03.Setup and Configuration
08.Demo - Configuring the Distributor via Wizard 12.7 MB 0:06:07 ‎128kbps 1079.00 1024x768 ‎15 frames/second 03.Setup and Configuration
09.Demo - Configuring the Distributor via T-SQL 8.48 MB 0:03:15 ‎128kbps 1025.00 1024x768 ‎15 frames/second 03.Setup and Configuration
10.Creating the Publication 1.25 MB 0:00:58 ‎128kbps 73.00 1024x768 ‎15 frames/second 03.Setup and Configuration
11.Demo - Creating the Publication via Wizard 8.96 MB 0:05:05 ‎128kbps 252.00 1024x768 ‎15 frames/second 03.Setup and Configuration
12.Demo - Creating the Publication via T-SQL 11.4 MB 0:03:20 ‎128kbps 866.00 1024x768 ‎15 frames/second 03.Setup and Configuration
13.Creating the Push Subscription 571 KB 0:00:24 ‎128kbps 52.00 1024x768 ‎15 frames/second 03.Setup and Configuration
14.Creating the Pull Subscription 818 KB 0:00:37 ‎128kbps 45.00 1024x768 ‎15 frames/second 03.Setup and Configuration
15.sp_addsubscription @sync_type 2.44 MB 0:01:42 ‎128kbps 136.00 1024x768 ‎15 frames/second 03.Setup and Configuration
16.Demo - Creating a Subscription via Wizard 9.80 MB 0:05:54 ‎128kbps 247.00 1024x768 ‎15 frames/second 03.Setup and Configuration
17.Demo - Testing a Transactional Replication Topology 3.57 MB 0:01:49 ‎128kbps 451.00 1024x768 ‎15 frames/second 03.Setup and Configuration
18.Demo - Creating a Subscription via T-SQL 8.56 MB 0:03:01 ‎128kbps 711.00 1024x768 ‎15 frames/second 03.Setup and Configuration
19.Deploying with Least Privilege (1) 1.58 MB 0:01:10 ‎128kbps 97.00 1024x768 ‎15 frames/second 03.Setup and Configuration
20.Deploying with Least Privilege (2) 1.21 MB 0:00:49 ‎128kbps 151.00 1024x768 ‎15 frames/second 03.Setup and Configuration
01.Module Introduction 1.28 MB 0:00:54 ‎128kbps 96.00 1024x768 ‎15 frames/second 04.Performance Considerations
02.Factors that Affect Replication Performance (1) 3.42 MB 0:02:32 ‎128kbps 99.00 1024x768 ‎15 frames/second 04.Performance Considerations
03.Factors that Affect Replication Performance (2) 2.12 MB 0:01:37 ‎128kbps 84.00 1024x768 ‎15 frames/second 04.Performance Considerations
04.Demo - Replication Multiplier Effect 16.2 MB 0:04:26 ‎128kbps 2506.00 1024x768 ‎15 frames/second 04.Performance Considerations
05.Distribution Database 1.85 MB 0:01:19 ‎128kbps 129.00 1024x768 ‎15 frames/second 04.Performance Considerations
06.sp_addpublication's immediate_sync 2.59 MB 0:01:41 ‎128kbps 219.00 1024x768 ‎15 frames/second 04.Performance Considerations
07.Demo - Checking Distribution Database Settings 4.03 MB 0:02:30 ‎128kbps 323.00 1024x768 ‎15 frames/second 04.Performance Considerations
08.Demo - Validating immediate_sync options 2.79 MB 0:01:04 ‎128kbps 416.00 1024x768 ‎15 frames/second 04.Performance Considerations
09.Log Reader and Transaction Log Activity 1.10 MB 0:00:46 ‎128kbps 111.00 1024x768 ‎15 frames/second 04.Performance Considerations
10.Hidden Costs of a Single Command 1.78 MB 0:01:02 ‎128kbps 289.00 1024x768 ‎15 frames/second 04.Performance Considerations
11.Demo - Measuring Agent Reader vs. Writer Time 16.3 MB 0:06:04 ‎128kbps 1337.00 1024x768 ‎15 frames/second 04.Performance Considerations
12.Demo - Wait Statistics by Agent 10.8 MB 0:04:34 ‎128kbps 977.00 1024x768 ‎15 frames/second 04.Performance Considerations
01.Module Introduction 1.14 MB 0:00:47 ‎128kbps 104.00 1024x768 ‎15 frames/second 05.Combining Replication with other Technologies
02.Transactional Replication and Database Mirroring 2.37 MB 0:01:35 ‎128kbps 228.00 1024x768 ‎15 frames/second 05.Combining Replication with other Technologies
03.Transactional Replication and Failover Clustering 850 KB 0:00:36 ‎128kbps 78.00 1024x768 ‎15 frames/second 05.Combining Replication with other Technologies
04.Transactional Replication and Availability Groups 2.11 MB 0:01:23 ‎128kbps 224.00 1024x768 ‎15 frames/second 05.Combining Replication with other Technologies
01.Module Introduction 888 KB 0:00:37 ‎128kbps 80.00 1024x768 ‎15 frames/second 06.Monitoring
02.Setting Warnings and Thresholds 1.10 MB 0:00:43 ‎128kbps 132.00 1024x768 ‎15 frames/second 06.Monitoring
03.Demo - Replication Monitor Warnings and Thresholds 5.11 MB 0:02:42 ‎128kbps 405.00 1024x768 ‎15 frames/second 06.Monitoring
04.Alerts (1) 759 KB 0:00:32 ‎128kbps 75.00 1024x768 ‎15 frames/second 06.Monitoring
05.Alerts (2) 1.20 MB 0:00:51 ‎128kbps 112.00 1024x768 ‎15 frames/second 06.Monitoring
06.Demo - Replication Alerts 10.9 MB 0:04:30 ‎128kbps 970.00 1024x768 ‎15 frames/second 06.Monitoring
07.Demo - Using Tracer Token Stored Procedures 2.71 MB 0:01:26 ‎128kbps 414.00 1024x768 ‎15 frames/second 06.Monitoring
08.Establishing Replication Baselines 1.26 MB 0:00:56 ‎128kbps 106.00 1024x768 ‎15 frames/second 06.Monitoring
01.Module Introduction 1.24 MB 0:00:53 ‎128kbps 99.00 1024x768 ‎15 frames/second 07.Troubleshooting
02.Tools and General Troubleshooting Steps (1) 2.65 MB 0:01:48 ‎128kbps 207.00 1024x768 ‎15 frames/second 07.Troubleshooting
03.Tools and General Troubleshooting Steps (2) 1.13 MB 0:00:44 ‎128kbps 140.00 1024x768 ‎15 frames/second 07.Troubleshooting
04.Data Not Being Delivered to Subscribers 1.55 MB 0:01:03 ‎128kbps 161.00 1024x768 ‎15 frames/second 07.Troubleshooting
05.Demo - Replication Validation 5.83 MB 0:02:24 ‎128kbps 720.00 1024x768 ‎15 frames/second 07.Troubleshooting
06.Publisher and Subscriber Data Does Not Match 1.31 MB 0:00:58 ‎128kbps 72.00 1024x768 ‎15 frames/second 07.Troubleshooting
07.Danger of -SkipErrors 1.31 MB 0:00:54 ‎128kbps 137.00 1024x768 ‎15 frames/second 07.Troubleshooting
08.Demo - Skipping a Failed Command 8.11 MB 0:03:53 ‎128kbps 1044.00 1024x768 ‎15 frames/second 07.Troubleshooting
09.Skipping Specific Commands 1.52 MB 0:01:05 ‎128kbps 128.00 1024x768 ‎15 frames/second 07.Troubleshooting
10.Process Could Not Execute sp_repldone-sp_replcounters 1.64 MB 0:01:05 ‎128kbps 186.00 1024x768 ‎15 frames/second 07.Troubleshooting
11.Impact of DBCC CHECKDB Repair 1.60 MB 0:01:05 ‎128kbps 170.00 1024x768 ‎15 frames/second 07.Troubleshooting
12.Error 2812 - Could not find stored procedure %.+ls 1.36 MB 0:00:58 ‎128kbps 110.00 1024x768 ‎15 frames/second 07.Troubleshooting
13.Course Summary 1.15 MB 0:00:54 ‎128kbps 49.00 1024x768 ‎15 frames/second 07.Troubleshooting
[/spoiler]
Файлы примеров: присутствуют
Формат видео: WMV
Видео: wmv3, 15 fps, 1024x768, 45~2506kbps
Аудио: wma2, 128kbps, 44.1kHz, Stereo
[spoiler="Скриншоты"]

[/spoiler]
Доп. информация: Exercise include slides and code files