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)
980 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)
467 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)
5,970 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)
237 reads
2023-02-22 (first published: 2023-02-14)
650 reads
A quick script that removes leading zeros in a numeric stored as a string.
2022-12-30 (first published: 2022-12-26)
2,704 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)
503 reads
Simplified latitude / longitude in 10 fixed bytes.
2022-10-26 (first published: 2022-10-21)
639 reads
2022-09-02 (first published: 2022-08-23)
11,359 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)
1,019 reads
By Arun Sirpal
AgentDBA began as a command line. That suits one DBA on one server, but...
By Steve Jones
I have a few Azure subscriptions, which are fairly small and not used that...
This post shows you how to install containerd as the container runtime for Kubernetes...
Jl. Jenderal Sudirman No.14, Muara Dua, Kec. Prabumulih Tim., Kota Prabumulih, Sumatera Selatan 31121
Wa:083849450961 Jl. Jenderal Sudirman No.39, Krobokan, Kec. Semarang Barat, Kota Semarang, Jawa Tengah 50141
Wa:083849450961 Jl. Ahmad Yani No.39 A, Rw1, Sidokumpul, Kec. Sidoarjo, Kabupaten Sidoarjo, Jawa Timur...
With regard to SQL Server 2025's Vector support, what is an embedding?
See possible answers