An audit finding relating to production data, containing customer identifiable data, in a UAT environment, prompted this simple script, which completely scrambles data in such a way that the original value can not be reconstituted.
2023-05-24 (first published: 2023-05-19)
650 reads
If you need to extract a substring or create a longer string by combining multiple strings, there are a few methods you can use. To extract a specific portion of a string, you can utilize a substring-extraction function.
2023-05-09 (first published: 2023-05-05)
240 reads
This Python 3 script is designed to take CSV file data pasted into the csv_data variable and generate SQL insert statements that can be used to insert the data into a MySQL database. The script is easy to use and can save you a lot of time when working with large amounts of data.
2023-05-08 (first published: 2023-05-05)
3,354 reads
The Problem As a data professional, I have often wished that there was a short, simple, and universal code to enable finding a place on earth. Addresses are nice but require a government authority to build a road, name it, and number its locations, and standardize its entry / use, and then they are far […]
2023-03-30 (first published: 2023-03-23)
155 reads
2023-02-22 (first published: 2023-02-14)
498 reads
A quick script that removes leading zeros in a numeric stored as a string.
2022-12-30 (first published: 2022-12-26)
1,948 reads
An alternative for Microsoft's STRING_SPLIT function that will work on SQL Server 2012 and higher.
2022-12-19 (first published: 2021-03-05)
328 reads
Simplified latitude / longitude in 10 fixed bytes.
2022-10-26 (first published: 2022-10-21)
517 reads
2022-09-02 (first published: 2022-08-23)
6,383 reads
The Excel (365) "LET" formula below will return a formatted SQL Values Table "T1" that can be pasted into SSMS.
2022-04-06 (first published: 2022-03-29)
910 reads
By Steve Jones
I leave tonight for Australia. I was in London 3 days ago, so this...
By Brian Kelley
As I look at the state of information technology today, I see one constant:...
I recently started full time learning of Amazon Web Services (AWS). I found that...
Maybe I'm just doing something really simple and dumb. I imported a bunch of...
Hi everyone I am not too experienced using C#. I need to convert date...
how can i insert records from a transaction table into a transaction table with...
How many table hints can I include in a query?
See possible answers