5 T-SQL features that should already exist (2026 SQL Server wish list)

2026 T-SQL wish list covering native Parquet imports, arrays, OVERLAPS, simpler licensing, and cloud storage

CROSS APPLY Fundamentals: Part 1

Learn the basics of the CROSS APPLY operator with a few examples in this short piece.

BIT_COUNT() III

TRY_PARSE vs TRY_CONVERT in SQL Server: From Basics to Practical Usage

This article shows how the TRY_PARSE() and TRY_CONVERT() functions can be used to handle data quality issues and ensure that your software continues to function without throwing errors.

Getting the Average

SQL Server Enum Implementation: A Single-Row View Strategy for Avoiding Magic Values

Learn about an alternative strategy for avoiding hardcoded literal values in SQL Server queries by using single-row views designed to mimic enum behavior.

BIT_COUNT I

Multiple Values Inserted

Detecting Characters

Displaying Money