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

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 Dec 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 Dec 202552min

Jared Parsons: The Latest with C# - Episode 380

Jared Parsons: The Latest with C# - Episode 380

Jared Parsons is a Developer Manager for the .NET Tools team at Microsoft. He's also done extensive work on the C# Compiler Team. Everybody tuning in probably uses his code on a day-to-day basis! Jare...

15 Dec 202542min

Chris Wilke: Generated AI Stories - Episode 379

Chris Wilke: Generated AI Stories - Episode 379

Chris has 25 years experience as a seasoned SaaS and AI product leader known for practical, people-first strategies to harness value from Generative AI for operational excellence. Chris developed the ...

8 Dec 202538min

Alvin Ashcraft: Community Conferences - Episode 378

Alvin Ashcraft: Community Conferences - Episode 378

Alvin is a senior content developer at Microsoft, author, and longtime leader in the .NET developer community. With over 27 years of experience in software development, Alvin has been recognized as a ...

1 Dec 202528min

Dan Clarke: Personal Productivity - Episode 377

Dan Clarke: Personal Productivity - Episode 377

Dan Clarke is a seasoned software consultant, Microsoft MVP, and founder of Everstack Ltd. Dan is widely known for his contributions to the .NET ecosystem and hosts the Unhandled Exception Podcast.  W...

24 Nov 202541min

Andrew Lock: Testing Frameworks - Episode 376

Andrew Lock: Testing Frameworks - Episode 376

Andrew Lock is a staff software engineer at Datadog and educator whose contributions to the .NET ecosystem have shaped how developers approach modern web applications.  Located in the UK, Andrew is a ...

17 Nov 202532min

Ben Day: SlideSpeaker.AI - Episode 375

Ben Day: SlideSpeaker.AI - Episode 375

Ben Day is a seasoned software consultant and fractional CTO. With over two decades of experience, he brings a blend of hands-on coding expertise, strategic clarity, and people-focused coaching to hel...

10 Nov 202536min

Populärt inom Politik & nyheter

svenska-fall
aftonbladet-krim
p3-krim
rss-krimstad
blenda-2
flashback-forever
politiken
rss-vad-fan-hande
rss-krimreportrarna
rss-sanning-konsekvens
aftonbladet-daily
motiv
spar
grans
rss-frandfors-horna
svd-ledarredaktionen
rss-flodet
dagens-eko
olyckan-inifran
krimmagasinet