Articles tagged

13 April 2019
13 April 2019

Extract the Path from Filename in SQL

5
While I was preparing an article, I faced the challenge to extract the path from a filename in SQL Server. It’s an interesting challenge with many possible uses, so I decided to create a function to solve this problem. The Main Expression First, let’s understand the main expression to solve the problem. The path is everything … Read more
08 August 2018
08 August 2018

Spoofing Data Convincingly: Credit Cards

7
I haven’t seen a SQL Server table with real unencrypted credit card numbers for several years, and I don’t know of any good reasons to have them stored that way. However, I’ve needed them in the past for testing a web application that had to take credit card details. Generating credit cards in a way … Read more