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.

Det här avsnittet är hämtat från ett öppet RSS-flöde och publiceras inte av Podme. Det kan innehålla reklam.

Avsnitt(413)

Jimmy Bogard: AI-Driven Development - Episode 414

https://clearmeasure.com/developers/forums/ Today's guest is a true heavyweight in the .NET open-source world — someone whose work has quietly, but profoundly, shaped the way countless developers bu...

10 Aug 42min

John Bristowe: Octopus Catchup - Episode 413

https://clearmeasure.com/developers/forums/ John Bristowe brings over 20 years of experience in technology to his role as Developer Advocate at Octopus Deploy. His career includes time at Progress a...

3 Aug 36min

Blake Caraway: AI in Business Operations - Episode 412

https://clearmeasure.com/developers/forums/ Blake Caraway is the General Manager of Texas Multi-Chem, Ltd., a Texas Hill Country company where he has spent over a decade transforming daily operations ...

27 Juli 44min

Michael Nygard: AI - Episode 411

https://clearmeasure.com/developers/forums/ Michael Nygard advises consulting firms, private equity teams, CTOs, CEOs, and boards when they require senior technology judgment for limited-term, high-...

20 Juli 45min

Brady Gaster: Squad AI Agent - Episode 410

Brady Gaster is a Principal PM Architect at GitHub, where he works on Apps, Agents, MIDI, and most notably, Squad — an open-source framework for orchestrating AI agent teams with GitHub Copilot. A lon...

13 Juli 49min

Matthew Renze: AI Changes - Episode 409

https://clearmeasure.com/developers/forums/ Matthew Renze is an AI researcher, consultant, and author, and the founder of Renze Consulting, where he has trained over 500,000 software developers and ...

6 Juli 33min

Tamir Dresher: Squad Agent Workflows - Episode 407

https://clearmeasure.com/developers/forums/ Tamir Dresher is a Principal Engineer at Microsoft Threat Protection, where he focuses on scaling AI agent systems and distributed architectures, bringing o...

22 Juni 40min

Erik Darling: T-SQL Architecture - Episode 406

https://clearmeasure.com/developers/forums/ 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 challengi...

15 Juni 37min