Where did I put my keys?
In this session we will revisit some of the fundamental design principals of relational databases: normalization rules, key selection, and the controversies associated with these issues from a practical perspective.
We will consider the benefits and challenges of using different types of keys - natural, surrogates, artificial (and others?) from multiple aspects: data consistency, application development, maintenance, portability and performance.
Ami Levin is a Microsoft SQL Server MVP, with over 20 years of experience in the IT industry. For the past 14 years he has been consulting, teaching and speaking on SQL Server worldwide. He manages the Israeli SQL Server user group, moderates the local MSDN SQL Server support forum, and is a regular speaker at Microsoft conferences. Levin’s areas of expertise are data modeling, database design, T-SQL and performance tuning. He blogs and publishes regularly on sql-server-tuning.com.
The video is not available to view online.