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

Converting Money

Understanding SQL Server PARTITION BY with Examples

Introduction When developers first learn SQL aggregation, they usually start with the GROUP BY clause. It works well for summary reports because it combines multiple rows into a single result for each group. For example, you can calculate total sales per region or average salary per department. The limitation of GROUP BY appears when you […]

Representing Money

Five SQL Server 2022 T-SQL Functions You Should Be Using Right Now

SQL Server 2022 brought powerful new T-SQL functions that eliminate long-standing workarounds. This article walks through five of the most impactful additions — GENERATE_SERIES, GREATEST/LEAST, DATE_BUCKET, the WINDOW clause, and IS NOT DISTINCT FROM — with practical code examples you can use immediately.