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.
Query Tuning Tools
Description
Query tuning within SQL Server can be a tough skill to master. The new tooling released with SQL Server 2016 and 2017 changes how you identify poorly performing queries, troubleshoot their behavior, and tune the queries. In fact, the new tools make everything a little easier. This workshop teaches new techniques for tuning queries using all these new tools as well as a couple of old ones that maybe you needed to know better. How do you know which query to focus on? How do you understand what's wrong with that query? We'll answer these questions ans more over the day. You'll be able to put this knowledge to work immediately, not only in your 2016 or better instances, but also in your Azure SQL Database databases and even in some of the older versions of SQL Server. We'll cover the query store, extended events and execution plans as well as several other tools. You will be tuning your queries faster and more accurately using the SQL Server tools that you have available right now.
Learning Objectives
Previous Experience
Tech Covered
On-prem, Cloud, Azure, tuning, Database, SQL, Tools, SQL Server, Azure SQL Database, Developing, Monitoring, Optimising