Ben Johnston in Blogs

SQL Server Regular Expression Performance and Guidelines

SQL Server 2025 introduces regular expression (regex) functions to the TSQL language. You could do this in previous versions with...

Edward Pollack in Featured

SQL Server 2025 PRODUCT() Function: Multiply Values in T-SQL

Learn the new PRODUCT() aggregate function in SQL Server 2025 - multiply values across rows like SUM() adds them. Covers...

Edward Pollack in Featured

Everything you need to know about Regular Expressions (Regex) in SQL Server 2025 - learn what it is, how to...

Edward Pollack in SQL Server

Learn about the improvements to columnstore indexes in SQL Server 2025, including detailed demonstrations for each of these new changes.…

Aaron Bertrand in Database Administration

SQL Server 2025 adds Zstandard (ZSTD) backup compression with LOW, MEDIUM, and HIGH levels. Compare ZSTD vs MS_XPRESS performance, syntax,...

Edward Pollack in Database Administration

This article was updated in September 2025 following the SQL Server 2025 (17.x) Preview release. TempDB is a system database...

Edward Pollack in SQL Server

SQL Server Developer Edition has for years provided a free data platform to test and develop applications in an environment...

Rodrigo Ribeiro Gomes in T-SQL Programming

Understand embeddings and vector search in SQL Server 2025. Learn how to convert text to numerical vectors, calculate similarity with...