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
583 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,448 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,904 reads
Blogs
Resources for Architecting Zero Downtime Deployments
By Steve Jones
I delivered my talk on Architecting Zero Downtime Deployments yesterday at VS Live Las...
Daily Coping 23 Mar 2023
By Steve Jones
Today’s coping tip is to focus your attention on the good things you take...
SQL Bits 2023 Recap
By DataOnWheels
I had an amazing time adventuring to Wales with other members of the data...
Forums
Grouping the first letter in a string
Hi All, I have the column of data in SQL Server. Here I need...
Converting To/From User Friendly Trigesimal Geocodes
Comments posted to this topic are about the item Converting To/From User Friendly Trigesimal...
AG listener error
Dear Support, could you please advise why error below prevents me from adding...
Ask SSC