Understanding and Optimizing SQL Server Performance

Abstract
Do you need help understanding why queries are suddenly slow? Or why reports have highly variable performance? The database is a common bottleneck for many applications, and many developers need to understand database performance better. In this session, you will learn how SQL Server and Azure SQL execute and process queries and the importance of query execution plans. You will also learn about T-SQL patterns and anti-patterns, how newer optimizer features can benefit your workloads, and how to monitor your query performance across SQL Server versions and platforms.

Bio
Joey Dantoni Principal Consultant Denny Cherry and Associates Consulting

Joseph D'Antoni is a Principal Consultant at Denny Cherry and Associates Consulting, and a Microsoft Data Platform MVP with over 20 years of experience working in both Fortune 500 and smaller firms. He is a frequent speaker at major tech events like Microsoft Ignite, PASS Summit and Enterprise Data World. He blogs about all topics technology at joeydantoni.com. He believes that no single platform is the answer to all technology problems. He lives in Malvern, PA and holds a BS in Computer Information Systems from Louisiana Tech University and an MBA from North Carolina State University, and is the co-author of the Microsoft book "Introducing SQL Server 2016"