A short 60 second video on Schema Change Reports, made after readers asked about it, plus links to my other posts on tracking schema changes.
SQL SERVER – List the Name of the Months Between Date Ranges – Correction
Sanjay Monpara caught a small error in my script to list the name of the months between two dates: it skipped the first month. Here is his corrected script.
SQL SERVER – Reverse String Word By Word Part 4
In Reverse String Word By Word Part 4, Paul G slices the string by a delimiter and rebuilds it in reverse order. Here is his full script.
SQL SERVER – Reverse String Word By Word Part 3
Reverse String Word By Word Part 3 shows Yuri Petrov’s way to reverse words in a sentence, using an auxiliary numbers table in two parts.
SQL SERVER – Reverse String Word By Word Part 2
In Reverse String Word By Word Part 2, Sanjay Monpara and Yuri Petrov improve my script. The new, more robust version uses a Split function.
SQL SERVER – Reverse String Word By Word
A reader wanted to reverse string word by word, so “I am Pinal Dave” becomes “Dave Pinal am I”. Here is the function that does it.
SQL SERVER – ISNUMERIC Puzzle and Unexpected Results – SQL in Sixty Seconds #076
This ISNUMERIC puzzle asks why one statement returns 0 and a look-alike returns 1. The answer is a tab character. This post tests it on SQL Server 2025, lists the 27 single-byte characters that ISNUMERIC accepts and shows safer checks before a cast.