A friend building a captcha had to skip words that read the same backward. Here is a T-SQL script with REVERSE to check if a string is a Palindrome.
SQL SERVER – Beginning SQL 2012 – Basics of CONVERT FORMAT Function
Basics of the CONVERT FORMAT Function in SQL 2012: compare FORMAT with the older CONVERT tricks and grab just the part of a date you need for reports.
Generating Random Numbers Per Row: RAND, NEWID and CRYPT_GEN_RANDOM
Generate random numbers per row with NEWID or CRYPT_GEN_RANDOM, compare seeded RAND, inspect bucket spread, and pick a row without a sort.
SQL SERVER – Significance of Table Input Parameter to Stored Procedure
Pass a whole table into a stored procedure instead of forming and parsing XML. Here is why a table input parameter to stored procedure saves round trips.
JSON_ARRAYAGG and JSON_OBJECTAGG: Building JSON From Rows in SQL Server 2025
Build customer arrays with JSON_ARRAYAGG and settings objects with JSON_OBJECTAGG in SQL Server 2025, with explicit order and null rules.
SQL SERVER – TRIM Function to Remove Leading and Trailing Spaces of String – SQL in Sixty Seconds #040 – Video
SQL Server has no TRIM function, and calling it gives error Msg 195. This SQL in Sixty Seconds video shows how to remove leading and trailing spaces without it.
Finding Duplicate Customers With T-SQL
Find duplicate customers with T-SQL by normalizing names, reviewing fuzzy matches, and merging records only after ownership is settled.