{"id":7958,"date":"2026-11-17T14:03:17","date_gmt":"2026-11-17T22:03:17","guid":{"rendered":"https:\/\/devblogs.microsoft.com\/azure-sql\/?p=7958"},"modified":"2026-11-17T14:03:17","modified_gmt":"2026-11-17T22:03:17","slug":"vscode-mssql-november2026","status":"publish","type":"post","link":"https:\/\/devblogs.microsoft.com\/azure-sql\/vscode-mssql-november2026\/","title":{"rendered":"MSSQL Extension for VS Code: Local Azure SQL Database Provisioning, Query Performance Dashboard, and more"},"content":{"rendered":"<div>\n<p>A local database is a useful starting point, but deploying it and understanding how queries behave should fit into the same development workflow. The <a href=\"https:\/\/aka.ms\/vscode-mssql\" target=\"_blank\" rel=\"noopener\">MSSQL extension for VS Code<\/a> v1.48 brings three new public previews: <strong>Azure SQL Database local container provisioning<\/strong>, a <strong>local-to-cloud deployment wizard<\/strong>, and the <strong>Query Performance Dashboard<\/strong>. This November release also expands the preview query results experience and includes improvements to connection organization and Data API builder.<\/p>\n<p>\ud83c\udfac Watch YouTube demo:<\/p>\n<p><iframe loading=\"lazy\" src=\"\/\/www.youtube.com\/embed\/itjt3CqDlyA?t=51s\" width=\"560\" height=\"314\" allowfullscreen=\"allowfullscreen\"><\/iframe><\/p>\n<\/div>\n<div>\n<h2>What&#8217;s new in MSSQL extension for VS Code v1.48<\/h2>\n<p>Here&#8217;s a summary of the key features in this release:<\/p>\n<ul>\n<li><strong>Azure SQL Database local container provisioning (Preview)<\/strong>: Develop against the Azure SQL Database engine locally, without an Azure subscription.<\/li>\n<li><strong>Local-to-cloud deployment wizard (Preview)<\/strong>: Check compatibility and deploy a local database&#8217;s schema, or schema and data, to a new Azure SQL Database.<\/li>\n<li><strong>Query Performance Dashboard (Preview)<\/strong>: Investigate Query Store history, resource-intensive queries, waits, and execution plans from the editor.<\/li>\n<li><strong>Multi-results grid and live query statistics (Preview)<\/strong>: Compare results across query files and inspect execution progress while a query runs.<\/li>\n<li><strong>Nested connection groups<\/strong>: Organize connections into a hierarchy that matches your projects and environments.<\/li>\n<li><strong>Data API builder improvements<\/strong>: Redeploy updated APIs and run them locally with the DAB CLI, including Microsoft Entra authentication.<\/li>\n<\/ul>\n<p><!-- ==================== PREVIEW FEATURE SECTIONS ==================== --><\/p>\n<h2>Azure SQL Database local container provisioning (Preview)<\/h2>\n<p>Build and test locally with the <strong>Azure SQL Database container<\/strong>, which runs the Azure SQL Database engine rather than the SQL Server container image. It is free for local development and testing, requires no Azure subscription or credit card, and works with the drivers and ORMs you use for Azure SQL Database.<\/p>\n<p>In <strong>Connections<\/strong>, select <strong>New Deployment<\/strong>, then <strong>Azure SQL Database container (Preview)<\/strong>. The wizard checks your runtime, downloads the image, starts the engine, and saves a connection. Supported runtimes include Docker, Podman, containerd with <code>nerdctl<\/code>, and WSL containers on Windows.<\/p>\n<p><a href=\"https:\/\/devblogs.microsoft.com\/azure-sql\/wp-content\/uploads\/sites\/56\/2026\/11\/mssql-azuresqlcontainerprovisioning-scaled.gif\"><img decoding=\"async\" class=\"alignnone size-full wp-image-7961\" src=\"https:\/\/devblogs.microsoft.com\/azure-sql\/wp-content\/uploads\/sites\/56\/2026\/11\/mssql-azuresqlcontainerprovisioning-scaled.gif\" alt=\"mssql azuresqlcontainerprovisioning image\" width=\"2500\" height=\"1406\" \/><\/a><\/p>\n<h3>Key highlights<\/h3>\n<ul>\n<li><strong>Develop against the Azure SQL engine<\/strong>: Use Azure SQL Database T-SQL locally with your existing application data access tools.<\/li>\n<li><strong>No cloud account needed<\/strong>: Start local development without creating Azure resources or providing a credit card.<\/li>\n<li><strong>x64 and ARM support<\/strong>: Run the preview on supported devices across both architectures.<\/li>\n<li><strong>Guided setup<\/strong>: Provision the container and save its connection without writing container commands.<\/li>\n<li><strong>Manage from VS Code<\/strong>: Start, stop, reconnect to, and delete the container from the extension.<\/li>\n<\/ul>\n<p>The container is a local development environment, not the managed Azure service. Test cloud-specific behavior against Azure SQL Database before deploying your application.<\/p>\n<p>For full documentation, see <a href=\"https:\/\/aka.ms\/vscode-mssql-container-docs\" target=\"_blank\" rel=\"noopener\">Local Azure SQL Database and SQL Server containers<\/a>.<\/p>\n<h2>Local-to-cloud deployment wizard (Preview)<\/h2>\n<p>Move a local development database to a new free-tier Azure SQL database with the <strong>local-to-cloud deployment wizard<\/strong>. Choose schema only or schema and data; the extension creates and deploys the DACPAC or BACPAC. Your local database and container stay unchanged.<\/p>\n<p>Select <strong>New Deployment<\/strong> in <strong>Connections<\/strong>, then <strong>Local database to Azure SQL Database (Preview)<\/strong>, or right-click a local database and choose <strong>Deploy database to Azure SQL (Preview)<\/strong>. A running local database and an Azure subscription with resource-creation permissions are required.<\/p>\n<p><a href=\"https:\/\/devblogs.microsoft.com\/azure-sql\/wp-content\/uploads\/sites\/56\/2026\/11\/mssql-localtocloud-scaled.gif\"><img decoding=\"async\" class=\"alignnone size-full wp-image-7963\" src=\"https:\/\/devblogs.microsoft.com\/azure-sql\/wp-content\/uploads\/sites\/56\/2026\/11\/mssql-localtocloud-scaled.gif\" alt=\"mssql localtocloud image\" width=\"2500\" height=\"1406\" \/><\/a><\/p>\n<h3>Key highlights<\/h3>\n<ul>\n<li><strong>Choose what to copy<\/strong>: Deploy database objects alone or include the rows in your tables.<\/li>\n<li><strong>Check compatibility first<\/strong>: Validate the schema against an Azure SQL Database target before creating cloud resources.<\/li>\n<li><strong>Configure the destination<\/strong>: Choose a subscription, resource group, logical server, and database in the wizard.<\/li>\n<li><strong>Connect after deployment<\/strong>: The extension verifies deployment and saves the Azure SQL connection for continued development.<\/li>\n<\/ul>\n<p>For full documentation, see <a href=\"https:\/\/aka.ms\/vscode-mssql-local-to-cloud-deployment-docs\" target=\"_blank\" rel=\"noopener\">Deploy a local database to Azure SQL<\/a>.<\/p>\n<h2>Query Performance Dashboard (Preview)<\/h2>\n<p>The <strong>Query Performance Dashboard<\/strong> brings historical Query Store data into VS Code, helping you move from a database-wide view of expensive queries to execution history, waits, and execution plans.<\/p>\n<p>Right-click a database in <strong>Connections<\/strong> and select <strong>Open Query Performance Dashboard (Preview)<\/strong>. Query Store must be enabled and have captured workload data, and your account needs permission to read it.<\/p>\n<p><a href=\"https:\/\/devblogs.microsoft.com\/azure-sql\/wp-content\/uploads\/sites\/56\/2026\/11\/mssql-queryperfdashboard.gif\"><img decoding=\"async\" class=\"alignnone size-full wp-image-7959\" src=\"https:\/\/devblogs.microsoft.com\/azure-sql\/wp-content\/uploads\/sites\/56\/2026\/11\/mssql-queryperfdashboard.gif\" alt=\"mssql queryperfdashboard image\" width=\"2880\" height=\"1620\" \/><\/a><\/p>\n<h3>Key highlights<\/h3>\n<ul>\n<li><strong>Find resource-intensive queries<\/strong>: Explore high CPU, memory grants, duration, execution frequency, and logical reads, with ranking and time-range controls.<\/li>\n<li><strong>Investigate history and waits<\/strong>: Review trends and, where Query Store wait capture is supported and enabled, investigate wait categories.<\/li>\n<li><strong>Compare against a baseline<\/strong>: Compare CPU time or memory grants with an earlier period to investigate changes in resource use.<\/li>\n<li><strong>Inspect and compare plans<\/strong>: Open captured execution plans or select two plans for side-by-side comparison.<\/li>\n<li><strong>Continue in GitHub Copilot Chat<\/strong>: Send the query and investigation context to agent mode for a performance assessment, with confirmation required before applying changes.<\/li>\n<\/ul>\n<p>For full documentation, see <a href=\"https:\/\/aka.ms\/vscode-mssql-querystore-docs\" target=\"_blank\" rel=\"noopener\">Query Performance Dashboard overview<\/a>.<\/p>\n<h2>Other improvements<\/h2>\n<h3>Multi-results grid (Preview)<\/h3>\n<p>The <strong>multi-results layout<\/strong> lets you compare query files&#8217; results side by side, retain results after closing editors, and choose whether results follow the active editor. Enable <code>mssql.preview.multiResults<\/code> or select <strong>Multi-Results Layout<\/strong> in <strong>Query Results<\/strong>.<\/p>\n<p><!-- Add multi-results layout screenshot here after capturing the v1.48 experience --><\/p>\n<h3>Live query statistics (Preview)<\/h3>\n<p><strong>Live query statistics<\/strong> shows row counts, estimated progress, and elapsed time while a query runs. Preview commands are enabled by default; select <strong>MSSQL: Enable Live Query Statistics<\/strong> in a connected SQL editor before executing the query.<\/p>\n<p><!-- Add live query statistics screenshot here after capturing the v1.48 experience --><\/p>\n<h3>Nested connection groups<\/h3>\n<p><strong>Nested connection groups<\/strong> organize connections by project, team, or environment. Choose a <strong>Parent group<\/strong> when creating or editing a group, or drag connections and groups into place in <strong>Connections<\/strong>.<\/p>\n<p><!-- Add nested connection groups screenshot here after capturing the v1.48 experience --><\/p>\n<h3>Data API builder improvements<\/h3>\n<p><strong>Data API builder<\/strong> adds smoother redeployment and local CLI workflows:<\/p>\n<ul>\n<li><strong>Review and redeploy<\/strong>: Select <strong>View changes<\/strong> to review configuration updates, then <strong>Apply changes<\/strong> to redeploy.<\/li>\n<li><strong>Run without Docker<\/strong>: Select <strong>Data API builder CLI<\/strong> to run the API locally. The extension prepares the CLI and required .NET runtime.<\/li>\n<li><strong>Microsoft Entra database authentication<\/strong>: The CLI workflow supports browser or device-code sign-in through Azure CLI to authenticate DAB to the database. API caller authentication is configured separately.<\/li>\n<\/ul>\n<p><!-- Add Data API builder deployment controls screenshot here after capturing the v1.48 experience --><\/p>\n<\/div>\n<div>\n<h2>Next steps<\/h2>\n<p>If there&#8217;s something you&#8217;d love to see in a future update, here&#8217;s how you can contribute:<\/p>\n<ul>\n<li>\ud83d\udcac\u00a0<a href=\"https:\/\/aka.ms\/vscode-mssql-discussions\">GitHub discussions<\/a>\u00a0\u2013 Share your ideas and suggestions to improve the extension<\/li>\n<li>\u2728\u00a0<a href=\"https:\/\/aka.ms\/vscode-mssql-feature-request\">New feature requests<\/a>\u00a0\u2013 Request missing capabilities and help shape future updates<\/li>\n<li>\ud83d\udc1e\u00a0<a href=\"https:\/\/aka.ms\/vscode-mssql-bug\">Report bugs<\/a>\u00a0\u2013 Help us track down and fix issues to make the extension more reliable<\/li>\n<\/ul>\n<p>If you&#8217;d like to learn more about the MSSQL extension, you can:<\/p>\n<ul>\n<li>\ud83c\udfac\u00a0<a href=\"https:\/\/aka.ms\/vscode-mssql-demos\" target=\"_blank\" rel=\"noreferrer noopener nofollow\">Watch the demos<\/a>: Explore key features through our YouTube playlist<\/li>\n<li>\ud83e\udd16\u00a0<a href=\"https:\/\/aka.ms\/vscode-mssql-copilot-demos\" target=\"_blank\" rel=\"noreferrer noopener nofollow\">Watch the GitHub Copilot demos<\/a>: Learn how to use GitHub Copilot to write, explain, and refactor your database schema<\/li>\n<li>\ud83d\udcdd\u00a0<a href=\"https:\/\/aka.ms\/vscode-mssql-blogs\" target=\"_blank\" rel=\"noreferrer noopener nofollow\">Read the blog posts<\/a>: Learn from use cases, walkthroughs, and product updates<\/li>\n<li>\ud83d\udcd6\u00a0<a href=\"https:\/\/aka.ms\/vscode-mssql-docs\" target=\"_blank\" rel=\"noreferrer noopener nofollow\">Read the documentation<\/a>: Get started or go deep with our official docs<\/li>\n<li>\ud83d\uddfa\ufe0f\u00a0<a href=\"https:\/\/aka.ms\/vscode-mssql-roadmap#2026\" target=\"_blank\" rel=\"noreferrer noopener nofollow\">Check out the roadmap<\/a>: See what&#8217;s coming next, including upcoming features and improvements<\/li>\n<\/ul>\n<p>Thanks for being part of the journey\u2014happy coding! \ud83d\ude80<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>A local database is a useful starting point, but deploying it and understanding how queries behave should fit into the same development workflow. The MSSQL extension for VS Code v1.48 brings three new public previews: Azure SQL Database local container provisioning, a local-to-cloud deployment wizard, and the Query Performance Dashboard. This November release also expands [&hellip;]<\/p>\n","protected":false},"author":187531,"featured_media":81,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[1,580,669,533,625],"tags":[682],"class_list":["post-7958","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-azure-sql","category-data-api-builder","category-github-copilot","category-visual-studio-code","category-vs-code","tag-vscode-mssql"],"acf":[],"blog_post_summary":"<p>A local database is a useful starting point, but deploying it and understanding how queries behave should fit into the same development workflow. The MSSQL extension for VS Code v1.48 brings three new public previews: Azure SQL Database local container provisioning, a local-to-cloud deployment wizard, and the Query Performance Dashboard. This November release also expands [&hellip;]<\/p>\n","_links":{"self":[{"href":"https:\/\/devblogs.microsoft.com\/azure-sql\/wp-json\/wp\/v2\/posts\/7958","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\/187531"}],"replies":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/azure-sql\/wp-json\/wp\/v2\/comments?post=7958"}],"version-history":[{"count":1,"href":"https:\/\/devblogs.microsoft.com\/azure-sql\/wp-json\/wp\/v2\/posts\/7958\/revisions"}],"predecessor-version":[{"id":7992,"href":"https:\/\/devblogs.microsoft.com\/azure-sql\/wp-json\/wp\/v2\/posts\/7958\/revisions\/7992"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/azure-sql\/wp-json\/wp\/v2\/media\/81"}],"wp:attachment":[{"href":"https:\/\/devblogs.microsoft.com\/azure-sql\/wp-json\/wp\/v2\/media?parent=7958"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/azure-sql\/wp-json\/wp\/v2\/categories?post=7958"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/azure-sql\/wp-json\/wp\/v2\/tags?post=7958"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}