About the Presentation
Database Design Fundamentals
In this session I will give an overview of how to design a database, including the common normal forms and why they should matter to you if you are creating or modifying SQL Server databases. Data should be easy to work with in SQL Server if the database has been organized as close as possible to the standards of normalization that have proven for many years. Many common T-SQL programming "difficulties" are the result of struggling against the way data should be structured and can be avoided by applying the basic normalization techniques and are obvious things that you find yourself struggling with time and again (i.e. using the SUBSTRING function in a WHERE clause meaning you can't use an index efficiently).
Session Level: Intermediate
Louis Davidson
I have been in the IT industry for 16 years as a corporate database developer and architect. I have been a Microsoft MVP for 5 years and have written 4 books on database design. Currently I am a Senior Data Architect for Compass Technology Management, supporting the Christian Broadcasting Network and NorthStar Studios in Nashville, Tennessee. I have a bachelor's degree from the University of Tennessee at Chattanooga in computer science with a minor in mathematics.
Contact URL:
http://drsql.org