Grant Fritchey: SQL Server Performance Tuning - Episode 236

Grant Fritchey: SQL Server Performance Tuning - Episode 236

A Microsoft Data Platform MVP, Grant Fritchey works for Red Gate Software as a Product Advocate. Grant has more than 30 years of experience in the industry as a DBA and developer. Grant is an active participant in the SQL Server Central discussion forums. He writes articles for SQL Server Central and Simple-Talk. He blogs regularly at scarydba.com. Grant is the author of several books including SQL Server Query Performance Tuning and SQL Server Execution Plans. Grant teaches classes on data management and databases around the world. He teaches in the smallest user group settings and at the largest events.

Topics of Discussion:

[2:24] How did Grant get into the industry?

[5:40 Are there any big shifts that more recent developers and all developers need to know about shifts in how databases have worked?

[13:10] What should developers know about the ecosystem when you've taken a system and broken it up into multiple applications?

[16:07] What has changed in Grant's book, Query Performance Tuning?

[20:34] Performance comes down to the code. It always comes down to the code.

[23:58] What are some of the main tools that developers should have in their toolbox?

[26:20] Why Grant recommends Extended Events and Query Store.

[32:41] Grant gives us his sales pitch.

[38:40] What does Grant think the future looks like?

Mentioned in this Episode:

Clear Measure Way

Architect Forum

Software Engineer Forum

Programming with Palermo — New Video Podcast! Email us programming@palermo.network

Clear Measure, Inc. (Sponsor)

.NET DevOps for Azure: A Developer's Guide to DevOps Architecture the Right Way, by Jeffrey Palermo — Available on Amazon!

Jeffrey Palermo's Twitter — Follow to stay informed about future events!

Architect Tips — Video podcast!

Azure DevOps

Query Performance Tuning

ScaryDBA.com

SQL

Want to Learn More?

Visit AzureDevOps.Show for show notes and additional episodes.

Episoder(386)

Maddy Montaquila: .NET Update - Episode 386

Maddy Montaquila: .NET Update - Episode 386

https://clearmeasure.com/developers/forums/ Maddy Montaquila is a Senior Product Manager on the Aspire team and has previous been on the MAUI team and has been working with .NET mobile apps since 2018...

26 Jan 47min

Graham McMillan: Database DevOps - Episode 385

Graham McMillan: Database DevOps - Episode 385

Graham is the Chief Technical Officer at Redgate Software, where he leads the teams behind industry‑leading Database DevOps tools. Before Redgate, Graham's experiences includes multiple decades in com...

19 Jan 36min

Carola Lilienthal and Henning Schwentner: Domain-Driven Transformation - Episode 384

Carola Lilienthal and Henning Schwentner: Domain-Driven Transformation - Episode 384

Carola Lilienthal is an architect and coach at Workplace Solutions. She is the author of Sustainable Software Architecture and shares her knowledge at international conferences. Henning Schwentner is ...

12 Jan 35min

AD 2025 - The Year of AI-Driven Development – Looking Ahead to 2026 - Episode 383

AD 2025 - The Year of AI-Driven Development – Looking Ahead to 2026 - Episode 383

Today I'm going to reflect back on 2025, highlight some things and project forward into 2026. I think there are some very important developments and changes that we all shipping custom software need t...

5 Jan 12min

Scott Hanselman: The Future of Software Engineering - Episode 382

Scott Hanselman: The Future of Software Engineering - Episode 382

Scott Hanselman is a teacher at heart. He speaks all over to whoever will listen. He's have written code that you, dear listener, has used. Scott has been blogging, coding, and podcasting a LONG time....

29 Des 202538min

Glenn Condron: Aspire Strategy for .NET - Episode 381

Glenn Condron: Aspire Strategy for .NET - Episode 381

Glenn is a Principal Product Manager for the App Platform team within the Developer Division at Microsoft, focusing on .NET. Before joining Microsoft Glenn was a developer in Australia where he worked...

22 Des 202552min

Jared Parsons: The Latest with C# - Episode 380

Jared Parsons: The Latest with C# - Episode 380

Jared Parsons is a Developer Manager for the .NET Tools team at Microsoft. He's also done extensive work on the C# Compiler Team. Everybody tuning in probably uses his code on a day-to-day basis! Jare...

15 Des 202542min

Chris Wilke: Generated AI Stories - Episode 379

Chris Wilke: Generated AI Stories - Episode 379

Chris has 25 years experience as a seasoned SaaS and AI product leader known for practical, people-first strategies to harness value from Generative AI for operational excellence. Chris developed the ...

8 Des 202538min

Populært innen Politikk og nyheter

giver-og-gjengen-vg
aftenpodden
aftenpodden-usa
forklart
stopp-verden
popradet
det-store-bildet
fotballpodden-2
dine-penger-pengeradet
rss-gukild-johaug
bt-dokumentar-2
nokon-ma-ga
lydartikler-fra-aftenposten
aftenbla-bla
hanna-de-heldige
rss-dannet-uten-piano
e24-podden
frokostshowet-pa-p5
rss-ness
rss-penger-polser-og-politikk