This session is designed to introduce you or to re-engage your interest in all the options we have for setting constraints in a database. From datatypes to nulls to checks, defaults, foreign keys, and triggers we have a LOT of options, so it's important to know the options and also have a bit of a professional philosophy on when to use each of them - we will do a brief look at each of them. We'll talk about why getting them right on day 1 is so important, how to add them to existing tables (the syntax is the least interesting part!), and some patterns and anti-patterns you can look for when you get to the office on Monday. Constraints aren't glamorous, but they matter, and they require an advocate - you! A good session for DBA's, developers, and yes, even managers.