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.
Performance Tuning with Query Store in SQL Server and Azure
Description
Have you upgraded to SQL Server 2016 or higher, but still have databases using the old Cardinality Estimator?
Did you recently migrate to Azure SQL Database, or stand up a new solution, and discover that you need to optimize performance to better use available resources and decrease costs?
Do you know that you have queries with inconsistent performance, but you're just not sure how to find them, or fix them, quickly?
Are you tired of flailing around in SQL Server, querying DMV after DMV to figure out the *real* problem with performance?
Query Store can help.
We’ll cover Query Store end-to-end in this full day workshop built using real-world examples based on customer issues resolved over the last 3 years. You'll understand how to configure it, what data it captures, and how to use it to analyze performance, find regressions, and force plans. The demos will teach you how to find common patterns in query performance using T-SQL, and how to understand your workload.
This class is applicable for those running SQL Server 2016 or higher (or planning to upgrade), or Azure SQL Database, and will provide practical and applicable information you can use whether you're a new or veteran DBA, a developer that has to troubleshoot query performance, or an application administrator just trying to keep the system afloat. You'll learn how to find and leverage important information in Query Store to make solving common performance problems easier the moment you walk back into the office.
Learning Objectives
Previous Experience
Tech Covered
On-prem, Cloud, SQL 2019, Azure SQL Database, Query Store, Database engine, Data transformation and integration, performance tuning, Managing, Monitoring, Optimising