Remote Session (in person) Execution plans … Where do I start?

Hi everyone,
We are having an in-person event that will host a speaker in Europe.
So we will meet at Ara as normal - with our speaker joining us.

This isn't a normal speaker either - it is a person who is one of the leaders in all things SQL and data...
Even when you are dealing with things like Fabric and Synapse - having a finely tuned source system is still relevant and completely necessary.

On July 27th we will have Data Saturday South Island back again and you can register here:

https://www.eventbrite.com/e/data-saturday-south-island-2024-tickets-875655427957

We will be offering some precon training the day before

which you can register here:

https://www.eventbrite.co.nz/e/precon-training-execution-plans-in-depth-tickets-926751517737

Our speaker tonight will be conducting that training, so this is an introduction to some of the material he will be covering.

Our speaker is Hugo Kornelis
http://linkedin.com/in/hugokornelis
Coming from a broad background in application development, data modeling, and database design, Hugo has spent the last years specialising in SQL Server development, with a specific deep specialisation in query performance tuning.

Session Abstract:
SQL (the language) is not a third generation language, where the developer tells the computer every step it needs to take. It is a declarative language that specifies the required results. SQL Server itself will figure out what steps it takes to get to those results. Most of the time, that works very well.
But sometimes it doesn’t. Sometimes a query takes too much time. You need to find out why, so you can fix it. That’s where the execution plan comes in. In the execution plan, SQL Server exposes exactly which steps it took for your query, so you can see why it’s slow.
However, execution plans can be daunting to the uninitiated. Especially for complex queries. Where do you even start?
In this session you will learn how to obtain execution plans. and how to start reading and understanding them.

Doors will open at 5:30pm, kick off will be at 6pm and will be an hour.
Drinks and food will be provided, look forward to seeing you all there for a great session with one of the leaders in the SQL Server industry.

Cheers,
Hamish