SQL Server Data Validation Examples: Row Counts, Duplicates, and Foreign Key Orphans

YouTube Excerpt: This video walks you through 7 sample data validation test cases. These table-level tests cover four flavors of row count, and three different unique and foreign key checks. You can refactor and use in your projects. The scripts in the demo are all out on Github along with 66 total sample validation tests along with a basic and an advanced script for automating the tests. ------- Chapter Timestamps (click to jump forward): ----------------------------- 0:00 - Intro 0:12 - Introducing Rule Set #1 - Row Counts 3:39 - Introducing Rule Set #2 - Foreign & Unique Keys 7:16 - How to Download SQL Scripts in this Video 8:49 - The End Downloads: - Rule Set #1: https://raw.githubusercontent.com/DataResearchLabs/sql_scripts/main/mssql/data_validation/rule_set_01__row_counts.md - Rule Set #2: https://raw.githubusercontent.com/DataResearchLabs/sql_scripts/main/mssql/data_validation/rule_set_02__keys.md - Multi-Platform Data Validation Scripts: https://github.com/DataResearchLabs/sql_scripts/blob/main/data_validation_scripts.md Watch related playlist videos: - https://www.youtube.com/playlist?list=PLVHoUDdbskUSlZTVZmllGTdSuvyI4LBiE Connect with me on social media: - LinkedIn: https://www.linkedin.com/in/mpiercead576/ - YouTube: https://www.youtube.com/channel/UCQciXv3xaBykeUFc04GxSXA - GitHub: https://github.com/DataResearchLabs Subscribe to my YouTube Channel: - https://www.youtube.com/channel/UCQciXv3xaBykeUFc04GxSXA?sub_confirmation=1 #MSSQL #automation #datavalidation

This video walks you through 7 sample data validation test cases. These table-level tests cover four flavors of row count, and three different...

Read Full Article 🔍

Curious about SQL Server Data Validation Examples: Row Counts, Duplicates, And Foreign Key Orphans's Color? Explore detailed estimates, salary breakdowns, and financial insights that reveal the true scope of their profile.

Source ID: M6SkiWLVo8I

Category: color style guide