Azure SQL Dev Corner
Voices from the Azure SQL PM Team, focusing on development and developers
Latest posts
Audit Frontier AI Agents with SQL MCP Server
With On-Behalf-Of authentication, SQL MCP Server lets agents access Microsoft SQL without losing the user identity behind the request. Azure SQL can audit the signed-in user who invoked the operation, not just the agent, app, or MCP server that carried it out.
What’s new across Microsoft SQL in 2026 so far (SQL Server, Azure SQL, and SQL database in Fabric)
We’re halfway through 2026, and Microsoft SQL has not slowed down. Since SQLCon/FabCon in March (where we released a ton of things, and those updates can be found in this udpates video), we shipped a wave of updates across SQL Server, Azure SQL, and SQL database in Fabric, with Microsoft Build 2026 as the centerpiece. If you want the details on Build, start with my recap blog, The Era of the Agentic Database Developer. This post collects everything new from mid-March through today, organized by service so you can find what matters to you. Every item is tagged Preview or Generally Available with a link. You can...
Compose your API surface with Data API builder custom paths
Data API builder (DAB) 2.0 adds compound paths for REST endpoints, giving developers more control over how their API surface is organized. Instead of mirroring database topology, endpoints can now reflect simple names, business areas, or schema ownership.
MSSQL Extension for VS Code: Azure SQL Database Provisioning and More
The MSSQL extension for VS Code v1.43 expands what’s possible inside Visual Studio Code with the General Availability of Schema Designer with GitHub Copilot, Data API builder, and SQL Notebooks. We’re also introducing the Public Preview of Azure SQL Database provisioning, giving developers a guided way to create Azure SQL databases directly from VS Code. What's new in MSSQL extension for VS Code v1.43 Here's a summary of the key features in this release: Azure SQL database Provisioning (Preview) The MSSQL extension for Visual Studio Code now introduces Azure SQL Database provisioning i...
SQL + AI, hands-on: Join a free workshop near you
If you work with Microsoft SQL regularly, the AI conversation right now probably feels a little exhausting. Every week brings a new platform, a new pattern, a new opinion about how you’re “supposed” to build AI apps. Most of it assumes you’ll start over. You don’t have to. We’re running SQL AI App in a Day workshops with Microsoft partners around the world. They’re free, hands-on, and built for developers who want to add AI to the apps they already own, using the data they already trust. You can browse upcoming sessions and register. Build on Microsoft SQL, not around it The question that keeps coming...
Regex support for LOB types in T-SQL—available in Azure SQL & SQL Server 2025
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 with the Always-up-to-date update policy. It will reach Managed Instances on the SQL Server 2025 update policy as part of the CU5 rollout. You no longer need to split log files, HTML documents, or large JSON payloads into 8,000-byte chunks just to run a pattern match. 1. ...
Considering NL2SQL? Should your database really be the prompt? How can SQL MCP Server help?
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 reticence against all of it. The voice in your head that makes you seriously uneasy. Your reputation is at stake, yes, but to your enterprise, this might be existential. It has a name: NL2SQL. NL2SQL, or Natural Language to SQL, is where an AI agent turns a natural language ...
Microsoft SQL Security Across the MAESTRO Stack: Building Secure Agentic AI with Defense-in-Depth
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 also introduce an entirely new category of security challenges. Organizations are no longer asking only: “How do we build AI systems?” They are now asking: “How do we build AI systems securely, responsibly, and with governance built into every layer?” This ...
Generate Embeddings Function and External Model Object Support Are Now Generally Available in Azure SQL
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 data movement, no external orchestration, no application-layer pipeline required. EXTERNAL MODEL object defines where to get embeddings from and how to authenticate — registered once, reused everywhere. AI_GENERATE_EMBEDDINGS calls the external model to generate the ve...