&nbsp\;&nbsp\;&nbsp\;&nbsp\;&nbsp\;
&nbsp\;<
SPAN LANG="en-us">\nIn this session\, we revisit some of the fundamental design princip
als of relational databases—normalization rules\, key selection\, and th
e controversies associated with these issues—from a very hands-on\, prac
tical perspective. We also consider the benefits and challenges of using d
ifferent types of keys (natural\, surrogates\, artificial\, others) from m
ultiple aspects\, including data consistency\, application development\, m
aintenance\, portability\, and performance. \n\nSession takeaways
: \n• Understand the profound impact of key selection on the entire
application lifecycle \n• Learn to identify when it is best to use
natural or artificial keys

\n\n

• Learn how to minimize performance\, portability\, and main
tenance issues during the early database design phase

\
n\n

Ami Levin

\n\n

CTO\, DBSophic\n\n<
/SPAN>Ami Levin is a Microsoft SQL Server MVP since 2006\, w
ith over 20 years of experience in development and IT. For the past 14 yea
rs\, he has been consulting\, teaching\, writing\, and speaking about SQL
Server worldwide. Ami's areas of expertise are data modeling\, database de
sign\, T-SQL\, and performance tuning. He leads the Israeli SQL Server use
r group (ISUG)\, moderates the Hebrew MSDN SQL Server support forum\, and
is a regular speaker at Microsoft Tech-Ed Israel\, Dev Academy\, and other
SQL Server conferences. Ami speaks often at user group meetings in Israel
and Europe and writes articles about SQL Server.
B>