Erik Darling, a DBA and architect known for his expertise in database performance, dives into the world of technical debt in SQL Server. He shares his journey and early challenges, emphasizing how common issues evolve over time. The conversation highlights the impact of abstraction layers like ORMs on performance, and offers essential advice for database schema design. Erik also addresses staffing challenges in SQL environments and the unique aspects of Azure SQL migrations, stressing the need for ongoing education in the field.

Join SQL Server experts Erik Darling and Kendra Little as they explore a treasure trove of performance tuning techniques. They rate everything from recompile hints to scalar UDFs, adding humor to the complexities of optimization. Discover their takes on new features like the Query Store and the Resource Governor. They debate the merits of Common Table Expressions and index rebuilding while reflecting on memory management. With insights on filtered indexes and the future of T-SQL, this conversation is a must-listen for anyone passionate about SQL Server performance.

Join Erik Darling, a well-known contributor in the SQL Server community, as he dives into performance tuning strategies. He shares his innovative scripts for gathering SQL Server performance metrics, making troubleshooting a hassle-free experience. The conversation also touches on the importance of community contributions, and challenges faced with SQL Server's Query Store. Expect some laughs as they navigate personal anecdotes and culinary adventures. It's an entertaining blend of tech insights and community spirit!