Azure SQL and Fabric Add New AI Database Features

Introduction

Microsoft used SQLCon 2026 to highlight how its database platform is evolving for AI, modernization, and unified management across hybrid and cloud environments. For IT teams, the announcement matters because it combines migration tooling, cost optimization, stronger governance, and AI-ready database features across Azure SQL and Microsoft Fabric.

What’s new

GitHub Copilot in SSMS 22 is now generally available

Microsoft announced general availability of GitHub Copilot in SQL Server Management Studio 22. Database administrators and developers can now use chat and code assistance directly in SSMS to write, edit, refactor, and troubleshoot T-SQL with less manual effort.

New savings plan for databases

A new Azure savings plan for databases offers a spend-based pricing model with up to 35% savings versus pay-as-you-go pricing on a one-year commitment. The plan automatically applies savings to eligible database usage each hour, helping organizations reduce costs during migration and modernization projects.

Azure SQL Database Hyperscale adds AI-focused enhancements

Azure SQL Database Hyperscale gains several new capabilities in public preview, including:

• SQL MCP Server for securely connecting SQL data to AI agents and copilots
• Larger 160 and 192 vCore options for demanding workloads
• Faster vector indexing with real-time insert, update, and delete support
• Performance improvements through quantization, iterative filtering, and optimizer integration

These updates are designed to support large-scale transactional, analytical, and AI-driven applications without rearchitecting existing SQL workloads.

SQL database in Fabric gets stronger security and migration support

Microsoft announced general availability for key enterprise features in SQL database in Fabric, including:

• SQL Auditing
• Customer-Managed Keys
• Dynamic Data Masking

Workspace-level Private Link is also now in preview. In addition, the Migration Assistant now supports SQL database in Fabric as a migration target with Copilot-assisted readiness checks, schema migration, and data copy workflows.

Database Hub enters early access

Microsoft also introduced Database Hub in Fabric in early access. The new experience provides a unified view across Azure SQL, Azure Cosmos DB, Azure Database for PostgreSQL, Azure Database for MySQL, and Azure Arc-enabled SQL Server, giving teams a central place to observe, govern, and optimize their database estate.

Impact for IT administrators

For administrators, these updates reduce friction across three areas: migration, governance, and operations. AI assistance in SSMS and migration tools can speed up modernization projects, while new Fabric security controls improve production readiness. Database Hub could also simplify multi-database oversight for teams managing distributed estates.

Next steps

IT teams should evaluate GitHub Copilot in SSMS 22, review whether the savings plan aligns with current Azure database usage, and test Fabric migration scenarios. Organizations standardizing on Microsoft data services should also watch Database Hub early access and Fabric Private Link preview for future operational planning.