SQL Server Performance Troubleshooting and Tuning
6.12. - 6.12.2024
Status: Nepotrjen
1 dan (8 pedagoških ur)
Course Id: SQL2024-1
Price: 200,00 € (brez. DDV)
Lecturers
Are you a developer, DBA, or responsible for managing SQL Server performance? Join this comprehensive workshop, specifically designed for professionals like you.
This full-day seminar will provide the knowledge, guidelines, and tips you need to design and manage scalable, high-performing database solutions. You’ll learn not only how to troubleshoot performance issues in SQL Server, but also discover many of these issues that can be prevented and how to do this.
Here are modules you will learn during the seminar:
- Indexing Best Practices
- Writing high-performance queries
- Parameter sniffing (Why is my app sometimes slow, sometimes fast?)
- Troubleshooting and fixing performance degradation by using Query Store
- Dealing with large tables
- Performance improvements in SQL Server 2019 and SQL Server 2022
By the end of this workshop, you’ll have the knowledge and tools to effectively enhance SQL Server performance.
Author:
- Miloš Radivojević is a database consultant based in Vienna, Austria. He is the Head of MSSQL Database Engineering at Entain and is highly active in the SQL Server community. Milos is the co- founder of SQL PASS Austria and a regular speaker at both local and international database conferences. He is also the co-author of three SQL Server books: Mastering SQL SQL Server 2017, SQL Server 2017 Developer’s Guide, and SQL Server 2016 Developer’s Guide.
Price:
- Early bird price: 200 € (until 22.11.2024)
- Regular price: 250 €
Date:
- 06.12.2024, start 09.00 AM
Location:
- Kompas Xnet, Stegne 7, 1000 Ljubljana
Novice
Naročite se na Xnet novice in ostanite na tekočem glede novih tečajev, seminarjev, možnosti pridobitve novih certificiranj in akcijskih cen.