OCT 2022 - Tame Your Unruly Data With Constraints by Rob Volk

The LA Data Platform (f.k.a. SQL Malibu) is the informal meeting of a group of Microsoft Data Professionals enthusiasts in the Greater Los Angeles area. This group is intended to facilitate knowledge and expertise sharing through community and expert SQL Server practitioners, in the full range of SQL Server topics, including Business Intelligence. Through these meetings we encourage professional networking.  The meetings areFREEof charge and held thethird (3rd) Wednesdayof every month, built based on the community for the community.Subscribeto LA Data Platform (a.k.a. SQL Malibu) Email Marketing Campaigns or use QR code below

LA Data Platform (f.k.a. SQL Malibu)

Tame Your Unruly Data With Constraints by Rob Volk

2022 LA Data Platform Monthly Meetings

AbstractBad data comes in many forms: duplicate rows, wrong data type, invalid values, and orphaned or missing foreign keys. Time is wasted cleansing, reviewing and correcting data, not to mention the potential hazards bad data can cause. This introductory presentation will explain the data types and constraints available in SQL Server, and how they can replace or augment business rules that would otherwise be written in application or procedure code. Performance benefits provided by constraints will be demonstrated. We will examine the various system views and procedures that describe constraints and how to use them to document your databases. You will be able to apply this knowledge to your database environments and see significant improvements in data quality, performance, and reliability.Speaker BioRob Volk is a SQL Server DBA in the Metro Atlanta area since 2001. He also moderates and answers the forums on SQLTeam.com. While an old-time cranky DBA, he no longer considers "business intelligence" an oxymoron or "the cloud" as merely atmospheric moisture, and loves to do things in new and and unusual ways.