Premium Only Content
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
-
2:39:28
Jewels Jones Live ®
2 days agoTRUMP’S TSUNAMI | A Political Rendezvous - Ep. 99
42.8K61 -
2:12:46
TheSaltyCracker
8 hours agoLefties Think Elon Stole Election ReeEEeE Stream 11-10-24
215K182 -
1:16:52
vivafrei
9 hours agoNEW STREAM! Sorry peeps
148K72 -
5:56:14
SNEAKO
8 hours agoCheesur edate, Jake Shields on election
110K2 -
39:34
Nerdrotic
10 hours ago $33.53 earnedAirbursts with Dr Malcolm LeCompte & Giants and Ancient Civilizations with Hugh Newman
113K12 -
1:03:38
vivafrei
17 hours agoElection RECAP! Long-Count Chicanery! FULL Jan. 6 Pardons! Let's Mock Lichtman & MORE! Viva Frei
165K158 -
LIVE
Vigilant News Network
11 hours agoDoctors Drop Post-Election COVID Bombshell | Media Blackout
3,957 watching -
14:13
Scammer Payback
12 days agoTelling Scammers Their Address
161K86 -
5:43:21
Barstool Gambling
15 hours agoBig Cat and Co Sweat Out the Week 10 Sunday Slate | Barstool Gambling Cave
121K3 -
2:49:36
The Jimmy Dore Show
2 days agoRumble Time Live w/ Jimmy Dore & Special Guests Roseanne Barr, Dr. Drew, Drea de Matteo & More!
583K698