Use DATETRUNC and EOMONTH for month, quarter, and week boundaries in SQL Server 2022, including index-friendly half-open filters.
Three-Valued Logic: TRUE, FALSE and UNKNOWN in a WHERE Clause
Understand three-valued logic in WHERE and CHECK, avoid NULL-poisoned NOT IN, and use SQL Server 2022 null-safe comparisons.
UNMASK on One Column: Granting Unmasking in SQL Server 2022
Support needs phone numbers but not salaries. Here is how to unmask one column, and what that permission does not do.
TRIM Function in SQL Server: SQL in Sixty Seconds #040
The TRIM function removes spaces from the ends of a string, and SQL Server has had it since 2017. The tests here show which characters TRIM leaves behind, the LEADING and TRAILING keywords, and a WHERE clause that read 884 pages against 3.
Removing Repeated Characters From a String With GENERATE_SERIES
Remove repeated characters with GENERATE_SERIES, ROW_NUMBER, and ordered STRING_AGG, then benchmark a SQL Server 2019 fallback.
The WINDOW Clause: Name a Window Once and Reuse It
Use the WINDOW clause to reuse partition and order rules, extend named windows with frames, and keep SQL Server calculations consistent.
JSON_PATH_EXISTS and Typed ISJSON in SQL Server 2022
Validate payloads with JSON_PATH_EXISTS and typed ISJSON in SQL Server 2022, distinguish null from missing, and enforce a clear contract.