SQL Server & Data

Microsoft SQL 2026 PASS Summit West Roundup: Azure SQL and Fabric Updates

The PASS Summit West 2026 roundup details extensive updates across Microsoft SQL, Azure SQL, and Microsoft Fabric. Major announcements include general availability and preview features for Hyperscale, security enhancements, vector search, and management tools.

What changed From the source

Microsoft shared a comprehensive list of updates spanning SQL Server, Azure SQL, SQL database in Microsoft Fabric, and supporting tooling. In Azure SQL Database, 160 and 192 vCore Premium-series options for single Hyperscale databases and elastic pools reached general availability in September. The Azure portal SQL query editor added query cancellation, a resizable results grid, stored procedure definitions, and automatic query saving. Preview features for Hyperscale include serverless auto-pause and auto-resume, higher-density elastic pools supporting up to 50 databases and 128 TB per pool, migration from Arc-enabled SQL Server, and local time-zone support.

Security enhancements for Azure SQL Database include general availability for Microsoft Entra server principals in June and versionless keys for Transparent Data Encryption. Automatic backup immutability protects up to the last seven days of point-in-time restore backups by default, excluding Hyperscale. Previews include AES keys for Transparent Data Encryption stored in Azure Key Vault Managed HSM, regex-based dynamic data masking, BACPAC import and export using managed identity, soft-delete retention for logical servers, multiple secondary servers for failover groups, and change event streaming to Azure Event Hubs or Fabric Eventstream.

Versionless Microsoft SQL introduced generally available DiskANN vector indexes and vector search with asynchronous maintenance and iterative filtering, alongside embedding generation via AI_GENERATE_EMBEDDINGS and automatic index compaction. Regex support for large-object inputs accepting varchar(max) and nvarchar(max) up to 2 MB ships in SQL Server 2025 CU5 and is available in Azure SQL Database, SQL database in Fabric, and Managed Instance on the Always-up-to-date policy.

Azure SQL Managed Instance reached general availability for the SQL Server 2025 update policy in March, flexible memory for Business Critical in September, higher transaction log rates for Business Critical, automatic backup immutability, blocking T-SQL resource-management commands, and automatic internal connectivity testing. Managed Instance previews include zone redundancy for Next-gen General Purpose, flexible memory for zone-redundant General Purpose, Managed Instance links for multi-database availability groups, change event streaming, Query Store for readable secondary replicas, local time-zone support on the Always-up-to-date policy, and performance monitoring.

Microsoft Fabric introduced Database Hub in public preview. SQL database in Microsoft Fabric added general availability for the Migration Assistant for SQL database, DiskANN vector indexes and vector search, a Spark connector, database creation with supported collations, full-text indexing, auditing, SQL project definition APIs, and additional ALTER DATABASE SET options. Fabric previews include local time-zone support, CI/CD pre- and post-deployment scripts, maximum vCore limits, workspace-level Private Link, change event streaming, SQL database skills, and Fabric Apps.

For hybrid and migration scenarios, Azure SQL target sizing and pricing recommendations in SSMS reached general availability, while migration from Arc-enabled SQL Server to Azure SQL Database Hyperscale entered preview alongside Microsoft SQL migration agent skills.

At a glance · SQL Server & Data

What changedWhy it mattersWho should careUpgrade and migration considerations

Why it matters Analysis

The 2026 updates heavily emphasize expanding scalability, operational intelligence, and integration across cloud ecosystems. Bringing vector search directly into operational databases via DiskANN allows teams to build retrieval-augmented generation and semantic search features without managing a separate vector database synchronization pipeline. Furthermore, enhancements to Hyperscale sizing and serverless capabilities offer more cost-effective entry points and higher density for multi-tenant SaaS applications, while expanded Fabric and migration integrations streamline data estate management.

Who should care Analysis

Database administrators, cloud architects, and .NET developers working with Azure SQL, SQL Server, or Microsoft Fabric will find relevant improvements. Teams building AI-driven features over operational data, managing multi-tenant SaaS platforms on Hyperscale, or executing migration projects from on-premises Arc-enabled environments can directly benefit from these updates.

Upgrade and migration considerations Analysis

The source does not specify concrete step-by-step migration guides or mandatory upgrade blockers, but notes that Managed Instance users must adopt the Always-up-to-date policy to receive specific versionless updates. Teams evaluating upgrades should review update policy compatibility for Managed Instance backups, verify feature exclusions such as automatic backup immutability not applying to Hyperscale, and test preview integrations thoroughly before production deployment.

Sources and further reading

Original: “What’s new across Microsoft SQL in 2026 so far: the PASS Summit West roundup”, Azure SQL Dev Corner, published 11 Nov 2026, retrieved 12 Nov 2026. This article was drafted with AI assistance from the official source and passed automated fact and quality checks. Spotted a mistake? See our corrections policy.