17. Januar 2019 - 9:00 bis 17:00
Teilen Sie es auf:

SQLSatLinz - Workshop - Performance and Query Tuning with SQL Server 2017 and SQL Server 2019 CTP2 (Milos Radivojevic) | Tabakfabrik Linz | Donnerstag, 17. Januar 2019

This workshop 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
It would be nice, if you would have both SQL Server 2017 and 2019 installed on your laptop. However, all examples from the first part of the workshop would also work with previous versions (SQL Server 2012, 2014 and 2016).

Milos Radivojevic is a database consultant located in Vienna, Austria. He is Data Platform MVP and specializes in SQL Server for application developers and performance and query tuning. Currently he works as principal database consultant in bwin (the largest regulated online gaming company in the world).
He is co-founder of the SQL Pass Austria and speaks regularly at local and international database conferences. He is also co-author of the books SQL Server 2016 Developer's Guide and SQL Server 2017 Developer's Guide.