Erik Darling: Database Technical Debt - Episode 315
AI DevOps Podcast16 Syys 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.

Jaksot(398)

Richard Hundhausen and Brad Frazer: Who Owns the Code? - Episode 366

Richard Hundhausen and Brad Frazer: Who Owns the Code? - Episode 366

Brad Frazer is a Boise-based attorney and partner at Hawley Troxell, Idaho's largest law firm, where he leads the Intellectual Property & Internet practice group with a specific focus in IP Strategy, ...

8 Syys 202545min

Tony Cardella: .NET Testing using NCrunch - Episode 365

Tony Cardella: .NET Testing using NCrunch - Episode 365

Tony Cardella is a seasoned software engineer based in Houston, Texas. With a robust background in enterprise development, Tony brings deep expertise in the .NET Framework (C#), Python, and cloud plat...

1 Syys 202539min

Jonathan Peppers: GitHub Copilot for Maui Applications - Episode 364

Jonathan Peppers: GitHub Copilot for Maui Applications - Episode 364

Today's guest is Jon Peppers, Principal Software Engineer on the .NET MAUI team at Microsoft. Before building developer tools, Jonathan was a Xamarin MVP and the lead developer behind various cross-pl...

25 Elo 202536min

Micah Martin: Clean Coders - Episode 363

Micah Martin: Clean Coders - Episode 363

Micah Martin is a co-founder, CEO, and Studio Director for Clean Coders. He's a 2nd-generation coder, serial entrepreneur, family man, pilot, airplane builder, engineer, author, and just a normal guy ...

18 Elo 202539min

Burke Holland: GitHub Copilot Agent - Episode 362

Burke Holland: GitHub Copilot Agent - Episode 362

Burke Holland is a Principal Developer Advocate at Microsoft who leads the Developer Tools Advocacy team. He's done so much in developer tools, like growing VS Code from 6M to 40M+ users. He's a frequ...

11 Elo 202541min

Ted Neward: Software Architecture - Episode 361

Ted Neward: Software Architecture - Episode 361

Ted Neward currently labors on behalf of Capital One as a Senior Distinguished Engineer, leveraging his speaking, writing, and coding experience to bring a technology-focused and -sharpened mindset to...

4 Elo 20251h 6min

Joe Cuevas: Your First Decade as a Software Engineer  - Episode 360

Joe Cuevas: Your First Decade as a Software Engineer - Episode 360

Joe Cuevas Jr. is a seasoned software engineer based in San Antonio, Texas, with a strong focus on front-end development and user experience. At Southwest Research Institute, he contributes to innovat...

28 Heinä 202535min

Philip Japikse: Catching up - Episode 359

Philip Japikse: Catching up - Episode 359

An international speaker, Microsoft MVP, ASPInsider, MCSD, PSM II, PSD, and PST, and a passionate member of the developer community, Phil has been working with .NET since the first betas, developing s...

21 Heinä 202548min

Suosittua kategoriassa Politiikka ja uutiset

uutiscast
aikalisa
ootsa-kuullut-tasta-2
politiikan-puskaradio
rss-ootsa-kuullut-tasta
tervo-halme
rss-pinnalla
rss-podme-livebox
otetaan-yhdet
rss-asiastudio
aihe
et-sa-noin-voi-sanoo-esittaa
the-ulkopolitist
radio-antro
rss-vaalirankkurit-podcast
rss-ulkopoditiikkaa
rss-mina-ukkola
rss-girls-finish-f1rst
linda-maria
rss-raha-talous-ja-politiikka