Thank you to our sponsors

 

 

 

All 24 Hours of PASS registrants will automatically become PASS members. (membership is free!)

 


 

 

 

Database Design Fundamentals


Return to Session Listings

Presenter: Louis Davidson, Christian Broadcasting Network
 

Session 23 (10:00 GMT on May 20)
 

Session Details

Data should be easy to work with in SQL Server if the database has been designed as close as possible to the proven standards of normalization. Many common T-SQL programming "difficulties" are the result of struggling against the way data should be structured (e.g., not being able to use an index efficiently because you used the SUBSTRING function in a WHERE clause). You can avoid such problems by applying the basic normalization techniques covered in this session, which provides a practical 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.

 

About the Speaker

Louis Davidson has been in the IT industry for 16 years as a corporate database developer and architect. A SQL Server MVP for 5 years, he has written four books on database design. Louis is currently the data architect and part-time DBA for the Christian Broadcasting Network, supporting offices in Virginia Beach, Virginia, and Nashville, Tennessee. He holds a bachelor's degree from the University of Tennessee at Chattanooga in computer science with a minor in mathematics. For more information, visit drsql.org.

Register now for 24 Hours of PASS! 



Check out the speaker lineup!


 

 

Copyright 2013 by PASS | Terms Of Use | Privacy Statement | Login