Most programmers just use a database as a simple container for storing information, without really understanding the impact that a good, or bad, database design can have on the performance of their applications. This session will change that, and show how you can design your SQL Server databases in a way that will make them scalable and more efficient. By taking a detailed look at database design, indexes, and common T-SQL mistakes, we will see how these things can have an impact on resources and performance. We will discuss tips for serving up data faster, as well as things that can slow your queries down.

In this session I will provide direct explanations that can be incorporated immediately into your daily development, without all of the overly technical DBA mumbo-jumbo. Regardless of your skill level or programming language of choice, if you use SQL Server this session is for you.