Query Shaping - Advanced Query Tuning

Query Shaping represents an innovative set of techniques for optimising SQL Server query behaviour and is the result of over 20 years of data engineer experience. The presentation engages with query tuning concepts while introducing a method-based approach that can help de-mystify query tuning and save development time. The presentation covers:
1. Understanding the basics of Query Shaping using abstract visualization techniques to identify query behaviour potential based on query design.
2. Introduction to the free performance diagnostic tool sp_PerfSQL, an on-demand detailed diagnostics tool for first response troubleshooting of in-flight queries. The on-demand capability also facilitates testing query modifications to confirm and quantify the suitability of performance gains. A link will be provided to download the free Azure SQL compatible tool.
3. Bridging the gap between abstract query potential and performance diagnostics using method-based coding techniques that manipulate SQL Server behaviour to shape a more performant outcome.
Query Shaping emphasises the significance of IO on query performance and includes techniques to reduce IO. The session will be example driven using sp_PerfSQL.

Hybrid Session

As well as getting back in person, we have a Teams link available here. Please answer the question when you register about whether you’ll be there in person or remotely.

What Else to Expect?

The chance to network. We plan to incorporate the best parts of SQL Social and the SQL Server Group in our User Group, so there will be networking time, learning opportunities and introductions to new ideas.

Pizza and Door Prizes

Yes, we’d love to see you back in person if you are comfortable doing so. As a reward, we’ll have pizza and door prizes for those who come along and join in the networking time.

Agenda

5.30 Networking and Pizza

6.00 Query Shaping presentation