Erik Darling: Database Technical Debt - Episode 315
AI DevOps Podcast16 Syys 2024

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

Lee Brownhill: The Data Community - Episode 373

Lee Brownhill: The Data Community - Episode 373

Lee Brownhill is a Principal Cloud DBA at Cloud Rede with deep expertise in SQL Server performance tuning and automation. With years of experience across Azure and AWS, Lee helps clients optimize thei...

27 Loka 202538min

Aaron Palermo: Cyber Security and Systems Engineering with AI-Driven Development - Episode 372

Aaron Palermo: Cyber Security and Systems Engineering with AI-Driven Development - Episode 372

Aaron Palermo is a Senior Solutions Architect, DevOps engineer, and all-around cybersecurity expert. He works for a global cybersecurity services company, Appgate. Aaron was last on the show in episod...

20 Loka 202535min

Software Leadership with Jonathan "J." Tower - Episode 371

Software Leadership with Jonathan "J." Tower - Episode 371

Jonathan Tower is known to friends and colleagues simply as "J." J. is a Microsoft MVP, Telerik Developer Expert, and the founder of Trailhead Technology Partners, a global custom software consultancy...

13 Loka 202535min

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 Loka 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 Syys 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 Syys 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 Syys 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 Syys 202545min

Suosittua kategoriassa Politiikka ja uutiset

uutiscast
aikalisa
ootsa-kuullut-tasta-2
politiikan-puskaradio
rss-ootsa-kuullut-tasta
rss-pinnalla
tervo-halme
rss-podme-livebox
aihe
otetaan-yhdet
et-sa-noin-voi-sanoo-esittaa
rss-asiastudio
rss-vaalirankkurit-podcast
rss-girls-finish-f1rst
radio-antro
rss-mina-ukkola
rss-ulkopoditiikkaa
rikosmyytit
the-ulkopolitist
rss-hyvaa-huomenta-bryssel