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

Shaun Walker: Seven Years of Blazor - Episode 337

Shaun Walker: Seven Years of Blazor - Episode 337

Shaun Walker is the founder and CEO of Devessence, a global technology consultancy with a boutique approach. He's also the founder of the Oqtane and DotNetNuke web application frameworks, which have e...

17 Helmi 202542min

Matt McCleary: Telemetry & Observability in .NET Aspire - Episode 336

Matt McCleary: Telemetry & Observability in .NET Aspire - Episode 336

Matt McCleary is a Senior Product Manager at Microsoft working on observability tools to empower developers to be successful. Matt started his career in engineering and has worked in tech for 10 years...

10 Helmi 202540min

Chris Ayers: .NET Aspire and AI - Episode 335

Chris Ayers: .NET Aspire and AI - Episode 335

Chris Ayers is a Senior Site Reliability Engineer on Microsoft's AzRel Risk SRE team, drawing on years of experience in cloud architecture, software development, and DevOps practices. He's passionate ...

3 Helmi 202541min

Scott Ambler: The State of Agile - Episode 334

Scott Ambler: The State of Agile - Episode 334

Scott Ambler helps people and teams adopt new ways of working (WoW) and evolve their ways of thinking (WoT), particularly around data warehousing and data quality. He is the creator of the Agile Model...

27 Tammi 202546min

Ryan Booz: The State of the Database in 2025 - Episode 333

Ryan Booz: The State of the Database in 2025 - Episode 333

Ryan is an Advocate at Redgate focusing on PostgreSQL. Ryan has been working as a PostgreSQL advocate, developer, DBA, and product manager for over 20 years, primarily working with time-series data on...

20 Tammi 202540min

James Montemagno: .NET Aspire with Azd - Episode 332

James Montemagno: .NET Aspire with Azd - Episode 332

James Montemagno is a Principal Lead Program Manager for the Developer Community at Microsoft. He has been a .NET developer since 2005, working in a wide range of industries including game development...

13 Tammi 202546min

Brady Gaster: Upgrading .NET apps - Episode 331

Brady Gaster: Upgrading .NET apps - Episode 331

Brady Gaster is a Principal Program Manager on the .NET and Visual Studio team at Microsoft where he works on Orleans, SignalR, microservices, APIs, and integration with Azure service teams in hopes o...

6 Tammi 202547min

Aaron Powell: .NET Aspire Community Toolkit - Episode 330

Aaron Powell: .NET Aspire Community Toolkit - Episode 330

Aaron is a Developer Advocate at Microsoft. Having spent 15 years doing web development, he's seen it all, from browser wars to the rise of AJAX and the fall of 20 JavaScript frameworks (and that was ...

30 Joulu 202447min

Suosittua kategoriassa Politiikka ja uutiset

uutiscast
aikalisa
rss-ootsa-kuullut-tasta
ootsa-kuullut-tasta-2
politiikan-puskaradio
tervo-halme
rss-vaalirankkurit-podcast
rss-podme-livebox
viisupodi
rss-asiastudio
et-sa-noin-voi-sanoo-esittaa
otetaan-yhdet
rikosmyytit
the-ulkopolitist
radio-antro
rss-kaikki-uusiksi
rss-hyvaa-huomenta-bryssel
rss-raha-talous-ja-politiikka
rss-tasta-on-kyse-ivan-puopolo-verkkouutiset
rss-girls-finish-f1rst