From Microsoft Ignite
I’m here in San Francisco enjoying specialty lattes, fall-ish weather (I guess?), and all the excitement around Microsoft announcements at Ignite 2026. It’s a cool energy to be surrounded by so many people at organizations that are trying to innovate with AI for the era of AI. These applications are the apps that run our world, and how they advance (or don’t) will change their trajectories at those companies as well as likely have real impact on our day-to-day lives.
At Microsoft Ignite, our Microsoft SQL announcements focus on making the innovation path simpler: modernize existing applications, start new ones locally, and use better tools to develop, secure, and operate the database as the application grows.
Here’s what’s new across Azure SQL, SQL database in Fabric, SQL Server, and the tools you use every day.
Azure SQL Database Hyperscale: start here, stay here
Azure SQL Database Hyperscale is our modernization (and innovation!) target of choice. It brings the SQL engine you know to a cloud architecture that separates compute and storage, giving applications room to grow without making database replatforming the next milestone. A few months ago, we announced support for scale to zero (serverless auto-pause preview) making this a great solution for all sizes and types of workloads, starting at 10GB (read: Hyperscale is not just for big databases!).
There is no extra database software to procure, acquire, purchase, or manage. You consume the managed Azure service rather than buying and operating a separate database software stack. I have to mention it is price-matched to AWS Aurora (based on a March 2026 list price comparison of provisioned per-core compute costs in US East regions for Azure SQL Database Hyperscale Standard Series Gen5 and AWS Aurora I/O optimized db.r7i.large).
Hyperscale cross-database querying is in preview! Cross-database queries help customers unblock SQL Server migrations by reducing the query rewrites and application redesign needed to move applications with cross-database dependencies. Customers can combine data across databases in the same Hyperscale elastic pool for reporting, analytics, and application workflows without building and maintaining extra data copies or pipelines solely to support those queries. They can preserve separate databases and per-database access controls, reuse familiar T-SQL skills, and simplify access to related business data. Get started today.
Security in the era of AI is two-fold, how you set up security for your data, and how your data provider maintains security. Fortunately, Microsoft SQL is elite at both, constantly pushing updates to maintain what we consider the most secure database on the planet, but also providing customer capabilities so you can set your organization up for success. One update is Regex-based dynamic data masking (GA) which helps handle masking for variable-length values with more flexibility. AES keys support for Transparent Data Encryption (TDE) with customer-managed keys in Azure SQL Database (GA), provides an alternative to RSA keys for protecting data at rest and helping you prepare for the evolving quantum threat landscape and TDE encryption scan suspend and resume (public preview) gives administrators more control over when scan work runs. Database-level managed identity in Azure SQL Database (public preview) enables separate, passwordless access to external data for each database which strengthens customer and business-unit isolation while preserving shared-server economics.
Recently a customer told me how great Microsoft SQL search options are, and we’re only getting better! Built-in fuzzy string matching (GA) helps applications compare inconsistent names or identify possible duplicates without moving that work out of SQL. Check out our YouTube channel for a recent episode on this topic.
Agentic modernization to Hyperscale
For existing SQL Server and hybrid estates, modernization starts with understanding the business and supported applications, because your database isn’t moving in isolation. With the evolution of AI, agents, and skills, modernizing to Hyperscale is getting easier. Our updates help bring assessment, application context and innovation, and migration closer together.
Modernize CLI (App+DB) delivers an end-to-end assessment that evaluates an application and its database dependencies as a single workload. It combines application-code modernization opportunities with SQL Server migration readiness, compatibility, and target recommendations in one consolidated report.
In Database Hub, agentic assessment and migration as optimization (both public preview) bring migration readiness into everyday estate management: use the Copilot sidecar to view readiness at scale, start assessments, and review results, and use the Optimize card to spot migration opportunities and open the full assessment in the Azure portal.
Across SSMS, Azure Arc, and Azure Catalyst (Azure Migrate got an upgrade!), updated assessments add Hyperscale service-tier recommendations to target selection, clarify readiness after remediation, and provide instance-level elastic-pool recommendations so you can evaluate databases together.
When you’re ready to move, Azure Arc expands migration access to more Azure-registered and agentless server scenarios, building on September’s Arc-to-Hyperscale migration preview. DMS private networking adds VNet peering and custom DNS support for supported migration endpoints without exposing databases publicly, and SqlPackage 170.5 and SQL Projects SDK 2.3 (GA) add deployment versioning, pre-plan scripts, and a force-Azure-compatibility export option.
Start locally. Build toward Hyperscale.
This is something I’ve been dreaming about since I joined the Microsoft SQL team: an always up-to-date local container that I could use to simulate and understand Azure SQL Database features and behaviors, without deploying anything or spinning any meters. The Azure SQL Database local development container is now public preview, so you can start doing exactly that! New container provisioning experiences in the VS Code MSSQL extension and SSMS bring container setup directly into familiar tools, making it easier to get started with local SQL development. In VS Code, Microsoft Entra authentication and expanded support for container runtimes and environments, including Podman, WSL, and Apple Silicon, offer greater flexibility for local development.
When you’re ready for Azure, the Local-to-Cloud Deployment Wizard, now in public preview for the MSSQL extension for VS Code, provides a guided path from a local database to a free tier Azure SQL Database with built-in deployment preparation and compatibility validation. Prefer working with AI agents? Microsoft SQL Agent skills continues to expand, with skills spanning local container development to cloud deployment, all easily installed as a plugin for your agent of choice.
Database Hub is generally available
Database Hub in Microsoft Fabric brings database discovery, monitoring, and optimization into one estate view, with real-time dashboards for Microsoft SQL, PostgreSQL, and Cosmos DB, improved filtering, and visibility into end-of-support, maintenance, and issues across database groups.
Copilot in Database Hub (public preview) helps you explore performance trends, investigate issues, and ask follow-up questions in natural language, grounded in Database Hub information. The Database Hub CLI skill, available in skills-for-fabric, brings inventory, health, performance, and security insights into GitHub Copilot CLI, VS Code Copilot, Claude Code, and Cursor after setup.
We’re making Database Agents even more powerful with three new public preview capabilities designed to help you identify issues faster, investigate them with AI, and make informed decisions to improve database performance. Enhanced detection helps uncover potential problems, while AI-powered skills let you investigate queries, analyze execution plans, and explore solutions directly from an issue or through Copilot side chat. You can receive recommendations for query rewrites, hints, and indexes, each backed by evidence and clear explanations to help you understand the issue and determine the best next steps. Of course, AI is only used when you choose to invoke these skills, and you’re always in control of reviewing recommendations before making changes to your database.
Alerts for Azure SQL Database (public preview), powered by Fabric Activator, turn templates or performance charts into alerts across one or more databases, with actions such as Teams messages or Power Automate flows.
Other updates across Microsoft SQL
Azure SQL Managed Instance adds GA for the zone-redundant Next-gen General Purpose (GP) tier, with a flexible memory option, log throughput of up to 220 MB/s, and more storage per vCore. MI link support for Always On availability groups (AGs) with multiple databases is now GA. SQL Managed Instance now also supports PITR backup immutability beyond 7 days and LTR backup immutability, both in public preview. Azure Migrate Runbooks also enter preview, with the runbook using existing Azure Blob backups to make migration smoother.
For SQL database in Fabric, Point-in-time restore (PITR) for deleted databases, and smaller maximum vCore options are now generally available for SQL database in Microsoft Fabric.
For our SQL Server customers, support for SQL Server 2025 on Ubuntu 26.04 LTS and Arc-enabled SQL Server Best Practices Assessment (BPA) v2, including support for Failover Cluster Instances, enter public preview. SQL Server on Azure VMs expands to Germany’s Delos Cloud, while Azure Local adds SQL licensing selection and updates, including disconnected scenarios.
On the developer front, the MSSQL extension introduces the Query Performance Dashboard (Preview), bringing Query Store insights directly into VS Code. You can also open Database Hub from the Object Explorer context menu to see resource-specific information in the Fabric Database Hub portal.
Data API builder (DAB) improvements let you apply configuration changes by redeploying an existing deployment rather than creating a new one. You can also run DAB locally using the DAB CLI as an alternative to Docker. Azure SQL Dev Hub also released an expanded preview with more capabilities and updates based on feedback, making it easier for you and your agents to get started.
SQL Server Management Studio (SSMS) introduces several new capabilities, including local Azure SQL Database container creation (preview), Hot Exit (preview), improved bacpac/dacpac creation and deployment wizards (preview), and integration with Fabric Database Hub, including Fabric SQL database creation (GA). GitHub Copilot in SSMS also adds Bring Your Own Model (BYOM) support, enabling users to work with their preferred AI models, including those hosted through Foundry Local.
What next
Start with the application you have. Assess its database dependencies and migration requirements. Evaluate Hyperscale as the destination!
Or start with a new local application. Try the container and guided development-to-cloud workflow in your tool of choice.
Keep learning. Watch the Microsoft SQL YouTube channel and Explore Azure SQL Database Hyperscale for more and use the SQL AI Developer certification to build the skills behind these workflows.
Start here, stay here!
–Anna

0 comments
Be the first to start the discussion.