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.
Deep Dive into Azure Data Factory with SSIS
Description
This session focuses on the deeper integration of SQL Server Integration Services (SSIS) in Azure Data Factory (ADF) and the broad extensibility of Azure-SSIS Integration Runtime (IR).
We will first show you how to provision Azure-SSIS IR - dedicated ADF servers for lifting & shifting SSIS packages – with your SSIS catalog (SSISDB) hosted by Azure SQL Database server/Managed Instance and extend it with custom/3rd party components.
Preserving your skillsets, you can then use the familiar SQL Server Data Tools (SSDT)/SQL Server Management Studio (SSMS) to design/deploy/configure/execute/monitor your SSIS packages in the cloud just like you do on premises.
Next, we will guide you to modernize your ETL workloads by triggering/scheduling SSIS package executions as first-class activities in ADF pipelines and combining/chaining them with other activities, allowing you to automatically provision Azure-SSIS IR on demand/just in time, inject/splice built-in and custom/3rd party data transformations, such as Power Query Source, Data Quality (Matching/Cleansing) components, etc.
And finally, you will learn about the licensing model for ISVs to develop their paid components/extensions and join the growing 3rd party ecosystem for SSIS in ADF.
Delivered by one of the Azure Data Factory team from Microsoft
Pre-requisites: None
Laptop required: No
Learning Objectives
Previous Experience
Tech Covered
Cloud, Azure, SSIS, ETL, SSDT, Power Query, Database, SQL, Tools, SQL Server, Modernize, Azure SQL Database