AI DevOps Podcast16 Sep 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.

Denne episoden er hentet fra en åpen RSS-feed og er ikke publisert av Podme. Den kan derfor inneholde annonser.

Episoder(405)

Chris "Woody" Woodruff: AI-Assisted Software Architecture - Episode 405

https://clearmeasure.com/developers/forums/ Chris Woodruff, or as his friends call him, Woody, is a software architect of over 25 years. Woody loves software engineering, especially allowing applicati...

8 Jun 48min

J. Tower: A.I. Workflows - Episode 404

https://clearmeasure.com/developers/forums/ Jonathan Tower — known to friends and colleagues simply as "J." — is the founding partner of Trailhead Technology Partners, a custom software consulting fir...

1 Jun 36min

Ryan Riley: Development Process using AI - Episode 403

https://clearmeasure.com/developers/forums/ Ryan Riley is a Senior Lead Software Engineer at Quorum Software in Houston, TX, with deep expertise in functional programming, software architecture, and...

25 Mai 48min

Gaurav Seth: Leading in the AI World - Episode 402

https://clearmeasure.com/developers/forums/ Today I've have Gaurav Seth with us — he's a product executive at Microsoft working on fundamentally redefining how software gets built and scaled. He's bee...

18 Mai 44min

Stephen Cleary: Asynchronous Software - Episode 401

https://clearmeasure.com/developers/forums/ Stephen Cleary is a software developer, author, and independent consultant with deep expertise in asynchronous and concurrent programming in .NET. He is the...

11 Mai 34min

Tim Corey: Learning AI Architecture - Episode 400

https://clearmeasure.com/developers/forums/ Tim Corey is an nine-time Microsoft MVP, a software developer with more than 30 years of experience, and one of the most recognized online educators in the ...

4 Mai 41min

Chet Husk: .NET Tooling - Episode 399

https://clearmeasure.com/developers/forums/ Chet Husk is a Product Manager on the .NET Tools team at Microsoft, where he leads the .NET SDK, MSBuild, Template Engine, and Install Scripts teams -- shap...

27 Apr 43min

Pierce Boggan: AI Workflows - Episode 398

https://clearmeasure.com/developers/forums/ Pierce Boggan is the PM Lead for Visual Studio Code and GitHub Copilot at Microsoft, where he guides the product direction of the world's most popular code ...

20 Apr 38min