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.

Jaksot(388)

David Starr: DevOps Success Story - Episode 388

David Starr: DevOps Success Story - Episode 388

David Starr is the President and Founder of Cumulus26, which helps companies succeed in the Microsoft Azure Marketplace and other facets of Azure. He's had a multi-decade career at Microsoft, Godaddy ...

9 Helmi 46min

Kevin Griffin: Engineering for System Uptime - Episode 387

Kevin Griffin: Engineering for System Uptime - Episode 387

With over 20 years of software development experience, Kevin Griffin is a passionate and versatile leader, trainer, and consultant in the .NET ecosystem. He has worked with various industries, from th...

2 Helmi 46min

Maddy Montaquila: .NET Update - Episode 386

Maddy Montaquila: .NET Update - Episode 386

https://clearmeasure.com/developers/forums/ Maddy Montaquila is a Senior Product Manager on the Aspire team and has previous been on the MAUI team and has been working with .NET mobile apps since 2018...

26 Tammi 47min

Graham McMillan: Database DevOps - Episode 385

Graham McMillan: Database DevOps - Episode 385

Graham is the Chief Technical Officer at Redgate Software, where he leads the teams behind industry‑leading Database DevOps tools. Before Redgate, Graham's experiences includes multiple decades in com...

19 Tammi 36min

Carola Lilienthal and Henning Schwentner: Domain-Driven Transformation - Episode 384

Carola Lilienthal and Henning Schwentner: Domain-Driven Transformation - Episode 384

Carola Lilienthal is an architect and coach at Workplace Solutions. She is the author of Sustainable Software Architecture and shares her knowledge at international conferences. Henning Schwentner is ...

12 Tammi 35min

AD 2025 - The Year of AI-Driven Development – Looking Ahead to 2026 - Episode 383

AD 2025 - The Year of AI-Driven Development – Looking Ahead to 2026 - Episode 383

Today I'm going to reflect back on 2025, highlight some things and project forward into 2026. I think there are some very important developments and changes that we all shipping custom software need t...

5 Tammi 12min

Scott Hanselman: The Future of Software Engineering - Episode 382

Scott Hanselman: The Future of Software Engineering - Episode 382

Scott Hanselman is a teacher at heart. He speaks all over to whoever will listen. He's have written code that you, dear listener, has used. Scott has been blogging, coding, and podcasting a LONG time....

29 Joulu 202538min

Glenn Condron: Aspire Strategy for .NET - Episode 381

Glenn Condron: Aspire Strategy for .NET - Episode 381

Glenn is a Principal Product Manager for the App Platform team within the Developer Division at Microsoft, focusing on .NET. Before joining Microsoft Glenn was a developer in Australia where he worked...

22 Joulu 202552min

Suosittua kategoriassa Politiikka ja uutiset

aikalisa
rss-ootsa-kuullut-tasta
ootsa-kuullut-tasta-2
tervo-halme
politiikan-puskaradio
rss-podme-livebox
et-sa-noin-voi-sanoo-esittaa
viisupodi
otetaan-yhdet
rss-asiastudio
rss-mina-ukkola
rikosmyytit
the-ulkopolitist
rss-vaalirankkurit-podcast
io-techin-tekniikkapodcast
linda-maria
rss-kiina-ilmiot
rss-kaikki-uusiksi
rss-hyvaa-huomenta-bryssel
rss-kuka-mina-olen