by Ian Bachman-Sanders | Nov 21, 2020 | SQL coding, SQL Performance
The previous two articles have been devoted to implementations of the Rot13 cipher. This is a character substitution cipher that is used to obscure text strings in the Window registry and in many web cookies. Both implementations were contributed by Luke Schollmeyer. ...
by Ian Bachman-Sanders | Nov 20, 2020 | SQL coding
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...
by Ian Bachman-Sanders | Nov 19, 2020 | SQL coding
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...
by Ian Bachman-Sanders | Nov 18, 2020 | SQL coding
Credit card numbers are among the most common numbers in commercial use today. Most credit card numbers and many other numbers used in financial services use the Luhn (a.k.a Mod 10) formula for check digits. It’s been formalized as part of the ANSI X4.13...
by Ian Bachman-Sanders | Nov 17, 2020 | SQL coding
The number of ways to receive information seems to increase all the time. One of the ways to get information from the web is an RSS feed. If you use a feed reader. This issue features a contribution from reader Nick Barclay from Australia. The function, InString, is...
by andrew novick | Nov 16, 2020 | SQL coding
It’s time to mail your holiday cards. Whether it’s Christmas, New Years, Chanukah, or something else, there are going to be billions of cards sent in the next few weeks. One of the tasks that my wife and I face each year is getting all the addresses...
