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)
Find table column datatypes for a database.
2023-02-22 (first published: 2023-02-14)
A quick script that removes leading zeros in a numeric stored as a string.
2022-12-30 (first published: 2022-12-26)
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)
Simplified latitude / longitude in 10 fixed bytes.
2022-10-26 (first published: 2022-10-21)
Use DBCC CLONEDATABASE to make a Schema Only Database Backup
2022-09-02 (first published: 2022-08-23)
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)
A stored procedure to search database objects (triggers, scalar functions, table valued functions, views and stored procedures) for a user defined string.
2022-04-04 (first published: 2022-03-28)
This script will create the necessary login and linked servers on a given availability replica. Please ensure that the script is executed on all the replicas.
2022-02-22 (first published: 2022-01-25)
Script database and object level permissions for all database users
2022-01-12 (first published: 2021-06-11)