In this full-day seminar, you will gain core knowledge about how SQL Server works, along with a host of information covering memory usage, the optimizer, indexes, statistics, and table design.
Most importantly, you will be exposed to an elaborate and detailed tour of T-SQL patterns and anti-patterns, many of which will enlighten or surprise you. You will also learn about default settings to override, trace flags that can help query analysis, optimizing tempdb, and how to avoid “it worked on my machine” syndrome.
Packed with sample code, live demos, and even pop quizzes, you will leave the room armed with many new insights into making your design phase more robust, your queries more efficient, and making life easier for your DBAs, fellow developers, and end users.
Lunch and snacks are included.
About Aaron Bertrand...
Aaron Bertrand is a senior consultant for SQL Sentry, makers of performance monitoring and event management software for SQL Server, Analysis Services, and Windows. He blogs at sqlperformance.com, has been a Microsoft MVP since 1997, is a four-time SQL Cruiser, and speaks frequently at various community events. You can find his MVP profile at