Over the years I have spent working with SQL Server, the personal time investment that has repaid itself more than any other is becoming intimately familiar with execution plans and how they can be used to diagnose and correct performance problems.
There is nothing I enjoy more than talking about execution plans, the query optimizer, and how internals knowledge can be applied to solve real problems. Living in New Zealand, I don’t get to speak on this topic as often as I would like, primarily due to the time and travel costs involved in getting to the places most SQL people live and work.
So, I am very pleased to announce I will be presenting a Pre-Conference Training Day on Mastering Execution Plan Analysis in Melbourne, Australia, on Friday 6 February, 2015 as part of the SQL Saturday #365 event, being held at Monash University’s Caulfield Campus.
The course runs from 8:30am to 5pm, beginning with an overview of the SQL Server Query Optimizer, followed by comprehensive coverage of execution plans and plan analysis techniques. Supported by heaps of heavily-commented T-SQL code examples, the course packs an enormous amount of information into one fast-paced day. Though not suitable for people completely new to SQL Server, developers and database professionals with a few years’ experience working with SQL Server will find many new insights, internal details, and practical tips that they will refer to time and time again.
The standard ticket price is AUD 315. Tickets are available until 2 February 2015 AEDT.
I hope to see you there!