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.
High Performance T-SQL for the Experienced DB Practitioner
Description
This seminar covers advanced aspects of T-SQL querying and programming with a performance-centric focus. The seminar demonstrates practical uses of T-SQL features, with optimized and polished solutions, many of which were developed by the speaker. The seminar also covers the newest additions to T-SQL in SQL Server 2016 and 2017. The topics covered by the seminar include: the APPLY operator, window functions, (including batch-mode support), pivoting and unpivoting techniques, the OFFSET-FETCH filter, system-versioned temporal tables, string splitting and concatenation with the STRING_SPLIT and STRING_AGG functions, SQL Graph, and more.
Pre-requisites
1 year of experience writing T-SQL code and optimizing queries
Laptop Required:No
Learning Objectives
Previous Experience
Tech Covered
performance