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
-
LIVE
WeAreChange
2 hours agoTrump To Subdue Deranged Opposition! ARRESTS Planned
2,907 watching -
1:19:04
JustPearlyThings
2 hours agoWhy MODERN WOMEN Keep REJECTING The Redpill! | Pearl Daily
38K17 -
39:01
The Why Files
8 days agoSymbols of Power: Deciphering the Language of the Secret Elite
64.3K52 -
45:17
The Officer Tatum
5 hours agoLIVE: Scott Jennings INCINERATES CNN, DNC Union BEGS For Money, + MORE | OT Show EP 15
55.6K42 -
Tundra Tactical
1 hour agoFirst Impression of the Labradar LX Chronograph.
55 -
LIVE
LFA TV
21 hours agoAnti-Trump Lawfare Has Failed | Trumpet Daily 11.26.24 7PM EST
381 watching -
29:44
Standpoint with Gabe Groisman
8 hours agoEP. 59. The State of Western Militaries Today. Col. Richard Kemp
25.6K -
47:24
Candace Show Podcast
3 hours agoConor McGregor: GUILTY—But Of What? | Candace Ep 111
68.5K168 -
13:19
Josh Pate's College Football Show
4 hours agoThe SEC has COLLAPSED!! Updated CFP Picture with Josh Pate
1.05K -
45:59
PMG
19 hours ago"Hannah Faulkner and Sabrina Cardone | Empowering the Next Generation"
7801