Checking for Primary Keys

There are many reasons for almost every table to have a primary key.  This articles UDF locates any user tables that don’t have primary keys. Here’s the CREATE FUNCTION script: SET QUOTED_IDENTIFIER ON GO SET ANSI_NULLS ON GO CREATE FUNCTION...

Alternative Rot13 Implementation.

This article was about ufn_Rot13 a letter exchange cipher contributed by Luke Schollmeyer. The Rot13 cipher is often used for very basic hiding of text. The Windows Registry uses it and it’s also used in many web cookies. ufn_Rot13 uses a loop to compute each...

Obscure Data with the Rot13 Cipher.

How protected is the data in your database? For most databases, the answer is: “Not very”. Have you ever thought of encrypting your database? Make no mistake about it your database is vulnerable to prying eyes.  SQL Server now has several options that...