Maintenance Plans might make some of us wince, but they can be easy to document.
[...Read More]
When a simple task isn't so simple, sometimes you have to get weird.
[...Read More]
Another option for splitting strings in TSQL. This one addresses a shortcoming of STRING_SPLIT.
[...Read More]
Get started with a few examples using the OPENJSON and JSON_VALUE functions.
[...Read More]
Moving a database to an older version of SQL Server is hard. Here's what worked for me.
[...Read More]
Shredding XML to get some meaningful output from sys.fn_xe_file_target_read_file is a pain in the ass. Let's fix that!
[...Read More]
Counting records in a CSV file is expensive, and sometimes slow. Can SQL Server help?
[...Read More]