Loading Events

« All Events

  • This event has passed.

The Key to Keys: NTSSUG 17 March

17 March 2016 @ 6:00 PM - 8:30 PM CDT


Level: Intermediate

So many of us have learned database design approaches from working with one database or data technology. We may have used only one data modeling or development tool. That means our vocabularies around identifiers and keys tend to be product specific. Do you know the difference between a unique index and a unique key? What about the difference between RI, FK and AK? These concepts span data activities and it’s important that your team understand each other and where they, their tools and approaches need to support these features. We’ll look at the generic and proprietary terms for these concepts, as well as where they fit in the database design process. We’ll also look at implementation options in SQL Server and other DBMSs.

I’ll be speaking about keys: primary keys, surrogate keys, clustered keys, GUIDs, SEQUENCEs, alternate keys…well, there’s a lot to cover about such a simple topic.  The reason I put this presentation together is I see a lot of confusion about these topics. Some of it’s about terminology (“I can’t find anything about alternate keys in SQL Server…what the heck is that, anyway”), some of it is misunderstandings (“what do you mean IDENTITIES aren’t unique! of course they are…they are primary keys!”), some of it is just new (“Why the heck would anyone want to use a SEQUENCE?”).


17 March 2016
6:00 PM - 8:30 PM
Event Categories:
, , , ,
Event Tags:
, , , , ,


North Texas SQL Server User Group


Microsoft Building Irving
Microsoft Building LC-1, 7000 North Highway 161
Irving, TX United States
+ Google Map

Leave a comment