Grant Fritchey: SQL Server Performance Tuning - Episode 236

In this episode, SQL Server Performance Tuning expert and Microsoft Data Platform MVP Grant Fritchey is interviewed. Grant is a Product Advocate at Red Gate Software, with more than 30 years of experience in the industry as a DBA and developer. He is an active participant in the SQL Server Central discussion forums, writes articles for SQL Server Central and Simple-Talk, and has authored several books including SQL Server Query Performance Tuning and SQL Server Execution Plans.

The interview covers topics ranging from Grant's personal journey into the industry to the ecosystem of systems broken into multiple applications, as well as the main tools developers should have in their toolbox to optimize performance. Grant emphasizes that while the industry has shifted, at the core of performance is always the code. He highly recommends using Extended Events and Query Store as essential tools for developers to achieve optimization. Lastly, he gives his outlook on the future of the industry.

This episode is a great listen for aspiring SQL Server Performance Tuning experts and developers seeking performance optimization skills and knowledge.

Mentioned in this episode are Red Gate Software, Query Performance Tuning, ScaryDBA.com, and SQL Server. For more information about the topics discussed in this episode, visit AzureDevOps.Show for show notes and other episodes.