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.
Building Better SSIS Packages
Description
Building packages in SQL Server Integration Services is easy. Creating an enterprise-ready SSIS architecture takes more effort and planning.
SQL Server Integration Services is deceptively easy to use. With a few hours of instruction or self-study, most data professionals can throw together an SSIS package. However, creating a process that simply runs successfully isn’t the endgame; enterprise-class ETL demands a higher standard. Specifically, well-designed packages will be:
In this full-day presentation, we will walk through each of these five facets of well-built packages, discussing and then demonstrating ways of applying these practices to design better SSIS packages. Among the topics for the day:
SQL Server Integration Services is deceptively easy to use. With a few hours of instruction or self-study, most data professionals can throw together an SSIS package. However, creating a process that simply runs successfully isn’t the endgame; enterprise-class ETL demands a higher standard. Specifically, well-designed packages will be:
- Reliable
- Resilient
- Reusable
- Maintainable
- Well performing
In this full-day presentation, we will walk through each of these five facets of well-built packages, discussing and then demonstrating ways of applying these practices to design better SSIS packages. Among the topics for the day:
- Checking for problems even when the package executes successfully
- Building effective tests for your packages
- Error handling and prevention
- Being kind to your fellow developers by building clear and easy-to-maintain packages
- Leave a trail of evidence: package logging done properly
- Avoiding performance bottlenecks: tips for making packages run faster
- Using the right tool for the job by integrating non-SSIS tools when appropriate
Pre-requisites
A general understanding of SQL Server Integration Services fundamentals
Laptop Required:No
Learning Objectives
Previous Experience
Tech Covered
performance, SSIS, ETL