Topic:
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!
Speaker:
Rob Volk is a SQL Server DBA in the Metro Atlanta area since 2001. An MCSE, he also moderates and answers the forums on SQLTeam.com. While a cranky old-time DBA, he no longer considers “business intelligence” an oxymoron or “the cloud” as merely atmospheric moisture, and is delightedly dipping his toes into both of these new oceans and loves to do things in new and and unusual ways.