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 Problem, Design, Solution
Description
Learn tons of SSIS internals and how to solve complex SSIS real world problems. This pre-conference session focuses on various problems you'll encounter with ETL and shows a variety of solutions in SSIS on how to solve those problems.
In this session, you will learn how to solve real world data extraction problems using SSIS with a variety of battle tested design patterns. You’ll also come away with a pile of code to help you in your day to day job. You won’t get bored if you have your own laptop since you’ll be able to work with the speakers on many of the patterns. The session will start out with one of the most common challenges in ETL: data warehouses. Brian will show you a variety of competing patterns to load your dimensions and facts more efficiently and discuss the pros and cons of each. During this topic, you'll learn how to use SQL Server Change Data
Capture integration into SSIS (CDC) and incremental loads to effectively load your data warehouse in the fastest possible way. One of the most common design patterns needed is how to deal with duplicate data.
The speaker will show an end-to-end solution to scrub duplicate data and give rows a scoring
system to sift out the best records. You'll also see a number of advanced patterns for lesser used tasks in SSIS like Term Extraction and Data Mining Transform. These are just a few of the patterns Brian will be showing during the full day. With all of the solutions shown, you will be given an end-to-end
project with all the packages and data. You'll come out of the session with a lot of options on how to do your day to day ETL job. (Please note that you will want to have at least beginner SSIS experience for this session)
In this session, you will learn how to solve real world data extraction problems using SSIS with a variety of battle tested design patterns. You’ll also come away with a pile of code to help you in your day to day job. You won’t get bored if you have your own laptop since you’ll be able to work with the speakers on many of the patterns. The session will start out with one of the most common challenges in ETL: data warehouses. Brian will show you a variety of competing patterns to load your dimensions and facts more efficiently and discuss the pros and cons of each. During this topic, you'll learn how to use SQL Server Change Data
Capture integration into SSIS (CDC) and incremental loads to effectively load your data warehouse in the fastest possible way. One of the most common design patterns needed is how to deal with duplicate data.
The speaker will show an end-to-end solution to scrub duplicate data and give rows a scoring
system to sift out the best records. You'll also see a number of advanced patterns for lesser used tasks in SSIS like Term Extraction and Data Mining Transform. These are just a few of the patterns Brian will be showing during the full day. With all of the solutions shown, you will be given an end-to-end
project with all the packages and data. You'll come out of the session with a lot of options on how to do your day to day ETL job. (Please note that you will want to have at least beginner SSIS experience for this session)
Learning Objectives
Previous Experience
Tech Covered
SSIS, data warehousing, dimensions, ETL