{"id":106792,"date":"2025-05-20T09:37:00","date_gmt":"2025-05-20T09:37:00","guid":{"rendered":"https:\/\/www.red-gate.com\/simple-talk\/?post_type=collection&p=106792"},"modified":"2026-04-08T10:16:45","modified_gmt":"2026-04-08T10:16:45","slug":"sql-server-2025-articles-guides","status":"publish","type":"collection","link":"https:\/\/www.red-gate.com\/simple-talk\/collections\/sql-server-2025-articles-guides\/","title":{"rendered":"SQL Server 2025 articles & guides"},"content":{"rendered":"\n
\n
\n
\n
\n
\n \n\t\"\"\t<\/a> <\/div>\n
\n \n
\n \n \n \"Greg\n Greg Low<\/span>\n <\/a>\n\n \n in<\/span>\n \n SQL Server <\/a>\n <\/span>\n<\/div>\n\n
\n

\n Can SQL Server 2025’s REGEXP_SPLIT_TO_TABLE fix STRING_SPLIT in T-SQL?\u00a0 <\/h1>\n

\n Learn how to split strings efficiently in T-SQL using STRING_SPLIT and the REGEXP_SPLIT_TO_TABLE function in SQL Server 2025. Discover limitations,… <\/p>\n <\/div>\n

\n
\n
\n
\n \n\t\"\"\t<\/a> <\/div>\n
\n \n
\n \n \n \"Rodrigo\n Rodrigo Ribeiro Gomes<\/span>\n <\/a>\n\n \n in<\/span>\n \n SQL Server <\/a>\n <\/span>\n<\/div>\n\n
\n

\n SQL Server 2025 CREATE EXTERNAL MODEL and AI_GENERATE_EMBEDDINGS Commands Explained <\/h1>\n

\n Learn about the new CREATE EXTERNAL MODEL and AI_GENERATE_EMBEDDINGS commands in SQL Server 2025.… <\/p>\n <\/div>\n

\n
\n
\n
\n \n\t\"SQL\t<\/a> <\/div>\n
\n \n
\n \n \n \"Edward\n Edward Pollack<\/span>\n <\/a>\n\n \n in<\/span>\n \n Featured <\/a>\n <\/span>\n<\/div>\n\n
\n

\n SQL Server 2025 PRODUCT() Function: Multiply Values in T-SQL <\/h1>\n

\n Learn the new PRODUCT() aggregate function in SQL Server 2025 – multiply values across rows like SUM() adds them. Covers… <\/p>\n <\/div>\n

\n
\n
\n
\n \n\t\"An\t<\/a> <\/div>\n
\n \n
\n \n \n \"Edward\n Edward Pollack<\/span>\n <\/a>\n\n \n in<\/span>\n \n Featured <\/a>\n <\/span>\n<\/div>\n\n
\n

\n Regex in SQL Server 2025: All Seven REGEXP Functions Explained <\/h1>\n

\n 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…. <\/p>\n <\/div>\n

\n
\n
\n
\n \n\t\"A\t<\/a> <\/div>\n
\n \n
\n \n \n \"Edward\n Edward Pollack<\/span>\n <\/a>\n\n \n in<\/span>\n \n SQL Server <\/a>\n <\/span>\n<\/div>\n\n
\n

\n Columnstore Index Improvements in SQL Server 2025\u00a0 <\/h1>\n

\n Learn about the improvements to columnstore indexes in SQL Server 2025, including detailed demonstrations for each of these new changes.… <\/p>\n <\/div>\n

\n
\n
\n
\n \n\t\"\"\t<\/a> <\/div>\n
\n \n
\n \n \n \"Aaron\n Aaron Bertrand<\/span>\n <\/a>\n\n \n in<\/span>\n \n SQL Server <\/a>\n <\/span>\n<\/div>\n\n
\n

\n SQL Server 2025 ZSTD Backup Compression Guide <\/h1>\n

\n SQL Server 2025 adds Zstandard (ZSTD) backup compression with LOW, MEDIUM, and HIGH levels. Compare ZSTD vs MS_XPRESS performance, syntax,… <\/p>\n <\/div>\n

\n
\n
\n
\n \n\t\"\"\t<\/a> <\/div>\n
\n \n
\n \n \n \"Edward\n Edward Pollack<\/span>\n <\/a>\n\n \n in<\/span>\n \n SQL Server <\/a>\n <\/span>\n<\/div>\n\n
\n

\n TempDB Resource Governor Space Controls in SQL Server 2025: A Complete Guide <\/h1>\n

\n SQL Server 2025 introduces the ability to use Resource Governor to help manage TempDB resources automatically. This article dives into… <\/p>\n <\/div>\n

\n
\n
\n
\n \n\t\"\"\t<\/a> <\/div>\n
\n \n
\n \n \n \"Edward\n Edward Pollack<\/span>\n <\/a>\n\n \n in<\/span>\n \n SQL Server <\/a>\n <\/span>\n<\/div>\n\n
\n

\n SQL Server Developer Standard Edition: A Gift to Developers! <\/h1>\n

\n SQL Server Developer Edition has for years provided a free data platform to test and develop applications in an environment… <\/p>\n <\/div>\n

\n
\n
\n
\n \n\t\"\"\t<\/a> <\/div>\n
\n \n
\n \n \n \"Simple\n Simple Talk Editor<\/span>\n <\/a>\n\n \n in<\/span>\n \n SQL Server <\/a>\n <\/span>\n<\/div>\n\n
\n

\n SQL Server 2025 is in Public Preview! <\/h1>\n

\n On Monday, May 19, 2025, SQL Server 2025 was announced as finally going to be in public preview. Instead of… <\/p>\n <\/div>\n

\n
\n
\n
\n \n\t\"\"\t<\/a> <\/div>\n
\n \n
\n \n \n \"Dennes\n Dennes Torres<\/span>\n <\/a>\n\n \n in<\/span>\n \n T-SQL Programming <\/a>\n <\/span>\n<\/div>\n\n
\n

\n Azure SQL Native JSON Data Type: Query Techniques <\/h1>\n

\n Explore Azure SQL’s native JSON data type with CHECK constraints, JSON_ARRAYAGG, JSON_OBJECTAGG, and JSON_OBJECT functions. These features are coming to… <\/p>\n <\/div>\n

\n
\n
\n
\n \n\t\"\"\t<\/a> <\/div>\n
\n \n
\n \n \n \"Rodrigo\n Rodrigo Ribeiro Gomes<\/span>\n <\/a>\n\n \n in<\/span>\n \n T-SQL Programming <\/a>\n <\/span>\n<\/div>\n\n
\n

\n SQL Server 2025 Embeddings: AI Vector Search Explained <\/h1>\n

\n Understand embeddings and vector search in SQL Server 2025. Learn how to convert text to numerical vectors, calculate similarity with… <\/p>\n <\/div>\n

\n