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 Accidental Database Design for SQL Server 2016
Description
In this advanced workshop we cover enhancements in SQL Server 2016 for building databases in an enterprise environment on modern project teams.
With demonstrations and several exercises, this workshop uses group labs to cover advanced database design skills…but this isn’t your average "Here's how to create a table, now go build a database" course. Our goal is to cover new features in SQL Server 2016 that are relevant to modern enterprise development practices. We’ll talk about some of the pain points designers feel as well as the costs, benefits, and risks associated with design choices.
Discussion topics will include:
• Advanced database design process
• Advanced Data Types (XML, JSON, Geospatial)
• Files/Filegroups/Partitioning/Archiving/Stretching
• Security/Encryption/Data masking/Audit
• Advanced Table design Topics {Temporal/Hekaton/Compression}
• Other Advanced Topics
Attendees will leave this session with an understanding of the following:
• Advanced database design process for modern enterprise development projects
• New and advanced features available in SQL Server 2016
• How to decide which design choice is the right design choice for your needs
The day will include lecture style format as well as interactive discussions and exercises.
Attendee prerequisites:
Hands-on experience with SQL Server (any version) basic design concepts including normalization, constraints, indexes, datatypes and integrity features. Basic understanding of database administration concepts. Familiarity with basic Azure and Data Platform features.
With demonstrations and several exercises, this workshop uses group labs to cover advanced database design skills…but this isn’t your average "Here's how to create a table, now go build a database" course. Our goal is to cover new features in SQL Server 2016 that are relevant to modern enterprise development practices. We’ll talk about some of the pain points designers feel as well as the costs, benefits, and risks associated with design choices.
Discussion topics will include:
• Advanced database design process
• Advanced Data Types (XML, JSON, Geospatial)
• Files/Filegroups/Partitioning/Archiving/Stretching
• Security/Encryption/Data masking/Audit
• Advanced Table design Topics {Temporal/Hekaton/Compression}
• Other Advanced Topics
Attendees will leave this session with an understanding of the following:
• Advanced database design process for modern enterprise development projects
• New and advanced features available in SQL Server 2016
• How to decide which design choice is the right design choice for your needs
The day will include lecture style format as well as interactive discussions and exercises.
Attendee prerequisites:
Hands-on experience with SQL Server (any version) basic design concepts including normalization, constraints, indexes, datatypes and integrity features. Basic understanding of database administration concepts. Familiarity with basic Azure and Data Platform features.
Learning Objectives
Previous Experience
Tech Covered
Azure