Ausverkauft

SQLSatLinz - Workshop - Performance and Query Tuning with SQL Server 2017 a...

Eventinformationen

Dieses Event teilen

Datum und Uhrzeit

Veranstaltungsort

Veranstaltungsort

Tabakfabrik Linz

1-15 Peter-Behrens-Platz

Factory 300

4020 Linz

Austria

Karte anzeigen

Rückerstattungsrichtlinien

Rückerstattungsrichtlinien

Rückerstattungen bis zu 7 Tage vor dem Event

Beschreibung des Events

Beschreibung

Description:

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

Prerequisites

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).


Speaker

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.

Mit Freunden teilen

Datum und Uhrzeit

Veranstaltungsort

Tabakfabrik Linz

1-15 Peter-Behrens-Platz

Factory 300

4020 Linz

Austria

Karte anzeigen

Rückerstattungsrichtlinien

Rückerstattungen bis zu 7 Tage vor dem Event

Dieses Event speichern

Event gespeichert