• Interests: Pianos, technology, family, camping, databases

Proper Luhn AddCheckDigit for any length #

Most of the luhn scripts assume that you are working with credit-cards and then IMPROPERLY calculate their luhn check-digit by starting at the left side (assuming that the core number is always 15 digits).  However, if you don't know the length of your core number, then such an approach will fail when the length is […]

5 (1)


210 reads


Welcome to 3Cloud …


A little over a month ago, Pragmatic Works Consulting was a part of a...

Daily Coping 23 Oct 2020


I started to add a daily coping tip to the SQLServerCentral newsletter and to...

One Thousand SQL Saturdays (*ish)


This weekend is SQL Saturday #1000, running virtually from Oregon. It’s a good schedule,...

Read the latest Blogs


Replication reinitialize error

By kcsujith

I am getting an error 'Cannot reinitialize subscriptions of non-immediate_sync publications; Microsoft SQL server...

Migrate or upgrade SSIS to another sever

By sqlfriend

What is the best way to move all SSIS  projects  in SSIS catalog to...

target database participating in availability group error

By noobdba

Sharepoint connects to the database using the cluster through an alias defined in cliconfig....

Visit the forum


SQL Server Q&A from the SQLServerCentral community

Get answers