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.
Advanced Data Modeling Topics
Description
Every developer should
know how to design a relational or a dimensional database. Nevertheless, there
are still many advanced problems which are commonly solved in an inappropriate
or at least inefficient way, or even not solved at all, because there is no
solution out of the box in SQL Server. In addition, although the relational
model is more than 40 years old and the dimensional model is also more than 30
years old, there are still many common myths and urban legends around them. In
this seminar, we are going to deal with some of the most advanced problems and
bust many common myths. The topics include:
- Database design myths
- Graphs in a relational database – basics, constraints
- Optimizing general graphs and spatial data
- Dynamic relational schema
- Temporal data in SQL Server
- Optimizing temporal data
Learning Objectives
Previous Experience
Tech Covered
spatial