Rodrigo Ribeiro Gomes in SQL Server SQL Server 2025 CREATE EXTERNAL MODEL and AI_GENERATE_EMBEDDINGS Commands Explained Learn about the new CREATE EXTERNAL MODEL and AI_GENERATE_EMBEDDINGS commands in SQL Server 2025.… 09 February 2026 29 min read 31
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 2
Edward Pollack in Featured Using Regular Expressions (Regex) in SQL Server 2025: A Complete Guide Everything you need to know about Regular Expressions (Regex) in SQL Server 2025 – learn what it is, how to… 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
Simple Talk Editor in SQL Server SQL Server 2025 is in Public Preview! On Monday, May 19, 2025, SQL Server 2025 was announced as finally going to be in public preview. Instead of… 21 May 2025 3 min read
Dennes Torres in T-SQL Programming Azure SQL Native JSON Data Type: Query Techniques Explore Azure SQL’s native JSON data type with CHECK constraints, JSON_ARRAYAGG, JSON_OBJECTAGG, and JSON_OBJECT functions. These features are coming to… 07 May 2025 16 min read 2
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
1
