Description

You write applications for a living, but the database for you represents more of an inconvenience than a resource. You know exactly how to write efficient application code, but whenever your application is slow, it’s the database that’s always to blame.

How can you achieve better performance in the database? How can you write efficient queries? How can you take advantage of indexes, and how exactly do they work? How does the database engine come up with execution plans? How does one read and optimize those plans? Is blocking involved in any way? How do I measure and tune performance?

These are some of the questions that we will answer in this demo-intensive training day, covering the following topics and more:

• Database design considerations
• Writing queries for performance
• Index internals
• Statistics
• Query plan analysis
• Query tuning
• The Query store
• Automatic tuning
• Concurrency and transactions
• Locking, blocking, and deadlocking
• Baselining and monitoring

Pre-requisites

All training materials will be provided on the day of the seminar. Laptops are recommended, if the attendees prefer to try out the demos; however, no device is needed to follow the lectures.

Speaker

Gianluca Sartori is a Data Platform MVP, independent consultant and performance tuning specialist. He has been working in the software industry since 1999 and has been working with SQL Server ever since. He also works as a SQL Server trainer and in his spare time he writes technical articles and participates in SQL Server forums. Gianluca enjoys presenting SQL Server topics at conferences in Europe and US. He is currently working as lead DBA at a famous Formula 1 team.

LinkedIn profile

Registration fee

• Regular price: 250€ / person + VAT
• Early bird price: 200€ / person + VAT (for registrations until 5 November 2025)