התחל במצב לא מקוון עם האפליקציה Player FM !
Erik Darling: Database Technical Debt - Episode 315
Manage episode 440154551 series 3541978
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:
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!
Want to Learn More?
Visit AzureDevOps.Show for show notes and additional episodes.
350 פרקים
Manage episode 440154551 series 3541978
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:
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!
Want to Learn More?
Visit AzureDevOps.Show for show notes and additional episodes.
350 פרקים
Tutti gli episodi
×
1 Scott Forsyth: How Kitchen Copilot uses AI - Episode 350 36:08

1 David Lykken: AI in Executive Strategy - Episode 349 33:40

1 Jeff Sutherland: The History of Agile - Episode 348 37:27

1 Adrienne Braganza Tacke: Code Review Patterns & Principles - Episode 347 39:16

1 April Yoho: GitHub in 2025 - Episode 346 37:56

1 Jerry Nixon: .NET Aspire and Databases - Episode 345 50:35

1 Stephen Toub: AI in .NET - Episode 344 37:31

1 Bruno Capuano: AI Developer Training in .NET - Episode 343 38:23

1 Per Kops: Architecture of Ollama and Local LLMs - Episode 342 35:44

1 Patrick Escarcega: Software Engineering Principles - Episode 341 32:22

1 Daniel Roth: .NET 10 Preview 1 - Episode 340 40:02

1 Dustin Campbell: C# 13 - Episode 339 38:59

1 Scott Nichols: Azure AI Foundry - Episode 338 40:40

1 Shaun Walker: Seven Years of Blazor - Episode 337 42:12

1 Matt McCleary: Telemetry & Observability in .NET Aspire - Episode 336 40:50
ברוכים הבאים אל Player FM!
Player FM סורק את האינטרנט עבור פודקאסטים באיכות גבוהה בשבילכם כדי שתהנו מהם כרגע. זה יישום הפודקאסט הטוב ביותר והוא עובד על אנדרואיד, iPhone ואינטרנט. הירשמו לסנכרון מנויים במכשירים שונים.