Azure & DevOps Podcast

Grant Fritchey: SQL Server Performance Tuning - Episode 236


Listen Later

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 [email protected]work

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.

...more
View all episodesView all episodes
Download on the App Store

Azure & DevOps PodcastBy Jeffrey Palermo

  • 4.6
  • 4.6
  • 4.6
  • 4.6
  • 4.6

4.6

22 ratings


More shows like Azure & DevOps Podcast

View all
Software Engineering Radio by se-radio@computer.org

Software Engineering Radio

271 Listeners

Hanselminutes with Scott Hanselman by Scott Hanselman

Hanselminutes with Scott Hanselman

380 Listeners

The Changelog: Software Development, Open Source by Changelog Media

The Changelog: Software Development, Open Source

291 Listeners

Data Skeptic by Kyle Polich

Data Skeptic

476 Listeners

Software Engineering Daily by Software Engineering Daily

Software Engineering Daily

624 Listeners

The Cloudcast by Massive Studios

The Cloudcast

155 Listeners

Talk Python To Me by Michael Kennedy

Talk Python To Me

589 Listeners

Thoughtworks Technology Podcast by Thoughtworks

Thoughtworks Technology Podcast

41 Listeners

Python Bytes by Michael Kennedy and Brian Okken

Python Bytes

214 Listeners

Y Combinator Startup Podcast by Y Combinator

Y Combinator Startup Podcast

232 Listeners

Syntax - Tasty Web Development Treats by Wes Bos & Scott Tolinski - Full Stack JavaScript Web Developers

Syntax - Tasty Web Development Treats

987 Listeners

Kubernetes Podcast from Google by Abdel Sghiouar, Kaslin Fields

Kubernetes Podcast from Google

181 Listeners

.NET Rocks! by Carl Franklin and Richard Campbell

.NET Rocks!

245 Listeners

The Stack Overflow Podcast by The Stack Overflow Podcast

The Stack Overflow Podcast

62 Listeners

The Real Python Podcast by Real Python

The Real Python Podcast

141 Listeners