In this Microsoft SQL Server 2025 series: Yesterday we looked into functions for working with vector data type and started also tinkering with VECTOR_SEARCH. With AI there are couple of T-SQL functionalities, that we will also cover. AI_GENERATE_EMBEDDINGS AI_GENERATE_EMBEDDINGS is…
Blog Archives
Advent of 2025, Day 13 – SQL Server 2025 – Vector functions
In this Microsoft SQL Server 2025 series: Yesterday we looked into Vector data type and how to create table, insert the vector and read it. With SQL Server 2025, vector data type comes equipped also with couple of functions: Let’s…
Tagged with: cosine distance, JSON, SQL Server, sql server 2025, T-SQL, vector, vector database, vector distance, vector search
Posted in SQL Server, Uncategorized
Posted in SQL Server, Uncategorized
Advent of 2025, Day 12 – SQL Server 2025 – New vector data type and Vector functions
In this Microsoft SQL Server 2025 series: The vector data type is designed to store vector data optimized for operations such as similarity search and machine learning applications. Vectors are stored in an optimized binary format but are exposed as…
Advent of 2025, Day 11 – SQL Server 2025 – External REST endpoint invocation using LLM
In this Microsoft SQL Server 2025 series: After short introduction into the sp_invoke_external_rest_endpoint we will look into creating a REST endpoint for using LLM. Deploy LLM model In your Azure tenant, go to Azure AI Foundry and deploy a model…
Tagged with: ai, API, API Calls, artificial-intelligence, LLM, SQL Server, sql server 2025, technology
Posted in Azure AI, Azure Machine Learning, SQL Server, Uncategorized
Posted in Azure AI, Azure Machine Learning, SQL Server, Uncategorized
Advent of 2025, Day 10 – SQL Server 2025 – External REST endpoint invocation
In this Microsoft SQL Server 2025 series: This new functionality, you can call to the system stored procedure sp_invoke_external_rest_endpoint, and call / get: – Call REST/GraphQL endpoints from other Azure services– Have data processed via an Azure Function– Update a Power…
Tagged with: ai, artificial-intelligence, Azure, cloud, endpoint invocation, external procedure, rest api, sp_invoke_extermal_rest_endpoint, SQL Server, sql server 2025, technology
Posted in Azure AI, Power BI, R, SQL Server, Uncategorized
Posted in Azure AI, Power BI, R, SQL Server, Uncategorized
Advent of 2025, Day 9 – SQL Server 2025 – New T-SQL functions – REGEXP_MATCHES() and REGEXP_SPLIT_TO_TABLE()
In this Microsoft SQL Server 2025 series: Last two functions in the family of new T-SQL functions that were shipped with RegEx, are REGEXP_MATCHES() and REGEXP_SPLIT_TO_TABLE(). REGEXP_MATCHES() Returns a table of captured substrings that match a regular expression pattern to…
Tagged with: advent 2025, regex, regular expressions, SQL, SQL Server, sql server 2025, T-SQL
Posted in SQL Server, Uncategorized
Posted in SQL Server, Uncategorized
Advent of 2025, Day 8 – SQL Server 2025 – New T-SQL functions – REGEXP_INSTR() and REGEXP_COUNT()
In this Microsoft SQL Server 2025 series: Continuing with SQL Server 2025 T-SQL functions for Regular Expressions for in string and count functionalities. REGEXP_INSTR() Returns the starting or ending position of the matched string (or substring). Starting or ending depends…
Tagged with: database, programming, regex, regular expressions, SQL, SQL Server, sql server 2025, T-SQL
Posted in SQL Server
Posted in SQL Server
Advent of 2025, Day 7 – SQL Server 2025 – New T-SQL functions – REGEXP_SUBSTR() and REGEXP_REPLACE()
In this Microsoft SQL Server 2025 series: Continuing with SQL Server 2025 T-SQL functions for Regular Expressions for replace and substring functionalities. REGEXP_SUBSTR() Returns one occurrence of a substring of a string that matches the regular expression pattern. If no…
Tagged with: database, Microsoft SQL Server, regex, regular expressions, SQL, SQL Server, sql server 2025, T-SQL, technology
Posted in SQL Server
Posted in SQL Server
Advent of 2025, Day 6 – SQL Server 2025 – New T-SQL functions – REGEXP_LIKE()
In this Microsoft SQL Server 2025 series: SQL Server 2025 introduces a new T-SQL functions for Regular Expressions (RegEx). With multiple RegEx functions, the LIKE function indicates if the regular expression pattern matches the string or is in a string.…
Tagged with: artificial-intelligence, regex, regular expressions, SQL, SQL Server, sql server 2025, T-SQL, technology
Posted in SQL Server
Posted in SQL Server
Advent of 2025, Day 5 – SQL Server 2025 – New T-SQL functions – BASE64_ENCODE() and BASE64_DECODE()
In this Microsoft SQL Server 2025 series: SQL Server 2025 introduces a new T-SQL functions for BASE64 varbinary expressions. The first function returns base64-encoded text (BASE64_ENCODE() ), respectively for BASE64_DECODE(). BASE64_ENCODE converts the value of a varbinary expression into a…
 | laresbernardo on LazyMouse – R package fo… |
| laresbernardo on LazyMouse – R package fo… |
| Randomly Moving the… on LazyMouse – R package fo… | |
| Advent of 2025, Day… on Advent of 2025, Day 23 – SQL S… | |
| Advent of 2025, Day… on Advent of 2025, Day 22 – SQL S… |
TomazTsql 