Name: Query Shaping - Advanced Query Tuning
Start: 2023-10-24T17:30:00+11:00
End: 2023-10-24T19:30:00+11:00
Location: Microsoft

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](https://teams.microsoft.com/l/meetup-join/19%3ameeting_ZWMxMmYwYzQtZWQ3NC00M2EwLTk4ZDMtODc5ZDkwNmNlYzk3%40thread.v2/0?context=%7b%22Tid%22%3a%2272f988bf-86f1-41af-91ab-2d7cd011db47%22%2c%22Oid%22%3a%229b6297cc-d491-4dc1-8e29-fc99490c1af8%22%7d). 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

Kelly Broekstra

Martin Cairney

Melbourne Data Platform User Group

Azure Data Tech Groups

Technology

Business Intelligence & Data Warehousing

Data Analytics

Data Visualization

Microsoft Azure

SQL Azure

Power BI

Over 25 years’ industry experience with emphasis on SQL development and performance tuning, data migration solutions, database design and optimized implementation, business intelligence delivery, and database administration. Creator of Query Shaping an innovative advancement in method-based query performance tuning, and sp_PerfSQL a detailed in-flight query performance diagnostics tool compatible with Azure SQL Database and Managed Instance.

Edward Haynes

Query Shaping - Advanced Query Tuning

Microsoft

Share

Melbourne Data Platform User Group

Query Shaping - Advanced Query Tuning

Melbourne Data Platform User Group

Details

Members are also interested in