Showing archive results for May 2026

May 22, 2026
Post comments count0
Post likes count1

Regex support for LOB types in T-SQL—available in Azure SQL & SQL Server 2025

Abhiman Tiwari

At a glance — Native regular expression (regex) functions in T-SQL now accept and inputs of up to 2 MB across all seven regex functions, including the two table-valued functions ( and ). This capability ships in SQL Server 2025 CU5 and is already available in Azure SQL Database, SQL Database in Fabric and Azure SQL Managed Instance configured wit...

Azure SQLT-SQLSQL Server 2025
May 14, 2026
Post comments count0
Post likes count4

Considering NL2SQL? Should your database really be the prompt? How can SQL MCP Server help?

Jerry Nixon

You’ve probably experienced both of these, perhaps at the same time. First, that desire to let an agent get at your data. It’s driven by simplification and better experiences for the user and for you: fewer screens, fewer queries, fewer reports, and less code overall. Second, and perhaps more importantly, that unrelenting reluctance and reticenc...

SQL MCP ServerData API builder
May 13, 2026
Post comments count0
Post likes count2

Microsoft SQL Security Across the MAESTRO Stack: Building Secure Agentic AI with Defense-in-Depth

Arun Vijayraghavan

Artificial Intelligence is evolving rapidly. What began as simple prompt-and-response systems is now transforming into fully autonomous, agentic AI architectures capable of reasoning, orchestrating tools, interacting with enterprise data, and invoking external systems dynamically. While these capabilities unlock enormous business potential, they al...

AIAzure SQLT-SQL
May 8, 2026
Post comments count0
Post likes count5

Generate Embeddings Function and External Model Object Support Are Now Generally Available in Azure SQL

Aaron Saidi

We are excited to announce the General Availability (GA) of AI_GENERATE_EMBEDDINGS and CREATE EXTERNAL MODEL in Azure SQL Database and Azure SQL Managed Instance. These two T-SQL features — CREATE EXTERNAL MODEL and AI_GENERATE_EMBEDDINGS — work together as a single, integrated pipeline for generating vector embeddings directly from T-SQL. No da...

Azure SQL
May 4, 2026
Post comments count2
Post likes count2

SQL MCP Server as an App Service

Jerry,
Helen

Run SQL MCP Server on Azure App Service without containers. This walkthrough uses Data API builder to configure authentication, expose MCP, REST, and GraphQL endpoints, and deploy as code.

SQL MCP ServerAzure SQLData API builder