DATEADD nanoseconds do not provide single-nanosecond storage. Test rounding thresholds with an explicit datetime2(7) input.
Oracle to SQL Server: Translating NVL, ROWNUM and Sequences
Translate Oracle to SQL Server expressions for NULLs, row limits, dates, sequences and concatenation, and test where they differ.
Central Management Servers and Registered Servers
Use Central Management Servers and registered servers in SSMS to organize SQL Server instances and run safe read-only queries across groups.
REGEXP_MATCHES: Read Matches and Capture Groups
REGEXP_MATCHES returns full matches and captured groups. Read group values and positions, preserve duplicate letters, and check a no-match input.
LIKE ESCAPE: Search for a Literal Percent Sign
LIKE ESCAPE expresses a literal punctuation search. Preserve the distinction between wildcard pattern instructions and stored text.
SQL SERVER – SQL Server Express – A Complete Reference Guide
A complete reference guide to SQL Server Express: what it costs (it is free), when to use it over the full version, and its maximum database size.
ISO Week Numbers vs DATEPART(week): Grouping Sales by Week
Group sales by ISO week and ISO year, compare DATEPART week behavior, and avoid New Year errors caused by session settings.