Grant Fritchey: SQL Server Performance Tuning - Episode 236

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.

Published on:

Learn more
Azure DevOps Podcast
Azure DevOps Podcast

The Azure DevOps Podcast is a show for developers and devops professionals shipping software using Microsoft technologies. Each show brings you hard-hitting interviews with industry experts innovating better methods and sharing success stories. Listen in to learn how to increase quality, ship quickly, and operate well. Hosted by Jeffrey Palermo and sponsored by Clear Measure, Inc.

Share post:

Related posts

Best Practices for Writing Clean and Effective SQL Code

Structured Query Language (SQL) is a crucial tool for managing data in relational databases, and it is essential to understand the significanc...

3 months ago

SQL Server Express: User Guide With Examples

In the era of technology, data management and manipulation are essential skills, particularly in the context of AI applications. That's where ...

11 months ago

Migrating On-Premises databases to Azure SQL Database: Everything you need you know

Are you considering migrating your on-premises databases to Azure SQL? If so, this article is a must-read, as it covers everything you need to...

1 year ago

Allow Azure Services and resources to access this server – How it works in Azure SQL Database?

When creating an Azure SQL Database, one of the initial options you'll come across is the "Allow Azure Services and resources to access this s...

1 year ago

Mastering DP-500: Performance Tuning of Power Query and Data Sources

If you're looking to optimize the performance of your Power BI solutions, this article is a must-read. Performance tuning can be a complex and...

1 year ago

Maximizing Azure SQL Database performance with a globally distributed Redis write-behind cache

For those looking to leverage Azure SQL Database for high-performance data storage, this post explores the potential of using a globally distr...

1 year ago

SQL Server > Find a specific value in column of table in the whole database using T-SQL

In this post, you'll learn how to use T-SQL to find a specific value in a column within a SQL Server database. This can come in handy when you...

1 year ago

How to quickly match data of two recordsets in SQL Server?

When it comes to optimizing queries in T-SQL, comparing data between two recordsets is a common activity that demands an effective approach. T...

1 year ago

Announcing JSON Enhancements in Azure SQL Database, Azure SQL Managed Instance and SQL Server 2022

Azure SQL Database, Azure SQL Managed Instance and SQL Server 2022 have recently announced enhancements to their JSON text processing capabili...

2 years ago
Stay up to date with latest Microsoft Dynamics 365 and Power Platform news!
* Yes, I agree to the privacy policy