OCT 2022 - Tame Your Unruly Data With Constraints by Rob Volk (@sql_r)
Abstract
Bad 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 the 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 Bio
Rob Volk is a SQL Server DBA in the Metro Atlanta area since 2001. He also moderates and answers the forums on SQLTeam.com. While a cranky old-time DBA, he no longer considers "business intelligence" an oxymoron or "the cloud" as merely atmospheric moisture, and loves to do things in new and unusual ways.
Slide deck and code
TBD
-
11:46
TechWithMartin
1 year ago $0.01 earnedAdding a Default Constraint-Master SQL for Beginners(Part 4)
71 -
1:04:10
Data.SQL.Saturday.LA
3 years ago2020 @SQLSatLA presents: Query Tuning for Data Manipulation by Jeff Iannucci | @SentryOne Room
2 -
17:05
itmadesimple
11 months agoMaster SQL Aggregate Functions: Beginner's Guide
14 -
11:47
Pharos Technology
11 months ago $0.01 earnedSubqueries: Streamlining Your Database Processes
9 -
11:02
Pharos Technology
11 months agoUnderstanding SQL Fundamentals in Microsoft Access
4 -
18:07
Grover Park George On Access
1 year agoMy Hybrid Shopping List -- "Interim" Collections and Persisted Tables- Revised
1 -
15:43
VMblog
1 year agoVMblog 2022 Mega Series, Komprise Offers Expertise on the Topic of Unstructured Data Management
46 -
6:08
Grover Park George On Access
8 months agoLeverage SQL Server Views in PowerApps
16 -
20:09
Oracle y el lenguale PL/SQL
5 months ago $0.01 earnedOracle y el lenguaje PL/SQL parte 32. PL/SQL 10- Transacciones autónomas
9 -
16:35
TechWithMartin
1 year ago $0.01 earnedMaster SQL for Beginners-How to Create Tables (Part 3)
51