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.
Optimising ETL on Microsoft Data Platform (SQL & Azure)
Description
This whole day workshop focuses on helping you getting more performance out of your ETL processes.
Focusing on the different features across stack of different versions of SQL Server, Azure SQL Database & Azure Managed Instance - we shall consider on how to optimise for different hardware bottlenecks (CPU, Disk, Memory) and using different sets of trivial and advanced features (Trace Flags, Query Hints) and overall the strategies of getting the job done on time.
Focusing mostly on SQL Server 2012+ versions, this workshop will help you to understand through monitoring what are the things that can be improved in the process, strategy and mostly of the existing set of limits.
If you are a Business Intelligence Developer or DBA looking to tune up the ETL processes - this is definitely a workshop for you.
Focusing on the different features across stack of different versions of SQL Server, Azure SQL Database & Azure Managed Instance - we shall consider on how to optimise for different hardware bottlenecks (CPU, Disk, Memory) and using different sets of trivial and advanced features (Trace Flags, Query Hints) and overall the strategies of getting the job done on time.
Focusing mostly on SQL Server 2012+ versions, this workshop will help you to understand through monitoring what are the things that can be improved in the process, strategy and mostly of the existing set of limits.
If you are a Business Intelligence Developer or DBA looking to tune up the ETL processes - this is definitely a workshop for you.
Pre-requisites
Knowledge of basic ETL Processes. Understanding of the core principles of SQL Server (recovery model, logging, etc).
Laptop Required:No
Learning Objectives
Previous Experience
Tech Covered
performance, Azure, DBA, ETL, features, Database, SQL, Microsoft, SQL Server, Azure SQL Database, Monitoring, Optimising