SQL Server Performance For Developers

6:00 - 6:30 Welcome & announcements

6:30 - 7:45 Presentation

7:45 Prizes and closing

8:00 After-meeting social

Topic: SQL Server Performance For Developers

Have you ever wondered why DBA’s insist on saying that “select *” is bad or why a minor change to a query can dramatically change performance? Or why a query that has been working perfectly well all of a sudden isn’t? There are answers to those questions that make sense and are useful. This presentation will take you through the basics of SQL Server performance, starting with how indexes work and when to use them, then on to understanding the parse/compile/execute cycle for statements, how to read a query plan, how to use Profiler and Statistics IO to assess relative performance, and how the distribution of your data can impact query times. We’ll talk about what you can do to make performance both good and predictable, why DBA’s aren’t fond of most ORM solutions (and why sometimes they make sense), and why a good database design really does matter. The performance part of SQL Server is fun and interesting, and as I like to remind my fellow DBA’s it was written by developers!

Speaker: Andy Warren

Bio:

Andy Warren is a SQL Server consultant and trainer based in Orlando, FL, with over 14 years of experience. Focusing on administration, performance tuning, and SQL Server patterns and practices, he’s been a SQL Server MVP since 1998. Andy served two terms on the PASS Board of Directors, was a founding principal in SQLServerCentral, and created both the SQLSaturday and SQLRally event models.