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.
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.
Optimized Plan Forcing: Cutting Compile Time in SQL Server 2022
Check optimized plan forcing in SQL Server 2022 through scoped configuration and Query Store replay flags, then compare compile duration.