SQL Server Constraints: Server or Client-Side Constraints?

This video is part of LearnItFirst’s Transact-SQL Programming: SQL Server 2008/R2 course. More information on this video and course is available here:

http://www.learnitfirst.com/Course161

This video is about validation: should data validation occur on the client, the server, or both? Here, trainer Scott Whigham takes you through an example scenario to demonstrate the pros and cons of each. Why not just test everything in the front end, and only pass it to the back end when you know it’s valid? Scott addresses this and provides a list of what to use client-side validation for, and what to use server-side validation for.

Highlights from this video:

– Some terms you should know
– What does it mean for data to be validated?
– What are business rules?
– Client-side validation
– Server-side validation
– Custom business rule enforcement

and much more…