AI DevOps Podcast16 Sep 2024

Erik Darling: Database Technical Debt - Episode 315

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 challenging technical issues. He runs a SQL Server Consulting and Coaching practice. In addition to his consulting services, he is also passionate about blogging, training, and contributing to open-source projects that help with SQL Server troubleshooting. He's given many public speaking engagements on the topic at conferences and events around the world, like PASS Summit and SQLBits.

Topics of Discussion:

[2:57] Eric's journey into SQL Server and database performance tuning.

[4:25] Challenges faced in early SQL Server work and evolving technical debt.

[7:47] The standard problems with databases over time.

[11:14] How technical debt shows up in SQL Server databases.

[15:20] How abstraction layers like ORMs contribute to technical debt.

[22:38] Performance issues as a result of technical debt in databases.

[25:19] Key advice on database schema design to improve performance.

[30:46] Key differences between Azure SQL DB and managed instances.

[37:23] Staffing challenges and solutions for managing SQL Server environments.

Mentioned in this Episode:

Clear Measure Way

Architect Forum

Software Engineer Forum

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

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!

Darling Data

Darling Data on X

Erik Darling

Darling Data on LinkedIn

Darling Data on TikTok

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(419)

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 Sep 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 Sep 52min

Jeffrey Palermo: AI-Driven Software Projects - Episode 418

https://clearmeasure.com/developers/forums/

7 Sep 18min

Joseph Guadagno: Architecture for AI Development - Episode 417

https://clearmeasure.com/developers/forums/ Joseph Guadagno is an experienced executive level software leader and architect over 30 years of software development experience and a Microsoft MVP since...

31 Aug 42min

Anna Hoffman: AI Database Development - Episode 416

https://clearmeasure.com/developers/forums/ Anna Hoffman is a Principal Group Product Manager for Azure Data on Microsoft's SQL Engineering team, where she works across SQL Server, Azure SQL, and SQ...

24 Aug 48min

Mark Seemann: AI Code Quality - Episode 415

https://clearmeasure.com/developers/forums/ Mark Seemann is a self-employed programmer and software architect based in Copenhagen, Denmark, and the author of Code That Fits in Your Head and Dependenc...

17 Aug 49min

Jimmy Bogard: AI-Driven Development - Episode 414

https://clearmeasure.com/developers/forums/ Today's guest is a true heavyweight in the .NET open-source world — someone whose work has quietly, but profoundly, shaped the way countless developers bu...

10 Aug 42min

John Bristowe: Octopus Catchup - Episode 413

https://clearmeasure.com/developers/forums/ John Bristowe brings over 20 years of experience in technology to his role as Developer Advocate at Octopus Deploy. His career includes time at Progress a...

3 Aug 36min