AI DevOps Podcast13 Mar 2023

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.

Denne episoden er hentet fra en åpen RSS-feed og er ikke publisert av Podme. Den kan derfor inneholde annonser.

Episoder(411)

Blake Caraway: AI in Business Operations - Episode 412

https://clearmeasure.com/developers/forums/ Blake Caraway is the General Manager of Texas Multi-Chem, Ltd., a Texas Hill Country company where he has spent over a decade transforming daily operations ...

27 Jul 44min

Michael Nygard: AI - Episode 411

https://clearmeasure.com/developers/forums/ Michael Nygard advises consulting firms, private equity teams, CTOs, CEOs, and boards when they require senior technology judgment for limited-term, high-...

20 Jul 45min

Brady Gaster: Squad AI Agent - Episode 410

Brady Gaster is a Principal PM Architect at GitHub, where he works on Apps, Agents, MIDI, and most notably, Squad — an open-source framework for orchestrating AI agent teams with GitHub Copilot. A lon...

13 Jul 49min

Matthew Renze: AI Changes - Episode 409

https://clearmeasure.com/developers/forums/ Matthew Renze is an AI researcher, consultant, and author, and the founder of Renze Consulting, where he has trained over 500,000 software developers and ...

6 Jul 33min

Tamir Dresher: Squad Agent Workflows - Episode 407

https://clearmeasure.com/developers/forums/ Tamir Dresher is a Principal Engineer at Microsoft Threat Protection, where he focuses on scaling AI agent systems and distributed architectures, bringing o...

22 Jun 40min

Erik Darling: T-SQL Architecture - Episode 406

https://clearmeasure.com/developers/forums/ Erik Darling makes your database faster in exchange for money. He is a DBA, developer, and architect with a track record of tackling even the most challengi...

15 Jun 37min

Chris "Woody" Woodruff: AI-Assisted Software Architecture - Episode 405

https://clearmeasure.com/developers/forums/ Chris Woodruff, or as his friends call him, Woody, is a software architect of over 25 years. Woody loves software engineering, especially allowing applicati...

8 Jun 48min

J. Tower: A.I. Workflows - Episode 404

https://clearmeasure.com/developers/forums/ Jonathan Tower — known to friends and colleagues simply as "J." — is the founding partner of Trailhead Technology Partners, a custom software consulting fir...

1 Jun 36min