Faster SSIS

Offered By: PASS Data Community Summit via YouTube

Course Description

Overview

Save Big on Coursera Plus. 7,000+ courses at $160 off. Limited Time Only!

Explore SQL Server 2016 Integration Services (SSIS 2016) package tuning techniques in this informative conference talk. Join SSIS author Andy Leonard as he demonstrates test loads using sample and real-world data, showcasing methods to optimize performance. Learn about removing blobs, handling mapping errors, executing calculators, and managing blob loads. Discover strategies for incremental loading, implementing lookups, and detecting changes in your data. Gain insights through live demonstrations and practical examples of data flow operations. Enhance your SSIS skills and improve the efficiency of your data integration processes with expert guidance and real-world scenarios.

Syllabus

Introduction
Presentation Overview
Demo
Remove Blobs
Mapping Errors
Running Calculator
Blob Load
Blob Temp
Live Demo
Incremental Load
Lookups
Change Detection
Change Detection Demo
Data Flow Example
Questions
Conclusion

Taught by

PASS Data Community Summit

Related Courses

Doing More with Less - The Challenges Ahead for Every Data Professional
PASS Data Community Summit via YouTube Build a Modern Data Strategy and Put Your Data to Work
PASS Data Community Summit via YouTube Transform Your Data Estate
PASS Data Community Summit via YouTube Azure SQL and SQL Server 2022 - Intelligent Database Futures
PASS Data Community Summit via YouTube SQL Server in Azure Virtual Machines Reimagined
PASS Data Community Summit via YouTube