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:45
Chicks in the Office
7 hours agoHolly Madison Talks Reconciliation with Kendra Wilkinson
40.7K30 -
LIVE
Di bear
9 hours agoFinal Season Mission, Pantheon | Destiny 2
527 watching -
6:54:43
SquallRush
11 hours agoAthenian Rhapsody!
41.8K7 -
1:47:01
Real Coffee With Scott Adams
9 hours agoEpisode 2492 CWSA 06/01/24
54.8K51 -
2:08:10
LFA TV
10 hours agoEP 47: Miles Guo Trial Special with Special Guests - Truth, Betrayal, and Fox Hunt | WHISTLE BLOWERS 6.01.24 12pm EST
48.3K14 -
1:13:59
Tactical Advisor
8 hours agoVault Room Tour/Unboxing- Vault Room Live Stream
49.1K3 -
1:11:28
The Squad
14 hours agoArsenal's Huge Summer🚨Olise to Man Utd DEAL✅ Osimhen to Arsenal or Chelsea☑️ UCL Final Preview
60.4K10 -
56:23
Trumpet Daily
1 day ago $1.10 earnedCohen Is Free to Lie and Steal, but Trump Is Guilty of Something - Trumpet Daily | May 31, 2024
45.5K58 -
8:26
MichaelBisping
1 day agoBISPING CHOKES OUT STEVE-O! | JACKASS STAR PUT TO SLEEP BY UFC CHAMP! *FULL VIDEO*
62.7K13 -
20:00
Clownfish TV
1 day agoGoogle Hurt ITSELF in Its Confusion!
66.2K67