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.
Operations
Mastering SQL Server Performance & Optimization Strategies
Description
In the pursuit of excellence, speed is the engine, and performance is the destination.
Everyone wants their database to go faster, whether it's shaving hours off your ETL process, taking minutes off the runtime for reports, or trimming milliseconds off a critical OLTP query. Every database professional must know where to look and how to tune, whether you have one SQL environment or thousands.
In this full-day session, you'll learn how to take your performance tuning skills to the next level. How to best configure SQL Server as well as how to decipher all metrics it collects can be daunting. Identifying how to distill the data down to actionable information is an integral part of a DBA's job. After this session, you will understand what to look for, how to analyze the data, and you will know how to use an array of tools including query store, performance monitor, and various scripts to get the critical performance information you need. Beyond tools and scripts, you'll become versed in the art and science of reading query plans to help you improve individual query performance. Finally, you'll learn about the newest performance enhancements within SQL Server 2022 and Azure SQL.
You'll leave this knowledge packed session with a clearer understanding of which items to evaluate and how to resolve many issues that plague SQL Server performance.
Learning Objectives
• Gain clarity on key evaluation criteria for SQL Server performance.
• Develop an understanding of common issues affecting SQL Server performance.
• Learn effective strategies to address and resolve performance issues.
• Acquire knowledge on optimizing SQL Server for enhanced performance.
Previous Experience
Beginner knowledge of SQL, we will build from ground up. Some sections will be 200-300 level but taught for every level.
Tech Covered
Azure SQL Database, Managed Instance, Azure ML, Query Store, Database engine, Operations