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

Scott Hunter: AI-driven development - Episode 351

Scott Hunter: AI-driven development - Episode 351

Scott is the Vice President of Product for Azure Developer Experience. He builds all the .NET tools for Azure. Topics of Discussion: [1:49] Scott's Microsoft journey and .NET evolution. [3:39] AI's ...

26 Maj 202540min

Scott Forsyth: How Kitchen Copilot uses AI - Episode 350

Scott Forsyth: How Kitchen Copilot uses AI - Episode 350

Scott has spent over 25 years in the IT field, working in disciplines such as systems architecture, software development, team growth, and entrepreneurship. He was a Microsoft MVP for 12 years in ASP....

19 Maj 202536min

David Lykken: AI in Executive Strategy - Episode 349

David Lykken: AI in Executive Strategy - Episode 349

David Lykken, a 51-year veteran of the mortgage industry, is the Founder, President & Chief Transformational Officer of Transformational Mortgage Solutions (TMS). With decades of expertise, Lykken and...

12 Maj 202533min

Jeff Sutherland: The History of Agile - Episode 348

Jeff Sutherland: The History of Agile - Episode 348

Jeff is the co-creator of Scrum and a leading expert on how the Scrum framework has evolved to meet the needs of today's business. The framework he developed in 1993 and formalized in 1995 with Ken Sc...

5 Maj 202537min

Adrienne Braganza Tacke: Code Review Patterns & Principles - Episode 347

Adrienne Braganza Tacke: Code Review Patterns & Principles - Episode 347

Adrienne Braganza Tacke is an accomplished author and software engineer with a passion for educating others about software development. Choosing a path distinct from the expected trajectory of nursing...

28 Apr 202539min

April Yoho: GitHub in 2025 - Episode 346

April Yoho: GitHub in 2025 - Episode 346

April is a senior developer advocate and DevOps practice lead for GitHub, specializing in application transformation and DevOps ways of working. Her focus is working on Microsoft Azure to take custome...

21 Apr 202537min

Jerry Nixon: .NET Aspire and Databases - Episode 345

Jerry Nixon: .NET Aspire and Databases - Episode 345

Jerry Nixon is a Principal Program Manager on the SQL Server team focused on the Data API builder. He's also a fanatic for #CSharp, #StarTrek, and Etymology. He also serves as a professor at Colorado ...

14 Apr 202550min

Stephen Toub: AI in .NET  - Episode 344

Stephen Toub: AI in .NET - Episode 344

Stephen Toub is a Partner Software Engineer at Microsoft. Stephen has been at Microsoft for almost 24 years and has done it all. If it has to do with .NET, he's been in it. And today, he looks after a...

7 Apr 202537min

Populärt inom Politik & nyheter

aftonbladet-krim
rss-krimstad
svenska-fall
p3-krim
spar
aftonbladet-daily
flashback-forever
politiken
rss-sanning-konsekvens
rss-krimreportrarna
motiv
rss-vad-fan-hande
blenda-2
rss-flodet
rss-frandfors-horna
rss-expressen-dok
grans
rss-aftonbladet-krim
svd-ledarredaktionen
ett-rent-noje