Erik Darling: Database Technical Debt - Episode 315

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.

Episoder(393)

Greg Leonardo: Azure and AI - Episode 369

Greg Leonardo: Azure and AI - Episode 369

Greg Leonardo is a Principal Cloud Architect, Certified Azure Solution Architect Expert, and Microsoft Azure MVP with over two decades of experience driving high-impact cloud transformations for globa...

29 Sep 202548min

John Bristowe: The Latest from Octopus Deploy - Episode 368

John Bristowe: The Latest from Octopus Deploy - Episode 368

John Bristowe brings over 20 years of experience in technology to his role as Community Director at Octopus Deploy. His career includes time at Progress and Microsoft, where he developed his skills in...

22 Sep 202532min

Mads Kristensen: Visual Studio 2026 - Episode 367

Mads Kristensen: Visual Studio 2026 - Episode 367

Mads is a Principal Product Manager on the Visual Studio team at Microsoft, where he champions developer productivity, performance, and extensibility. With a deep passion for streamlining the developm...

15 Sep 202545min

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 Sep 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 Sep 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 Aug 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 Aug 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 Aug 202541min

Populært innen Politikk og nyheter

giver-og-gjengen-vg
aftenpodden
forklart
aftenpodden-usa
popradet
i-retten
lydartikler-fra-aftenposten
stopp-verden
rss-gukild-johaug
det-store-bildet
fotballpodden-2
dine-penger-pengeradet
rss-ness
nokon-ma-ga
hanna-de-heldige
aftenbla-bla
bt-dokumentar-2
e24-podden
frokostshowet-pa-p5
rss-penger-polser-og-politikk