AI DevOps Podcast13 Maalis 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.

Tämä jakso on lisätty Podme-palveluun avoimen RSS-syötteen kautta eikä se ole Podmen omaa tuotantoa. Siksi jakso saattaa sisältää mainontaa.

Jaksot(424)

Henrik Kniberg: Autonomous AI Agents - Episode 425

https://clearmeasure.com/developers/forums/ Henrik Kniberg is the co-founder and Chief Scientist of Abundly AI in Stockholm, where he leads development of a platform for building autonomous AI agent...

26 Loka 47min

Greg Leonardo: AI & Azure - Episode 424

https://clearmeasure.com/developers/forums/ Greg Leonardo is a Certified Azure Solution Architect, and Microsoft Certified Trainer, and the founder of Webonology, a firm focused on cloud migration a...

19 Loka 42min

Daniel Vacanti: What's AI Done To Agile - Episode 423

https://clearmeasure.com/developers/forums/ Daniel Vacanti is co-founder of ProKanban.org and a 20-year veteran of the Lean and Agile software industry who helped develop the Kanban Method in 2007 a...

12 Loka 49min

Sam Nasr: AI Transformation - Episode 422

https://clearmeasure.com/developers/forums/ Sam Nasr is a Senior Software Engineer and Trainer at NIS Technologies in Cleveland, Ohio, specializing in the Microsoft AI stack, Azure, and .NET develop...

5 Loka 29min

Mark Michaelis: Mastering the Agentic Coding Workflow - Episode 421

https://clearmeasure.com/developers/forums/ Today I'm joined by Mark Michaelis, founder, CEO and Chief Technical Architect of IntelliTect in Spokane, Washington, and a Microsoft Regional Director an...

28 Syys 40min

Justin Martin: Commanding Fleets of AI Agents - Episode 420

https://clearmeasure.com/developers/forums/ Today I'm joined by Justin Martin, a product-focused engineering leader based in Austin, Texas, with more than twenty years of experience driving technica...

21 Syys 38min

Uncle Bob Martin: AI Driven Development - Episode 419

https://clearmeasure.com/developers/forums/ Today I'm joined by Robert C. Martin, known to most of the industry as Uncle Bob - a programmer since 1970, co-author of the Agile Manifesto, and the firs...

14 Syys 52min