Member of the LearnItFirst.com Video Training Network Related Video Training Sites: · SQL Server DBA Tutorials · Integration Services Training
   
Transact-SQL Programming and Query Writing Training Videos
Transact SQL Videos in Series Home  Subscriber Videos  

A Lecture on Using IDENTITY Columns in Table Design and Surrogate Keys (Video Series)

Video Image Video Category: Table Design - Datatypes, Constraints, IDENTITY Columns, Normalization, and More

Skill Level: 100 (Beginner)

Versions/Editions Covered: SQL Server 2005 , SQL Server 2000 , SQL Server 2008
So much is written and talked about IDENTITY columns that, for someone new to SQL Server and/or relational database design, it can get confusing to know whether or not to use a surrogate key, such as an IDENTITY column or a GUID. This series takes a hard look at IDENTITY columns and lets you decide after you see the good and bad of IDENTITY columns.

Videos in this Series:


Miscellaneous Bits & Pieces:
Security Tip: Protect your backups! Many DBAs often do not realize that anyone that can get to your SQL Server database backups can also restore those backups on their own SQL Server. One additional layer of file-based security that you can add in is to put a password on your backup file. This can only be done with Transact-SQL but it cannot be bypassed during the restore
Book You Should Probably Own: Christopher Date's "An Introduction to Database Systems"
Tips and Tricks: Create your own customized MMCs (Microsoft Management Console) for easier administration. Go to the command-line and run the command "MMC" to launch the MMC window. All that's left is for you to add in the various snap-ins you want to work with and then save the file

Other Websites We Offer
LearnSqlServer.com
Don't Forget!
Become a Guru
 
   
 
About Us Video Playback Subscriptions More Video Training More
 
© Copyright 2004-2008 LearnItFirst.com LLC. All rights reserved. All trademarks remain the property of their respective owners. This site is not affiliated in any way with the Microsoft Corporation. Refer a Friend and Get a Free Subscription!
 
1/8/2009 2:59:55 PM