Managing Incremental Loads
- 51m 30s
—Introduction
2m 8s
—T-SQL MERGE Statement: Type 1 SCD
4m 32s
—T-SQL MERGE Statement: Type 2 SCD
3m 34s
—Dimension Load Pattern with MERGE
1m 53s
—Demo: Slowly Changing Dimension Handling with MERGE
10m 34s
—Change Data Capture (CDC)
3m 56s
—CDC in Integration Services
8m 25s
—Demo: Slowly Changing Dimension Handling with CDC
14m 10s
—Custom Component
0m 56s
—Summary
1m 18s
Azure and Integration Services
- 1h 18m
—Introduction
1m 0s
—Architecture Options
0m 43s
—Virtual Machines and SQL Databases
3m 35s
—Demo: Creating an Azure Virtual Machine
3m 7s
—Demo: Creating a SQL Database
3m 14s
—Hybrid: On-premises and Azure
0m 46s
—Demo: Creating a Virtual Network
7m 58s
—Demo: Joining an Azure Virtual Machine to an On-Premises Network
2m 11s
—ETL Strategies
1m 0s
—Data Connections
0m 28s
—Demo: Working with Data Connections in the Cloud
5m 25s
—ETL Design Patterns for the Cloud
2m 13s
—Demo: Modifying the ETL Design Pattern for the Cloud
11m 26s
—Data Subsets
1m 6s
—Demo: Extracting a Subset of Data
4m 59s
—File Compression
1m 20s
—Demo: Compressing Files for ETL
6m 30s
—Additional Considerations for Cloud Integration
0m 34s
—Planning for Failure
1m 30s
—Demo: Implementing Retry Logic
12m 2s
—Sharding
1m 19s
—Scaling Processes
2m 36s
—Summary
3m 10s
Deployment - Part 1
- 38m 30s
—Introduction
1m 43s
—Deployment Target Options
2m 36s
—Deployment Utility
2m 56s
—Demo: Preparing for Deployment
1m 4s
—Demo: Package Installation Wizard Deployment to MSDB
1m 10s
—Demo: Package Installation Wizard Deployment to File System
2m 33s
—Other Deployment Tools
0m 52s
—Demo: Import into MSDB
1m 32s
—Demo: Use DTUTIL to Import into MSDB from File System in Bulk
1m 55s
—Package Configuration
3m 51s
—Demo: Working with Configurations
4m 57s
—Package Execution
1m 12s
—Execute Package Utility
1m 27s
—Demo: Using the Execute Package Utility
3m 10s
—DTExec Utility
1m 20s
—Demo: Using the DTEXEC Utility
1m 8s
—SQL Server Management Studio
0m 35s
—Demo: Running a Package in Management Studio
1m 2s
—SQL Server Agent Job
0m 23s
—Demo: Scheduling a Package as a SQL Server Agent Job
1m 16s
—Summary
1m 39s
Deployment - Part 2
- 45m 5s
—Introduction
1m 7s
—SSIS Catalog
2m 11s
—Demo: Creating the SSIS Catalog
3m 6s
—Deployment Options Overview
0m 47s
—SSDT + Wizard Deployment
0m 40s
—Demo: Deploying a Project from SSDT
2m 0s
—ISPAC + Wizard Deployment
1m 19s
—Demo: Deploying a Project from an ISPAC File
2m 4s
—ISPAC + T-SQL Deployment
0m 32s
—Demo: Using T-SQL to Deploy a Project from an ISPAC File
1m 46s
—Demo: Restoring a Prior Project Version
1m 17s
—Environments
2m 14s
—Demo: Configuring Environments
1m 59s
—Package Execution Overview
0m 43s
—Package Execution with User Interface
0m 44s
—Demo: Executing a Package with a User Interface
6m 54s
—Package Execution with T-SQL
1m 37s
—Demo: Executing a Package with T-SQL
3m 7s
—Package Execution with DTExec
1m 55s
—Demo: Executing a Package with DTExec
1m 10s
—Package Execution with SQL Server Agent
0m 29s
—Demo: Creating a SQL Server Agent Job for Package Execution
1m 26s
—Data Taps in Package Execution
1m 27s
—Demo: Working with Data Taps
2m 32s
—Summary
1m 47s
—Introduction
1m 10s
—Package Security Settings
1m 36s
—Package Protection Level: DontSaveSensitive
0m 33s
—Demo: Configuring and Testing DontSaveSensitive
2m 2s
—Package Protection Level: EncryptSensitiveWithUserKey
1m 4s
—Demo: Configuring and Testing EncryptSensitiveWithUserKey
1m 39s
—Package Protection Level: EncryptSensitiveWithPassword
0m 45s
—Package Protection Level: EncryptAllWithPassword
0m 45s
—Demo: Configuring and Testing EncryptAllWithPassword
1m 37s
—Package Protection Level: EncryptAllWithUserKey
0m 44s
—Package Protection Level: ServerStorage
1m 13s
—Digital Signature
0m 48s
—Demo: Signing and Verifying a Package in Visual Studio
1m 43s
—Demo: Verifying a Package in DTEXECUI
0m 55s
—Demo: Configuring the Registry to Verify Signatures
1m 24s
—Security for Package Deployment Model
1m 17s
—Demo:Configuring Server Storage for the Package Deployment Model
3m 14s
—Security for Project Deployment Model
3m 0s
—Demo: Configuring Server Storage for the Project Deployment Model
6m 12s
—Security for Scheduled Packages
1m 10s
—Demo: Configuring a Proxy Account for Scheduled Package Execution
1m 58s
—Summary
2m 2s
Special Design Scenarios
- 33m 47s
—Introduction
0m 39s
—Working with Headers and Footers in Text Files
0m 43s
—Adding Header and Footer Rows: No Data in Header
2m 10s
—Demo: Adding Header and Footer Rows with No Data in Header
4m 22s
—Adding Header and Footer Rows: Data in Header
1m 13s
—Demo: Adding Header and Footer Rows with Data in Header
1m 52s
—Eliminating Header and Footer Rows
2m 32s
—Demo: Eliminating Header and Footer Rows
3m 52s
—XML Processing
1m 1s
—Importing XML Data
2m 16s
—Demo: Importing XML Data
2m 57s
—Validating XML Data
1m 7s
—Demo: Validating XML Data
1m 29s
—Transforming XML Data
2m 0s
—Demo: Transforming XML Data
2m 45s
—Summary
2m 42s