Public online class, per seat
€590
€590 / day · 2-day €1,090 (net)
- Live online, max 8
- Hands-on labs on your own environment
Ludwik's courseware
T-SQL performance for developers
Read the plan, fix the query, keep it fast.
- Duration: 2 days
- Level: Advanced
- Max 8
- Live online
€1,090 / per seat
A custom programme, not an official Microsoft course. We work on why queries get slow and how to fix them: execution plans, indexing, sargability, statistics and set-based rewrites. The last afternoon belongs to your team's own slow queries.
Who it's for
- Backend developers
- Database developers
- DBAs who review code
Not for
Not for beginners who are still learning JOINs — take DP-080 first.
After 2 days your team can:
- Read an execution plan and find the operator that costs the most
- Design indexes that serve real query patterns
- Rewrite non-sargable predicates so indexes can do their job
- Diagnose and fix stale or misleading statistics
- Replace row-by-row logic with set-based T-SQL
- Use Query Store to catch regressions before users do
Agenda
Day 1: Why queries get slow
- Execution plans
- Indexing strategy
- Sargability
- Statistics
Ludwik's add-on
One of your own execution plans, read line by line.
Prerequisites
- Writes T-SQL regularly
- Knows JOINs, subqueries and GROUP BY
- Access to a SQL Server or Azure SQL instance for labs
- A few slow queries from your own system (anonymised is fine)
Format
- Live online, 09:00–17:00 CET/CEST
- Max 8 participants
- Hands-on labs on your own environment
- Deck and lab files to keep
- 30 days of follow-up Q&A by email
Public classes are not recorded: eight people from different companies, hands-on labs, real questions about real systems. You get the deck, lab files and 30 days of email Q&A. Private runs can be recorded on request for internal use only.
Upcoming public classes
Dates for this course
First public dates are being set.
Tell me which course and I'll notify you first, or request a private run.
Three ways to work with me
Pick the format that fits the problem.
Half-day executive briefing
For leadership€1,900
€1,900 flat (net)
- 3 hours, remote
- Up to 10 leaders
Custom enterprise program
Quoted per program
- Private run of any course
- Custom courseware for your stack
Six or more? A private run is usually the better deal.
Your trainer
Ludwik C. Siadlak
- years as MCT
- 19
- professionals trained
- 10 000+
- countries
- 8+
Related courses
DP-300T00Condensed 2-day
DP-300 Essentials: Implement scalable database solutions using Azure SQL
2 days · Intermediate
€1,090 per seat
See the courseDP-080T00
Query and modify data with Transact-SQL
2 days · Beginner
€1,090 per seat
See the courseFAQ
Questions buyers ask before they book.
You receive a VAT invoice from a Polish company, payable by bank transfer in EUR or PLN. Public seats: Invoice on confirmation, 14-day payment terms. Pro-forma on request. Enterprise: milestone invoicing on request.
Yes. Send the PO number with the request and it appears on the invoice. Vendor onboarding forms: I fill them, you send them.
Prices are net. Polish companies: +23% VAT. EU companies with a valid VAT ID: reverse charge — no Polish VAT on the invoice, you self-account in your country. Outside the EU: no Polish VAT.
Substitute a colleague any time, free. Cancel 14+ days before: full refund or credit. Under 14 days: credit toward any date within 12 months. No-show: no refund. If I cancel or move a date: full refund plus first pick of the next date.
Public classes are not recorded: eight people from different companies, hands-on labs, real questions about real systems. You get the deck, lab files and 30 days of email Q&A. Private runs can be recorded on request for internal use only.
3 or more seats: 10% off. Six or more: ask for a private-run quote and I show you both numbers.
English or Polish. Materials in English (official Microsoft courseware), delivery in either language.
Courses map to Microsoft exams (e.g. DP-600 → Fabric Analytics Engineer Associate). Exam vouchers are not included. I tell you honestly whether the exam is worth your team's time. Essentials editions cover the exam-relevant core of the official 4-day outline in 2 intensive days; I say which modules I trim.
Request