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.
T-SQL for the Experienced Practitioner
Description
This full day seminar covers advanced T-SQL querying and
programming topics. It is recommended for T-SQL practitioners (developers and
DBAs) who have at least one year of experience writing and tuning T-SQL code. The
seminar explains how to solve common problems elegantly and efficiently.
Following are the topics that will be covered:
- Window Functions and their Advanced Uses
- Advanced Uses of the APPLY Operator
- OFFSET-FETCH
- Performance Problems with UDFs
- Parameter Embedding with Dynamic Filtering and Sorting
- Using the HIERARCHYID Datatype
- In-Memory OLTP
- Temporal Tables
- Sequences
- MERGE Statement Tips
Learning Objectives
Previous Experience
Tech Covered
performance, memory