SQLBits encompasses everything from in-depth technical immersions to the enhancement of valuable soft skills. The full agenda will be announced in the spring; in the meantime check out the timetable and content we cover below.
2024 Training Days
Presenting 2024’s selection of training days, encompassing a deep dive into a range of subjects with some of the best data trainers in the world.
- 08:00 Registration opens and breakfast served.
- All training days run simultaneously across the venue from 09:00 – 17:00 with co-ordinated breaks.
- All training days include regular refreshment breaks and a lunch stop to rest, recharge, and chat to fellow delegates.
- No evening events planned, but if you’re staying over the night beforehand, why not join us in the Aviator on Monday night to meet the training day speakers for an informal drinks reception.
SSIS Performance Design Patterns
Description
Need a fast data integration solution, but don't have the time or budget for heavy performance tuning? By selecting the right design, 90% of SSIS customers will achieve their ETL performance goals with little to no performance tuning. This session will teach you how to pick that design! Targeted at intermediate to advanced SSIS users, Matt Masson (a developer on the SSIS team) and John Welch (SQL MVP) will guide you through a series of proven SSIS design patterns, and teach you how to apply them to solve many common ETL problems. We’ll start off with an overview of the Data Flow internals, and review the SQLCAT team’s Top Ten Best Practices for achieving optimal performance. We’ll then dive into a series of design patterns, including Advanced Lookup Patterns, Parallel Processing, Avoiding Transactions, handling Late Arriving Facts and multiple ways to process Slowly Changing Dimensions.
If you’re looking for ways to maximize your SSIS ROI, then you won’t want to miss this!
This training session includes the following modules:
Module 1 - Data Flow Internals
Module 2 - Benchmarking and Performance Best Practices
Module 3 - Common Design Patterns
Module 4 - Lookup Design Patterns
Module 5 - Parallelization Design Patterns
Module 6 - Data Warehousing Design Patterns
Module 7 - Advanced Design Patterns
If you’re looking for ways to maximize your SSIS ROI, then you won’t want to miss this!
This training session includes the following modules:
Module 1 - Data Flow Internals
Module 2 - Benchmarking and Performance Best Practices
Module 3 - Common Design Patterns
Module 4 - Lookup Design Patterns
Module 5 - Parallelization Design Patterns
Module 6 - Data Warehousing Design Patterns
Module 7 - Advanced Design Patterns
Learning Objectives
Previous Experience
Tech Covered
performance, SSIS, dimensions, ETL