Session Details

Where are my (primary) keys?  

Level :
Intermediate
Date :
10:45 AM Sunday
Room :
PSEC4501
Track :
SQL Server Developers and...
Interested : (-) - Registered : (30)
Tag(s) :
ADD TO CALENDAR...

Presentation

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 Speakers

img

Ami Levin

Ami Levin is a Microsoft SQL Server MVP since 2006, with over 25 years of experience in development and IT. For the past 15 years, he has been consulting, teaching, writing, and speaking about SQL Server worldwide. Ami's areas of expertise are data modeling, database design, T-SQL, and performance tuning. Ami currently resides in California and works as a data tier architect for Tachyus.
  • Not Interested
  • Interested
  • Attending

SPONSORS List