Tame Your Unruly Data...With Constraints!

Never given time or care, never forming good relationships, becoming bloated, corrupt and rife with indistinguishable copies, and all so horrifyingly pervasive in society. But enough about the Kardashians, what about YOUR DATA? If you want to straighten it out and prevent it from going too far in the first place, this session is for you. We will cover constraint basics (not null, check, primary key/unique, foreign keys), provide standard use cases, and address misconceptions about constraint use and performance. We will also look at triggers and application logic and why these are NOT substitutes for (but can effectively complement) good constraint usage. Attendees will enjoy learning how to keep THEIR data off the tabloid page!
Presented by Rob Volk at SQLBits XI
  • Downloads
    Slide deck available Slide Deck 1.5 MB
  • SpeakerBIO
    rob_volk.gif
    Rob Volk is a database administrator in the Atlanta, Georgia area since 2001, having worked in the wireless telecom, utility billing, and credit card processing industries.  He started using SQL Server with version 6.5 and is very glad to have upgraded since then. He has presented at several SQL Saturdays and user groups in the US, and looks forward to his American jokes falling flat with the UK audience, which may prompt a poor imitation of The Parrot Sketch. In his spare time he accomplishes more than he does on the job, just don't tell his boss.
    http://weblogs.sqlteam.com/robv
  • Video
    The video is not available to view online.