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.
Practical T-SQL - Efficient Solutions
Description
This full-day seminar covers practical use of T-SQL to
address common tasks efficiently. Often intuitive solutions for common tasks
don’t get optimized well. With some creativity, you can achieve significant
performance improvements. This seminar walks you through such examples,
explaining the reasons for the inefficiencies, and provides efficient
solutions, using powerful tools in the language such as window functions,
APPLY, MERGE, OFFSET-FETCH, sequences and others.
The seminar covers topics such as temporal data, with
efficient handling of temporal intervals; new solutions to gaps and islands
problems; statistical calculations like median; aggregates against partitioned
tables; complexities of generating surrogate keys and copying data with
dependencies.
The seminar also covers suggestions for improvements in SQL
Server.