Greg Low in SQL Server What is chunking, and how does it apply to vectors in SQL Server 2025? Learn what chunking is, why it matters for embeddings, and how SQL Server 2025 enables efficient AI-powered vector search.… 01 May 2026 7 min read 22
Ben Johnston in SQL Server 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... 02 January 2026 15 min read 111
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... 21 July 2025 9 min read 21
Edward Pollack in Featured Regex in SQL Server 2025: All Seven REGEXP Functions Explained SQL Server 2025 adds native regex support with seven new REGEXP functions: REGEXP_LIKE, REGEXP_COUNT, REGEXP_INSTR, REGEXP_REPLACE, REGEXP_SUBSTR, REGEXP_MATCHES, and REGEXP_SPLIT_TO_TABLE.... 14 July 2025 18 min read
Edward Pollack in SQL Server Columnstore Index Improvements in SQL Server 2025 Learn about the improvements to columnstore indexes in SQL Server 2025, including detailed demonstrations for each of these new changes.… 30 June 2025 11 min read 51
Aaron Bertrand in SQL Server SQL Server 2025 ZSTD Backup Compression Guide SQL Server 2025 adds Zstandard (ZSTD) backup compression with LOW, MEDIUM, and HIGH levels. Compare ZSTD vs MS_XPRESS performance, syntax,... 11 June 2025 15 min read 1
Edward Pollack in SQL Server TempDB Resource Governor Space Controls in SQL Server 2025: A Complete Guide SQL Server 2025 introduces the ability to use Resource Governor to help manage TempDB resources automatically. This article dives into... 09 June 2025 15 min read 21
Edward Pollack in SQL Server SQL Server Developer Standard Edition: A Gift to Developers! SQL Server Developer Edition has for years provided a free data platform to test and develop applications in an environment... 21 May 2025 9 min read 1
Rodrigo Ribeiro Gomes in T-SQL Programming SQL Server 2025 Embeddings: AI Vector Search Explained Understand embeddings and vector search in SQL Server 2025. Learn how to convert text to numerical vectors, calculate similarity with... 18 February 2025 48 min read 1252
