{"id":7931,"date":"2026-11-16T15:40:42","date_gmt":"2026-11-16T23:40:42","guid":{"rendered":"https:\/\/devblogs.microsoft.com\/azure-sql\/?p=7931"},"modified":"2026-11-17T10:40:08","modified_gmt":"2026-11-17T18:40:08","slug":"whats-new-across-microsoft-sql-at-microsoft-ignite-2026","status":"publish","type":"post","link":"https:\/\/devblogs.microsoft.com\/azure-sql\/whats-new-across-microsoft-sql-at-microsoft-ignite-2026\/","title":{"rendered":"What&#8217;s new across Microsoft SQL at Microsoft Ignite 2026"},"content":{"rendered":"<p><span style=\"font-family: arial, helvetica, sans-serif;\"><a href=\"https:\/\/devblogs.microsoft.com\/azure-sql\/wp-content\/uploads\/sites\/56\/2026\/11\/microsoft-sql-ignite-2026-blog-header.webp\"><img decoding=\"async\" class=\"alignnone size-full wp-image-7932\" src=\"https:\/\/devblogs.microsoft.com\/azure-sql\/wp-content\/uploads\/sites\/56\/2026\/11\/microsoft-sql-ignite-2026-blog-header.webp\" alt=\"microsoft sql ignite 2026 blog header image\" width=\"1680\" height=\"944\" srcset=\"https:\/\/devblogs.microsoft.com\/azure-sql\/wp-content\/uploads\/sites\/56\/2026\/11\/microsoft-sql-ignite-2026-blog-header.webp 1680w, https:\/\/devblogs.microsoft.com\/azure-sql\/wp-content\/uploads\/sites\/56\/2026\/11\/microsoft-sql-ignite-2026-blog-header-300x169.webp 300w, https:\/\/devblogs.microsoft.com\/azure-sql\/wp-content\/uploads\/sites\/56\/2026\/11\/microsoft-sql-ignite-2026-blog-header-1024x575.webp 1024w, https:\/\/devblogs.microsoft.com\/azure-sql\/wp-content\/uploads\/sites\/56\/2026\/11\/microsoft-sql-ignite-2026-blog-header-768x432.webp 768w, https:\/\/devblogs.microsoft.com\/azure-sql\/wp-content\/uploads\/sites\/56\/2026\/11\/microsoft-sql-ignite-2026-blog-header-1536x863.webp 1536w\" sizes=\"(max-width: 1680px) 100vw, 1680px\" \/><\/a><\/span><\/p>\n<h2><span style=\"font-family: arial, helvetica, sans-serif;\">From Microsoft Ignite<\/span><\/h2>\n<p><span style=\"font-family: arial, helvetica, sans-serif;\">I\u2019m here in San Francisco enjoying specialty lattes, fall-ish weather (I guess?), and all the excitement around Microsoft announcements at Ignite 2026. It\u2019s 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\u2019t) will change their trajectories at those companies as well as likely have real impact on our day-to-day lives.<\/span><\/p>\n<p><span style=\"font-family: arial, helvetica, sans-serif;\">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.<\/span><\/p>\n<p><span style=\"font-family: arial, helvetica, sans-serif;\">Here&#8217;s what&#8217;s new across Azure SQL, SQL database in Fabric, SQL Server, and the tools you use every day.<\/span><\/p>\n<h2><span style=\"font-family: arial, helvetica, sans-serif;\">Azure SQL Database Hyperscale: start here, stay here<\/span><\/h2>\n<p><span style=\"font-family: arial, helvetica, sans-serif;\"><strong>Azure SQL Database Hyperscale is our modernization (and innovation!) target of choice. <\/strong>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!).<\/span><\/p>\n<p><span style=\"font-family: arial, helvetica, sans-serif;\">There is <strong>no extra database software to procure, acquire, purchase, or manage<\/strong>. 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).<\/span><\/p>\n<p><span style=\"font-family: arial, helvetica, sans-serif;\"><strong>Hyperscale cross-database querying is in preview!<\/strong> 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. <a href=\"https:\/\/forms.cloud.microsoft\/pages\/responsepage.aspx?id=v4j5cvGGr0GRqy180BHbR9G7yKOEnDhFsjdaB9D88RRUMVRSQVJXUjVXTlpKU0MySDU2OFI2TEFVQy4u&amp;route=shorturl\">Get started today<\/a>.<\/span><\/p>\n<p><span style=\"font-family: arial, helvetica, sans-serif;\"><strong>Security<\/strong> 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 <strong>Regex-based dynamic data masking (GA) <\/strong>which helps handle masking for variable-length values with more flexibility. \u00a0<strong>AES keys support for Transparent Data Encryption (TDE) with customer-managed keys in Azure SQL Database (GA)<\/strong>, provides an alternative to RSA keys for protecting data at rest and helping you prepare for the evolving quantum threat landscape and <strong>TDE encryption scan suspend and resume (public preview) <\/strong>gives administrators more control over when scan work runs. <strong>Database-level managed identity in Azure SQL Database (public preview)<\/strong> enables separate, passwordless access to external data for each database which strengthens customer and business-unit isolation while preserving shared-server economics. \u00a0<\/span><\/p>\n<p><span style=\"font-family: arial, helvetica, sans-serif;\">Recently a customer told me how great Microsoft SQL search options are, and we\u2019re only getting better! <strong>Built-in fuzzy string matching (GA)<\/strong> helps applications compare inconsistent names or identify possible duplicates without moving that work out of SQL. Check out our <a href=\"https:\/\/aka.ms\/microsoftsqlyt\">YouTube channel<\/a> for a recent episode on this topic.<\/span><\/p>\n<h2><span style=\"font-family: arial, helvetica, sans-serif;\">Agentic modernization to Hyperscale<\/span><\/h2>\n<p><span style=\"font-family: arial, helvetica, sans-serif;\">For existing SQL Server and hybrid estates, modernization starts with understanding the business and supported applications, because your database isn\u2019t 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.<\/span><\/p>\n<p><span style=\"font-family: arial, helvetica, sans-serif;\"><strong>Modernize CLI (App+DB)<\/strong> 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.<\/span><\/p>\n<p><span style=\"font-family: arial, helvetica, sans-serif;\">In <strong>Database Hub<\/strong>, 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 <strong>Optimize<\/strong> card to spot migration opportunities and open the full assessment in the Azure portal.<\/span><\/p>\n<p><span style=\"font-family: arial, helvetica, sans-serif;\">Across <strong>SSMS, Azure Arc, and Azure Catalyst (Azure Migrate got an upgrade!)<\/strong>, 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.<\/span><\/p>\n<p><span style=\"font-family: arial, helvetica, sans-serif;\">When you\u2019re ready to move, <strong>Azure Arc<\/strong> expands migration access to more Azure-registered and agentless server scenarios, building on September\u2019s Arc-to-Hyperscale migration preview. <strong>DMS<\/strong> private networking adds VNet peering and custom DNS support for supported migration endpoints without exposing databases publicly, and <strong>SqlPackage 170.5 and SQL Projects SDK 2.3 (GA)<\/strong> add deployment versioning, pre-plan scripts, and a force-Azure-compatibility export option.<\/span><\/p>\n<h2><span style=\"font-family: arial, helvetica, sans-serif;\">Start locally. Build toward Hyperscale.<\/span><\/h2>\n<p><span style=\"font-family: arial, helvetica, sans-serif;\">This is something I\u2019ve 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<strong> Azure SQL Database local development container is now public preview<\/strong>, 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, <strong>Microsoft Entra authentication and expanded support for container runtimes and environments<\/strong>, including Podman, WSL, and Apple Silicon, offer greater flexibility for local development.<\/span><\/p>\n<p><span style=\"font-family: arial, helvetica, sans-serif;\">When you&#8217;re ready for Azure, the <strong>Local-to-Cloud Deployment Wizard, now in public preview for the MSSQL extension for VS Code<\/strong>, 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? <a href=\"https:\/\/aka.ms\/microsoftsql-skills\">Microsoft SQL Agent skills<\/a> continues to expand, with skills spanning local container development to cloud deployment, all easily installed as a plugin for your agent of choice.<\/span><\/p>\n<h2><span style=\"font-family: arial, helvetica, sans-serif;\">Database Hub is generally available<\/span><\/h2>\n<p><span style=\"font-family: arial, helvetica, sans-serif;\"><strong>Database Hub in Microsoft Fabric<\/strong> 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.<\/span><\/p>\n<p><span style=\"font-family: arial, helvetica, sans-serif;\"><strong>Copilot in Database Hub (public preview)<\/strong> helps you explore performance trends, investigate issues, and ask follow-up questions in natural language, grounded in Database Hub information. The <strong>Database Hub CLI skill<\/strong>, available in <a href=\"https:\/\/github.com\/microsoft\/skills-for-fabric\">skills-for-fabric<\/a>, brings inventory, health, performance, and security insights into GitHub Copilot CLI, VS Code Copilot, Claude Code, and Cursor after setup.<\/span><\/p>\n<p><span style=\"font-family: arial, helvetica, sans-serif;\">We&#8217;re making <strong>Database Agents<\/strong> 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. <strong>Enhanced detection<\/strong> helps uncover potential problems, while <strong>AI-powered skills<\/strong> let you investigate queries, analyze execution plans, and explore solutions directly from an issue or through Copilot side chat. You can receive <strong>recommendations<\/strong> 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&#8217;re always in control of reviewing recommendations before making changes to your database.<\/span><\/p>\n<p><span style=\"font-family: arial, helvetica, sans-serif;\"><strong>Alerts for Azure SQL Database (public preview)<\/strong>, 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.<\/span><\/p>\n<h2><span style=\"font-family: arial, helvetica, sans-serif;\">Other updates across Microsoft SQL<\/span><\/h2>\n<p><span style=\"font-family: arial, helvetica, sans-serif;\"><strong>Azure SQL Managed Instance <\/strong>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.<\/span><\/p>\n<p><span style=\"font-family: arial, helvetica, sans-serif;\">For <strong>SQL database in Fabric,<\/strong> Point-in-time restore (PITR) for deleted databases, and smaller maximum vCore options are now generally available for SQL database in Microsoft Fabric.<\/span><\/p>\n<p><span style=\"font-family: arial, helvetica, sans-serif;\">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. <strong>SQL Server on Azure VMs<\/strong> expands to Germany&#8217;s Delos Cloud, while Azure Local adds SQL licensing selection and updates, including disconnected scenarios.<\/span><\/p>\n<p><span style=\"font-family: arial, helvetica, sans-serif;\">On the developer front, the MSSQL extension introduces the <strong>Query Performance Dashboard<\/strong> (Preview), bringing Query Store insights directly into VS Code. You can also open <strong>Database Hub<\/strong> from the Object Explorer context menu to see resource-specific information in the Fabric Database Hub portal.<\/span><\/p>\n<p><span style=\"font-family: arial, helvetica, sans-serif;\"><strong>Data API builder (DAB) improvements<\/strong> 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. <a href=\"https:\/\/aka.ms\/azuresql-hub\"><strong>Azure SQL Dev Hub<\/strong><\/a> also released an expanded preview with more capabilities and updates based on feedback, making it easier for you and your agents to get started.<\/span><\/p>\n<p><span style=\"font-family: arial, helvetica, sans-serif;\"><strong>SQL Server Management Studio<\/strong> (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.<\/span><\/p>\n<h2><span style=\"font-family: arial, helvetica, sans-serif;\">What next<\/span><\/h2>\n<p><span style=\"font-family: arial, helvetica, sans-serif;\"><strong>Start with the application you have.<\/strong> Assess its database dependencies and migration requirements. Evaluate Hyperscale as the destination!<\/span><\/p>\n<p><span style=\"font-family: arial, helvetica, sans-serif;\"><strong>Or start with a new local application.<\/strong> Try the container and guided development-to-cloud workflow in your tool of choice.<\/span><\/p>\n<p><span style=\"font-family: arial, helvetica, sans-serif;\"><strong>Keep learning.<\/strong> Watch the <a href=\"https:\/\/aka.ms\/azuresqlyt\">Microsoft SQL YouTube channel<\/a> and <a href=\"https:\/\/learn.microsoft.com\/azure\/azure-sql\/database\/service-tier-hyperscale\">Explore Azure SQL Database Hyperscale<\/a> for more and use the <a href=\"https:\/\/learn.microsoft.com\/credentials\/certifications\/developing-ai-enabled-database-solutions\/\">SQL AI Developer certification<\/a> to build the skills behind these workflows.<\/span><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"font-family: arial, helvetica, sans-serif;\">Start here, stay here!<\/span><\/p>\n<p><span style=\"font-family: arial, helvetica, sans-serif;\">&#8211;Anna<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>From Microsoft Ignite I\u2019m here in San Francisco enjoying specialty lattes, fall-ish weather (I guess?), and all the excitement around Microsoft announcements at Ignite 2026. It\u2019s 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 [&hellip;]<\/p>\n","protected":false},"author":12403,"featured_media":7932,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[601,1],"tags":[],"class_list":["post-7931","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-ai","category-azure-sql"],"acf":[],"blog_post_summary":"<p>From Microsoft Ignite I\u2019m here in San Francisco enjoying specialty lattes, fall-ish weather (I guess?), and all the excitement around Microsoft announcements at Ignite 2026. It\u2019s 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 [&hellip;]<\/p>\n","_links":{"self":[{"href":"https:\/\/devblogs.microsoft.com\/azure-sql\/wp-json\/wp\/v2\/posts\/7931","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/devblogs.microsoft.com\/azure-sql\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/devblogs.microsoft.com\/azure-sql\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/azure-sql\/wp-json\/wp\/v2\/users\/12403"}],"replies":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/azure-sql\/wp-json\/wp\/v2\/comments?post=7931"}],"version-history":[{"count":1,"href":"https:\/\/devblogs.microsoft.com\/azure-sql\/wp-json\/wp\/v2\/posts\/7931\/revisions"}],"predecessor-version":[{"id":7936,"href":"https:\/\/devblogs.microsoft.com\/azure-sql\/wp-json\/wp\/v2\/posts\/7931\/revisions\/7936"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/azure-sql\/wp-json\/wp\/v2\/media\/7932"}],"wp:attachment":[{"href":"https:\/\/devblogs.microsoft.com\/azure-sql\/wp-json\/wp\/v2\/media?parent=7931"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/azure-sql\/wp-json\/wp\/v2\/categories?post=7931"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/azure-sql\/wp-json\/wp\/v2\/tags?post=7931"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}