Joseph Gama


Technical Article

Find a string in Procedures, Triggers, etc

I want to thank James Travis for his original and excellent work and to Razvan Socol for alerting about a similar problem that led me to improve James' code. The problem is that when searching for a word that is split between two 8kb blocks, James' code would ignore it. The solution is to look […]

You rated this post out of 5. Change rating

2004-02-21

156 reads

Technical Article

UDF Luhn's formula-credit card number validation

This UDF will validate a credit card number using Luhn's formula.For example 49927398716 will return 1:print dbo.luhn('49927398716')print dbo.luhn(49927398716)11based on:Credit cards, validation and the Luhn formulabyEduardo Chaveshttp://www.webdevelopersjournal.com/articles/validation.htmlAlgorithm converted to TSQL by Joseph Gama

You rated this post out of 5. Change rating

2002-12-12

528 reads

Blogs

A New Word: Immerensis

By

immerensis – n.  the maddening inability to understand the reasons why someone loves you...

Deploy a Dockerized Python TODO App to Azure Container Apps Using Pulumi and Azure Key Vault

By

In this post, I will guide you on how to deploy a dockerized simple...

Using a Local Large Language Model (LLM): Running Ollama on Your Laptop

By

You can now run powerful LLMs like Llama 3.1 directly on your laptop using...

Read the latest Blogs

Forums

mysql query timeout upped but job still fails about same number of minutes in

By stan

hi, i changed my mysql based linked server's timeout to N'600' instead of N'0'...

Somebody realized to configure Cluster-Aware updating on VMWare nodes

By boskabouter 007

Creating an Windows Server Fail-over Clusters with two SQL server 2022 and a File...

is it cache or something else

By stan

hi a few days ago i narrowed down the cause of a new problem...

Visit the forum

Question of the Day

SQL Server Collations

At what levels can we set the collation in SQL Server 2022?

See possible answers