Name: Data Saturday Brisbane #55 - Precon
Start: 2024-07-19T09:00:00+10:00
End: 2024-07-19T17:00:00+10:00
Location: 400 George St

Get ready for a day full of peerformance insights at Data Saturday Brisbane #55 - Precon!
About this Event

Data Saturday Brisbane #55 - Precon

Date: July 19, 2024

Location: Level 28, 400 George Street.

Hey there data enthusiasts! Get ready for an epic pre-conference event at Data Saturday Brisbane #55 - Precon. Join us at Level 28, 400 George for a day filled with insightful performance tuning full day workshop.

Whether you're a seasoned data pro or just starting out, there's something for everyone. Don't miss out on this chance to level up your data skills and learn from International speaker, consultant and trainer Hugo Kornelius.

See you there!

Execution Plans in depth

For troubleshooting slow queries, looking at the execution plan is a good starting point. But sometimes, just looking at the plan does not help. Sometimes you need to dig deeper.

In this full-day pre-con session, you will learn everything you need to take your understanding of execution plans to the next level. For almost every operator you can encounter in an execution plan, we will look at the inner workings, and look at properties that can affect their performance. We will also look at how operators in a plan interact with and effect each other.

Aside from explaining all of the common operators, we will also touch on several operators that were introduced or modified in the newer versions of SQL Server.

In short: After this pre-con, you will be better prepared to look at execution plans, find the spot where it hurts, and then re-write your query to get a faster execution plan.

If you have seen some execution plans but feel you need to bring your understanding to the next level, then this pre-con is for you.

Hugo Kornelis is an established SQL Server community expert who spends a lot of time at various conferences. He is also a blogger, technical editor of a variety of books, and pluralsight author. He was awarded SQL Server MVP and Data Platform MVP 12 times (2006 - 2016 / 2019 - present).

When not working for the community, he is busy at his day job: freelance database developer/consultant.

Hugo has over 20 years of SQL Server experience in various roles. He has a strong database design background, but also loves to write and tune complex queries.