Ensuring Each Client has a Full Set of Key-Value Pairs
In this piece, we find out about a business issue that can occur when using key value pairs in your database to describe information about other entities.
2018-07-10
600 reads
data integrity
Find and Remove Duplicate Records SQL Server
Learn a quick method to find and remove duplicate records in your SQL Server tables.
2016-02-01
9,752 reads
Why is data integrity important?
Why should I care and why should the database enforce it? This article from Jamin VanderBerg gives some reasons why the database is the place to enforce rules that ensure integrity.
2010-08-30
3,991 reads
Blogs
A New Word: Foilsick
By Steve Jones
foilsick – adj. feeling ashamed after revealing a little too much of yourself to...
Accelerated Database Recovery for tempdb in SQL Server 2025
Accelerated database recovery was introduced in SQL Server 2019 and provides fast recovery, instantaneous...
Measuring What Matters: Operationalizing Data Trust for CDOs
By Chris Yates
Trust is the currency of the data economy. Without it, even the most advanced...
Forums
Create an HTML Report on the Status of SQL Server Agent Jobs
Comments posted to this topic are about the item Create an HTML Report on...
count the number of NULLs in a row
Hi everyone I have a SP that finds the average based on 3 tables. ...
Deleting data in large table
I have a large table with 17M+ rows for our package record audits. I've...