NOTE: We lost audio for the last demo (15 min).
Have you ever developed slowly running queries and wondered how to tune them? In this session you will learn some performance tuning tips from a DBA who has a developer background. We will go over how to identify bottleneck queries and how to measure them. We will go over basic indexing concepts for improving workloads. Finally, we will cover some coding patterns that are developer friendly but are not SQL Server database engine friendly and show you how to optimize them.
John Sterrett is an Independent Consultant and Group Principal at Linchpin People. Previously, he was a Sr. Database Admin Advisor for Dell, directly responsible for several mission-critical databases behind dell.com. John has presented at many community events, including PASS Summit, SQL Rally, 24 Hours of PASS, SQL Saturdays, PASS Chapters, and Virtual Chapter meetings. John is a PASS Regional Mentor and leader of CACTUSS (Austin SQL User Group) and the HADR Virtual Chapter. John also blogs at http://johnsterrett.com