Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
Log in  ::  Register  ::  Not logged in

The Smiling DBA

Thomas LeBlanc ( MCITP 2005/2008 & MCDBA 2000) is a Senior SQL Server DBA at Turner Industries, LLC in Baton Rouge, LA. He has been in the IT field for 21 years starting as a COBOL programmer, graduating to dBase, FoxPro, Visual FoxPro, upgrading to Visual Basic versions 3-6 and even some .Net(C#). Designing and developing normalized database has become his passion. Full-time DBA work started about 9 years ago for Thomas while working at a Paper Mill in St. Francisville, LA continuing with IEM, then Amedisys. Performance tuning and reviewing database design and code was an everyday occurrence for DBAs at Amedisys. Thomas’ free time is spent helping those less fortunate and improving his relationship with his family and God.

PASS Data Architecture presents Ami Levin: Where Are My (Primary) Keys?

I saw Ami Levin at the PASS Summit 2011 presenting on Loop Iterators in Execution Plans. It was on my top 3 sessions last year at the Summit. He has an excellent way of using visuals to explain things. The session for the PASS Data Architecture VC on Thursday (July 26th) is great session on Primary Keys and relational databases and the rules surrounding them. All Developers need to watch the presentation.

Here is an article written by Ami recently and review by Dr. SQL Louis Davidson. Excellent step by step on how to normalization a many-to-many relationship into the proper table structure using Data Modeling.

Subject: Where are My (Primary) Keys?

Start Time:  Thursday, July 26th, 2012 12:00 PM US Central Time

End Time:  Thursday, July 26th, 2012 1:00 PM US Central Time

Presenter:  Ami Levin

Live Meeting Link:  Attendees LiveMeeting

Where Are My (Primary) Keys?

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.
Session takeaways:
• Understand the profound impact of key selection on the entire application lifecycle
• Learn to identify when it is best to use natural or artificial keys • Learn how to minimize performance, portability, and maintenance issues during the early database design phase

Ami Levin

  Ami Levin  CTO, DBSophic
Ami Levin is a Microsoft SQL Server MVP since 2006, with over 20 years of experience in development and IT. For the past 14 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. He leads the Israeli SQL Server user 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.

Add to calendarAdd to calendar


Leave a comment on the original post [, opens in a new window]

Loading comments...