The CONCAT function and NULL values: CONCAT in SQL Server 2012 simply ignores NULL, while the + operator returns NULL. Here is a simple example.
SQL SERVER – Quiz on knowing DATEPART and DATENAME Behaviors
DATEPART and DATENAME accept a string that holds only a time and fill in the missing date as January 1, 1900. This post keeps the quiz, runs every query on SQL Server 2025 and explains which of the five bonus queries work and why.
SQL SERVER – Interesting Function AGENT_DATETIME
AGENT_DATETIME in msdb converts integer date and time values in YYYYMMDD and HHMMSS format into a datetime. Here is how it works, with examples.
SQL SERVER – Converting YYYYDDD Ordinal Date Codes Safely
This Julian date example uses an ordinal YYYYDDD code. I distinguish that business encoding from an astronomical Julian day number.
SQL SERVER – Quiz with DATEADD Function – SQL Puzzle
The DATEADD function returns the last day of the month when the day does not exist, so one month after January 31 is February 28. This post keeps the quiz, runs every query on SQL Server 2025 and explains the month rule and the Msg 517 overflow with the real results.
Finding Near-Duplicate Rows With REGEXP_REPLACE
Find near-duplicate rows with SQL Server 2025 normalization, group matching labels, rank survivors, and preserve originals for review.
SQL SERVER – Identify and Filter In-Memory Optimized Tables – SQL in Sixty Seconds #079
How to identify and filter In-Memory Optimized Tables in SQL Server Management Studio, shown in a quick SQL in Sixty Seconds video.