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 – 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 – Script to Convert Date to Julian Dates
A Julian date is a seven digit number: the year, then the day of the year. Here is a simple DATEADD script to turn a Julian date into a datetime value.
SQL SERVER – Quiz with DATEADD Function – SQL Puzzle
A quick DATEADD Function quiz: guess what adding one month to a late January date returns before you run it in SSMS. Date math has a few pitfalls.
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.
SQL SERVER – Schema Change Reports – SQL in Sixty Seconds #078
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.