I am the Technical Curriculum Manager for .NET and Java at Pluralsight. I bring 20 years of experience to the role in writing software. I try to bring a pragmatic approach to everything I do by emphasizing practical solutions to real world scenarios encountered by developers every day. I appreciate code that is simple, maintainable and approachable and I enjoy working with others in the development community as we work together to improve ourselves and each other.
Are you mystified by SQL Server performance? Do you wonder why sometimes your SQL statements runs fast but other times, they run painfully slow? Do you wish there was a pragmatic set of steps you could go through to troubleshoot performance problems that didn't require you to have a PhD in database internals? If so, this talk is for you. In this talk, I'll describe database performance from a developer's point of view. I'll show how you can accurately measure the performance of any SQL statement and what you can do to improve its performance. I'll show how to create effective indexes and use capabilities built into SQL Server to find your worst performing SQL statements. At the end of this talk, you will no longer regard database performance as black magic, but instead be able to confidently analyze and solve any performance problems you encounter.