Session room

The Agenda

Agenda Home

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.

Become a Better SQL Server Developer

Description

In this full-day seminar, you will gain core knowledge about how SQL Server works, along with a host of information covering memory usage, the optimizer, indexes, statistics, and table design.

Most importantly, you will be exposed to an elaborate and detailed tour of T-SQL patterns and anti-patterns, many of which will enlighten or surprise you. You will also learn about default settings to override, trace flags that can help query analysis, optimizing tempdb, and how to avoid “it worked on my machine” syndrome.

Packed with sample code, live demos, and even pop quizzes, you will leave the room armed with many new insights into making your design phase more robust, your queries more efficient, and making life easier for your DBAs, fellow developers, and end users.

Learning Objectives

Previous Experience

Tech Covered

memory