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.

Avsnitt(394)

Peter Ritchie: .NET Foundation - Episode 370

Peter Ritchie: .NET Foundation - Episode 370

Peter Ritchie is a veteran software architect and consultant with over 35 years of experience in the tech industry. Peter is renowned for his deep expertise in .NET development, distributed systems, a...

6 Okt 202528min

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

Populärt inom Politik & nyheter

svenska-fall
p3-krim
aftonbladet-krim
spar
fordomspodden
rss-krimstad
flashback-forever
rss-vad-fan-hande
aftonbladet-daily
motiv
rss-sanning-konsekvens
krimmagasinet
politiken
rss-krimreportrarna
rss-frandfors-horna
kungligt
grans
rss-flodet
dagens-eko
sydsvenskan-dok