SQL Server Hates You - What the DBAs Never Told the Developers

Explore the hidden intricacies of SQL Server performance in this illuminating conference talk from NDC Oslo. Delve into the world of database administration from a developer's perspective, uncovering why seemingly innocuous code can cause performance issues across different environments. Learn about crucial SQL Server settings, their impact on development, and discover key tips for optimizing your database interactions. Investigate the potential pitfalls of certain SQL practices and gain a deeper understanding of isolation levels, including why the popular NOLOCK hint might be more detrimental than helpful. Benefit from the insights of a seasoned DBA with 20 years of experience as he bridges the gap between database management and development. Equip yourself with the knowledge to think critically about database engine behavior, empowering you to write more efficient code and troubleshoot performance issues effectively.