Assign granular server roles in SQL Server 2022, inspect membership, and give monitoring accounts the state access their queries need.
IS DISTINCT FROM in SQL Server 2022: NULL-Safe Comparisons
Use IS DISTINCT FROM for NULL-safe comparisons in SQL Server 2022, understand older workarounds, and inspect index seeks before changing code.
Bit Functions in SQL Server 2022: BIT_COUNT, GET_BIT and LEFT_SHIFT
Use BIT_COUNT and SQL Server 2022 bit functions to read, set, count, and shift flags, while choosing clear storage for ordinary settings.
GREATEST, LEAST and Other Small Helpers
GREATEST, LEAST, and recent T-SQL helpers replace bulky CASE patterns while preserving explicit rules for NULL and data types.
Date Boundaries With DATETRUNC and EOMONTH in SQL Server 2022
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.
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.