Artwork

Content provided by Jeffrey Palermo. All podcast content including episodes, graphics, and podcast descriptions are uploaded and provided directly by Jeffrey Palermo or their podcast platform partner. If you believe someone is using your copyrighted work without your permission, you can follow the process outlined here https://player.fm/legal.
Player FM - Podcast App
Go offline with the Player FM app!

Grant Fritchey: SQL Server Performance Tuning - Episode 236

44:51
 
Share
 

Manage episode 357802417 series 2446935
Content provided by Jeffrey Palermo. All podcast content including episodes, graphics, and podcast descriptions are uploaded and provided directly by Jeffrey Palermo or their podcast platform partner. If you believe someone is using your copyrighted work without your permission, you can follow the process outlined here https://player.fm/legal.

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.

  continue reading

304 episodes

Artwork
iconShare
 
Manage episode 357802417 series 2446935
Content provided by Jeffrey Palermo. All podcast content including episodes, graphics, and podcast descriptions are uploaded and provided directly by Jeffrey Palermo or their podcast platform partner. If you believe someone is using your copyrighted work without your permission, you can follow the process outlined here https://player.fm/legal.

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.

  continue reading

304 episodes

All episodes

×
 
Loading …

Welcome to Player FM!

Player FM is scanning the web for high-quality podcasts for you to enjoy right now. It's the best podcast app and works on Android, iPhone, and the web. Signup to sync subscriptions across devices.

 

Quick Reference Guide