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

Rob Richardson on Containers in Azure - Episode 34

Rob Richardson on Containers in Azure - Episode 34

Today's guest is Rob Richardson — a software craftsman building web properties in ASP.NET, Node, Angular, and Vue. He's a software developer, a community leader, a mentor, and a business owner (of Ric...

29 Huhti 201938min

Rockford Lhotka on Software Architecture - Episode 33

Rockford Lhotka on Software Architecture - Episode 33

Today's guest is Rockford Lhotka. Rocky is an open source architect, professional author, speaker, Microsoft Regional Director, MVP, and avid outdoorsman! He's written numerous books on Visual Basic, ...

22 Huhti 201946min

Udi Dahan on Microservices - Episode 32

Udi Dahan on Microservices - Episode 32

This week Udi Dahan is joining The Azure DevOps Podcast! Udi is the founder of NServiceBus, the CEO of Particular Software, and Microsoft's Regional Director. He is one of the world's foremost experts...

15 Huhti 201946min

Party with Palermo at the Microsoft MVP Summit - Episode 31

Party with Palermo at the Microsoft MVP Summit - Episode 31

This week Jeffrey has a special episode for you all! It is recorded live, from the night before the Microsoft MVP Summit, at Jeffrey's annual "Party with Palermo!" get-together for MVPs. Jeffrey giv...

8 Huhti 201941min

Ted Neward on the 'Ops' Side of DevOps - Episode 30

Ted Neward on the 'Ops' Side of DevOps - Episode 30

Your host, Jeffrey Palermo, is excited to bring you this week's episode with his guest, Ted Neward! Ted is an Independent Consultant and Architect, as well as a long-time columnist of CODE Magazine. H...

1 Huhti 201954min

Matt Mitrik on GitHub with Azure Boards - Episode 29

Matt Mitrik on GitHub with Azure Boards - Episode 29

Today's guest is Matt Mitrik, the Sr. Program Manager of the Azure DevOps Services Team. Matt has been working with ALM and DevOps tools for roughly 13 years. He joined Microsoft in 2006 and has bee...

25 Maalis 201941min

Phil Haack on DevOps at GitHub - Episode 28

Phil Haack on DevOps at GitHub - Episode 28

Phil Haack joins the podcast to discuss DevOps at GitHub! Phil has an interesting and extensive career background. He started out as a Manager of Software Engineering back in 1997. Since then, he's ...

18 Maalis 201946min

Greg Leonardo on Deploying the Azure Way - Episode 27

Greg Leonardo on Deploying the Azure Way - Episode 27

On today's episode, Jeffrey Palermo welcomes back return guest, Greg Leonardo. Greg is a Cloud Architect at Campus Management Corp. and Webonology. Greg's main focus is to help organizations with Clou...

11 Maalis 201942min

Suosittua kategoriassa Politiikka ja uutiset

uutiscast
aikalisa
ootsa-kuullut-tasta-2
rss-ootsa-kuullut-tasta
politiikan-puskaradio
tervo-halme
rss-podme-livebox
rss-vaalirankkurit-podcast
et-sa-noin-voi-sanoo-esittaa
the-ulkopolitist
otetaan-yhdet
rss-asiastudio
aihe
rikosmyytit
rss-hyvaa-huomenta-bryssel
rss-merja-mahkan-rahat
rss-kaikki-uusiksi
rss-aijat-hopottaa-podcast
rss-raha-talous-ja-politiikka
viisupodi