Session Details

Where are my (primary) keys?  

Level :
Date :
10:45 AM Sunday
Room :
Track :
SQL Server Developers and...
Interested : (-) - Registered : (-)
Tag(s) :


In this session, we revisit some of the fundamental design principals of relational databases—normalization rules, key selection, and the controversies associated with these issues—from a very hands-on, practical perspective. We also consider the benefits and challenges of using different types of keys (natural, surrogates, artificial, others) from multiple aspects, including data consistency, application development, maintenance, portability, and performance.

The Speaker(s)


Ami Levin

Senior data tier architect, data modeler, database designer and SQL developer. Inventor of intelligent, autonomous performance optimization products. Designed, reviewed and optimized some of the world’s largest, most challenging, mission critical data environments. A seasoned speaker, instructor and mentor. Author of white papers and technical articles.
  • Not Interested
  • Interested
  • Attending