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.

Episoder(398)

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 Apr 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 Mar 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 Mar 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 Mar 201942min

Beth Massi on All Things .NET - Episode 26

Beth Massi on All Things .NET - Episode 26

This week, Jeffrey welcomes his guest, Beth Massi! Beth is the Product Marketing Manager for the entire .NET platform. She's also on the Board of Directors for .NET Foundation. She has been with Micro...

4 Mar 201941min

Martin Woodward on Azure DevOps With GitHub - Episode 25

Martin Woodward on Azure DevOps With GitHub - Episode 25

Today's featured guest is Martin Woodward! Martin is a Principal Group Program Manager on the Azure DevOps team at Microsoft as well as the Vice President of the .NET Foundation. Martin has been with ...

25 Feb 201948min

Scott Hunter on DevOps Capabilities in Azure - Episode 24

Scott Hunter on DevOps Capabilities in Azure - Episode 24

On today's episode, Scott Hunter joins your host, Jeffrey Palermo, to discuss DevOps capabilities in Azure. Scott is the Director of Program Management for .NET at Microsoft. When Scott first joined M...

18 Feb 201943min

Simon Timms on Azure Functions and Processes - Episode 23

Simon Timms on Azure Functions and Processes - Episode 23

Simon Timms is a long-time freelance Software Engineer, multi-time Microsoft MVP co-host of ASP.NET Monsters on Channel 9, and also runs the Function Junction Youtube channel. He considers himself a g...

11 Feb 201938min

Populært innen Politikk og nyheter

giver-og-gjengen-vg
aftenpodden
aftenpodden-usa
forklart
stopp-verden
popradet
dine-penger-pengeradet
det-store-bildet
rss-gukild-johaug
nokon-ma-ga
lydartikler-fra-aftenposten
fotballpodden-2
hanna-de-heldige
aftenbla-bla
rss-ness
rss-espen-lee-usensurert
e24-podden
rss-dannet-uten-piano
rss-penger-polser-og-politikk
rss-utenrikskomiteen-med-bogen-og-grasvik