© Louis Davidson 2021
L. DavidsonPro SQL Server Relational Database Design and Implementationhttps://doi.org/10.1007/978-1-4842-6497-3_8

8. Data Protection Patterns with Check Constraints and Triggers

Louis Davidson1  
(1)
Antioch, TN, USA
 

The world will not be destroyed by those who do evil, but by those who watch them without doing anything.

—Albert Einstein

One of the weirdest things I see in database implementations is that people spend tremendous amounts of time designing the correct database storage (or, at least, what seems like tremendous amounts of time to them designing something that is as good as they can) and then just leave the data unprotected with tables being more or less buckets that will accept anything, opting to let code outside ...

Get Pro SQL Server Relational Database Design and Implementation: Best Practices for Scalability and Performance now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.