Tag - Intelligent Query Processing

Speaking at IT-Tage 2019 Conference in Frankfurt

I am honored to have been selected to speak at one of the largest database conferences in the German-speaking area “IT-Tage 2019” in Frankfurt. The 3-day conference will be held from 10th to 12th December 2019, with a pre-con day on 9th December.

itt1I’ll be presenting features within Intelligent Query Processing in SQL Server 2019. The session will cover briefly all these features: Batch Mode on Rowstore, Batch and Row Mode Memory Grant Feedback, Scalar UDF Inlining, Table Variable Deferred Compilation, and Approximate Query Processing. If time permits (session takes 45 minutes only), I’ll mention Batch Mode Adaptive Join and Interleaved Execution.

There are 160 sessions on the three conference days, the conference agenda you can see here.

See you in Frankfurt!

Workshop: Performance and Query Tuning with SQL Server 2017 and 2019

PFTAs part of the SQL Saturday Linz conference, I will have a performance tuning workshop on 17th January in Tabakfabrik in Linz. The full workshop name is Performance and Query Tuning with SQL Server 2017 and 2019. As the name suggests, the workshop covers performance tuning techniques specific for two recent SQL Server versions. It is aimed at application and database developers who already work or plan to work with the latest versions of SQL Server – 2017 and 2019. The first part of the workshop is focused on execution plans, statistics and query optimizer. It covers common mistakes made by developers that lead to poor performing queries and brings tips how to avoid them.

The second part of the workshop includes a detailed view of Query Store, a new powerful troubleshooting tool introduced in SQL Server 2016 and improved in the later versions. You can see how you can use it not only to troubleshoot, but also to fix regressed queries, and it will be demonstrated its power by upgrade to new SQL Server version or changing compatibility level. At the end, you can learn about database engine improvements in the SQL Server 2019 CTP2 feature with the most promising name – Intelligent Query Processing.

The workshop will cover the following topics:

  • How SQL Server uses statistics and what are common issues with them
  • Quick overview of index usage; how to create a useful index
  • Typical mistakes made by developers that lead to poor performing queries
  • Troubleshooting parameter sniffing issues in different SQL Server versions
  • Cardinality estimation issues and tuning queries with large tables
  • Tips for writing well-performed queries
  • Query Store as game changer in SQL Server performance troubleshooting
  • Fixing execution plans for regressed queries by using Query Store
  • Improvements in SQL Server 2019 Intelligent Query Processing

Level: 300 – Advanced

Here is the link for registration: https://bit.ly/2rkj4wX.

Hope to see you in Linz!

Rgds,
M.