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.
Future DBA
Finding Problems and Stabilizing Performance with Query Store
Description
As a data professional you often get pulled in to troubleshoot a drop in performance, and it can be stressful. Then, when you figure out the issue, people want you to fix it...immediately. But what if you need to change a query or the schema and you don't have direct code access? Or even if you do, you have to go through a change control process which can take hours or days, and you don't know when performance will tank again.
Did you know that Query Store can not only help you find problematic queries, but it can also help you manage query performance, *without* changing the schema or the code?
Whether you have SQL Server on-premises, in the cloud on a VM, or you use Azure SQL Database, Query Store is a tool you can use for troubleshooting and monitoring, as well as stabilizing query performance.
In this full day workshop, built using real-world examples based on customer issues resolved over the last 5 years, we will cover Query Story end to end, top to bottom. Topics include:
• Configuration best practices
• Considerations related to performance
• Using Query Store to find your problem queries
• Plan forcing (manual and automatic)
• How to leverage Query Store for upgrades
• How to determine if a different compatibility mode or Cardinality Estimator model benefits your workload, based on Query Store data
• How Query Store Hints and Intelligent Query Processing (IQP) features can stabilize query performance
Expect discussion, a lot of demos, and practical knowledge that you can apply to your environment the moment you turn on Query Store.
Feedback link: https://sqlb.it/?7154
Did you know that Query Store can not only help you find problematic queries, but it can also help you manage query performance, *without* changing the schema or the code?
Whether you have SQL Server on-premises, in the cloud on a VM, or you use Azure SQL Database, Query Store is a tool you can use for troubleshooting and monitoring, as well as stabilizing query performance.
In this full day workshop, built using real-world examples based on customer issues resolved over the last 5 years, we will cover Query Story end to end, top to bottom. Topics include:
• Configuration best practices
• Considerations related to performance
• Using Query Store to find your problem queries
• Plan forcing (manual and automatic)
• How to leverage Query Store for upgrades
• How to determine if a different compatibility mode or Cardinality Estimator model benefits your workload, based on Query Store data
• How Query Store Hints and Intelligent Query Processing (IQP) features can stabilize query performance
Expect discussion, a lot of demos, and practical knowledge that you can apply to your environment the moment you turn on Query Store.
Feedback link: https://sqlb.it/?7154
Learning Objectives
Previous Experience
Tech Covered
Azure, SQL 2019, Azure SQL Database, Query Store, Database engine, On Premise, Future DBA, Operational Databases, Monitoring, Optimising, SQL 2022, On Premises