Microsoft Razvoj tečaj SQL Server Performance for Application Developers

2025-12-05T08:00:00.0000000Z;2025-12-05T16:00:00.0000000Z

Status: Unconfirmed

1 day (8 teaching hours)

Intermediate

Course ID: PreconSQL25-1

Price: 200,00 € (VAT not included)

Lecturers

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

News

Subscribe to Xnet news and stay up to date on new courses, seminars, opportunities to obtain new certifications and special prices.

Our newest courses

Our passion for learning and acquiring new knowledge

Check out all the courses

Prijava na tečaj

Hitra in enostavna prijava na izbrani tečaj.

*Prosimo vas, da pred oddajo spodnjega naročila (naročilnice) pazljivo in natančno izpolnete vsa zahtevana polja, saj vam le tako lahko zagotovimo uspešno prijavo na tečaj ali izpit.

Application form (treated as an order form)

Participant

Termin tečaja

Payer

Shranjujem

Po prejetem plačilu vam bomo poslali dodatne informacije in morebitna navodila glede izvedbe tečaja ali opravljanja izpita, na vaš e-poštni naslov. Hvala

Thank you for a successful application!

Thank you for a successful application! We will contact you by phone or e-mail as soon as we have processed your application.
Thank you for your trust. Have a good and successful day!

Need assistance? bot icon
Need assistance?