T-SQL in SQL Server 2025: REGEXP_LIKE

This article goes into one of the new regular expression functions in SQL Server 2025: REGEXP_LIKE().

Advanced T-SQL: Replacing Slow Cursors with Window Functions

This article looks at replacing a cursor with a window function to improve performance.

BIT_COUNT() IV

Time Series Data Mining Example with T-SQL when Adding New Data

Please demonstrate the steps for updating an existing time series dataset used in a prior data mining project with a fresh batch of data. Then, repeat the mining performed for the original dataset with the freshly updated dataset.

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.