// tag
#Azure-Sql
11 posts
Microsoft SQL Midyear 2026: The Quiet Shift from Database Engine to AI Data Platform
The 2026 SQL update wave shows a strategic transition: SQL is no longer just a persistence layer, it is becoming the governed execution backbone for agentic applications.
Data API Builder Custom Paths Let You Design APIs for Humans, Not Tables
Compound REST paths in DAB are a small feature with big architectural impact for domain-oriented API design.
Stop Treating Databases as Special Snowflakes: Azure DevOps + SQL Projects Done Right
The SQL projects pipeline model in Azure DevOps proves database delivery can be repeatable, secure, and testable when teams adopt code-first CI/CD discipline.
MAESTRO, Defense-in-Depth, and Why SQL Server Is Now a Security Boundary for AI
Agentic AI introduces threats traditional STRIDE models weren't designed for. Here's how Microsoft SQL maps to the MAESTRO framework to provide a governed execution boundary.
NL2SQL Is the SQL Injection of the Agentic Age
Before you let an agent query your database with natural language, read this. NL2SQL looks simple until you think through schema completeness, indeterminism, and what SQL MCP Server actually solves.
Azure SQL Can Generate Embeddings Now — In Pure T-SQL, No App Layer Needed
AI_GENERATE_EMBEDDINGS and CREATE EXTERNAL MODEL are now GA in Azure SQL Database and Managed Instance. RAG pipelines built entirely in T-SQL, no data movement required.
The MSSQL Extension for VS Code Is Quietly Becoming a Much Bigger Platform
The latest MSSQL extension update adds Azure SQL provisioning, Copilot-assisted schema design, Data API builder, and notebooks. The interesting part is how much database work can now stay inside VS Code.
Azure Data Studio Is Retired: Move Your Azure SQL Workflow to VS Code
Azure Data Studio retired February 6 2025, with support ending February 28 2026. Here is the complete migration path to VS Code with the MSSQL extension.
SQL MCP Server on Azure App Service — No Containers Required
The SQL MCP Server can now run on Azure App Service without Docker or Kubernetes. Here's what that means for .NET developers building AI agents that talk to SQL databases.
SQL Server 2025 as Your Agent-Ready Database: Security, Backup, and MCP in One Engine
The final part of the Polyglot Tax series tackles the hard production problems: unified Row-Level Security across relational, JSON, graph, and vector data — plus cryptographic audit trails and MCP integration that make SQL Server 2025 genuinely agent-ready.
SQL MCP Server — The Right Way to Give AI Agents Database Access
SQL MCP Server from Data API builder gives AI agents secure, deterministic database access without exposing schemas or relying on NL2SQL. RBAC, caching, multi-database support — all built in.