{"id":4307,"date":"2025-03-06T08:00:38","date_gmt":"2025-03-06T16:00:38","guid":{"rendered":"https:\/\/devblogs.microsoft.com\/azure-sql\/?p=4307"},"modified":"2025-07-18T13:00:38","modified_gmt":"2025-07-18T20:00:38","slug":"mssql-vs-code-whats-new-next","status":"publish","type":"post","link":"https:\/\/devblogs.microsoft.com\/azure-sql\/mssql-vs-code-whats-new-next\/","title":{"rendered":"MSSQL Extension for VS Code: What\u2019s new and what\u2019s next"},"content":{"rendered":"<p class=\"p1\"><span class=\"s1\">The <\/span><a href=\"https:\/\/aka.ms\/vscode-mssql-marketplace\" target=\"_blank\" rel=\"noopener\">MSSQL extension for Visual Studio Code<\/a> continues to evolve, bringing powerful new features and enhancements that make SQL development <span class=\"s1\">more seamless and efficient<\/span>. In this update, we\u2019re excited to share the latest improvements in <span class=\"s1\">v1.29.0<\/span> and give you a <span class=\"s1\">sneak peek at what\u2019s coming next<\/span> in our <a href=\"https:\/\/aka.ms\/vscode-mssql-roadmap\"><span class=\"s1\">open roadmap<\/span><\/a>.<\/p>\n<p class=\"p3\"><span class=\"s2\">This extension is designed for developers working with <\/span>Azure SQL<span class=\"s2\"> (including <\/span>Azure SQL Database, Azure SQL Managed Instance, and SQL Server on Azure VMs<span class=\"s2\">), <\/span>SQL Database in Fabric (Preview),<span class=\"s2\"> or <\/span>SQL Server<span class=\"s2\"> as a backend. With a rich set of features for <\/span>connecting to databases, managing schemas, executing queries, and visualizing query plans<span class=\"s2\">, the <\/span>MSSQL Extension for VS Code<span class=\"s2\"> provides a <\/span>modern SQL development experience inside your favorite editor<span class=\"s2\">.<\/span><\/p>\n<h2>What&#8217;s new in MSSQL extension for VS Code v1.29.0?<\/h2>\n<p class=\"p1\"><a href=\"https:\/\/github.com\/microsoft\/vscode-mssql\/releases\/tag\/v1.29.0\" target=\"_blank\" rel=\"noopener\">The latest update (<span class=\"s1\">v1.29.0<\/span>)<\/a> brings several key enhancements focused on <span class=\"s1\">improving usability, fixing long-standing issues, and ensuring better compatibility<\/span> with Azure SQL and SQL Server.<\/p>\n<p class=\"p1\">Here\u2019s a detailed look at what\u2019s new in this release:<\/p>\n<ul>\n<li class=\"p1\">Fixed support for <span class=\"s1\">Always Encrypted &#8211; Secure Enclaves<\/span> in the Connection Dialog.<\/li>\n<li class=\"p1\"><span class=\"s2\">Improved usability by removing <\/span>SQL editor actions from the Git diff editor<span class=\"s2\">.<\/span><\/li>\n<li class=\"p2\"><span class=\"s2\">Enhanced <\/span>Query Result pane<span class=\"s2\"> by fixing issues related to <\/span>copying data while sorting and filtering<span class=\"s2\">.<\/span><\/li>\n<li class=\"p1\">Resolved column filter issues in multiple result set scenarios.<\/li>\n<li class=\"p2\"><span class=\"s2\"> Improved <\/span>accessibility in Query Plan Visualizer<span class=\"s2\">.<\/span><\/li>\n<li class=\"p2\"><span class=\"s2\">Fixed <\/span>indefinite hangs when connecting to paused Azure SQL Database Serverless databases<span class=\"s2\">.<\/span><\/li>\n<li class=\"p2\"><span class=\"s2\">Fixed <\/span>HTTPS-over-HTTP proxy handling issues<span class=\"s2\">.<\/span><\/li>\n<\/ul>\n<h3>Enabling the New UI Features<\/h3>\n<p class=\"p1\"><span class=\"s1\">We\u2019ve seen some <\/span>confusion from developers about accessing the latest UI improvements<span class=\"s1\">. To make sure you\u2019re using all the newest features, <\/span><strong>you need to enable the new UI settings<\/strong><span class=\"s1\"><strong> in VS Code<\/strong>.<\/span><\/p>\n<p class=\"p3\">When you update to <span class=\"s2\">v1.29.0<\/span>, a <span class=\"s2\">prompt will appear<\/span> guiding you through the setup. If you missed it, you can enable the new UI manually in your <span class=\"s2\">VS Code settings<\/span>.<\/p>\n<p><a href=\"https:\/\/devblogs.microsoft.com\/azure-sql\/wp-content\/uploads\/sites\/56\/2024\/11\/enable-features.png\"><img decoding=\"async\" class=\"alignnone size-full wp-image-3884\" src=\"https:\/\/devblogs.microsoft.com\/azure-sql\/wp-content\/uploads\/sites\/56\/2024\/11\/enable-features.png\" alt=\"Image of enable features\" width=\"540\" height=\"156\" srcset=\"https:\/\/devblogs.microsoft.com\/azure-sql\/wp-content\/uploads\/sites\/56\/2024\/11\/enable-features.png 540w, https:\/\/devblogs.microsoft.com\/azure-sql\/wp-content\/uploads\/sites\/56\/2024\/11\/enable-features-300x87.png 300w\" sizes=\"(max-width: 540px) 100vw, 540px\" \/><\/a><\/p>\n<p class=\"p1\"><div class=\"alert alert-success\"><\/div><\/p>\n<h2>Looking ahead: Open roadmap<\/h2>\n<p class=\"p1\"><a href=\"https:\/\/aka.ms\/vscode-mssql-repo\/\" target=\"_blank\" rel=\"noopener\"><span class=\"s1\">The <\/span>MSSQL extension for Visual Studio Code<\/a><span class=\"s1\"> is evolving rapidly, with a strong focus on <\/span>developer productivity, seamless local-to-cloud transitions, and intuitive database schema management<span class=\"s1\">. Our roadmap reflects the <\/span>top priorities<span class=\"s1\"> we\u2019re working on based on <\/span>community feedback, GitHub discussions, and real-world use cases<span class=\"s1\">.<\/span><\/p>\n<h3>Our vision<\/h3>\n<p class=\"p1\">We aim to deliver a <span class=\"s1\"><b>modern, developer-first SQL experience<\/b><\/span> by focusing on three key areas:<\/p>\n<ul>\n<li class=\"p1\"><strong>Developer productivity<\/strong> \u2013 Streamlining workflows, improving UI\/UX, and reducing friction in database interactions.<\/li>\n<li class=\"p1\"><strong>Seamless development from local to cloud<\/strong> \u2013 Enabling developers to start locally in VS Code using local database containers or Dev Containers while ensuring a smooth transition to cloud environments with CI\/CD support and cloud-native deployments.<\/li>\n<li class=\"p1\"><strong>Schema Management &amp; API-Driven Development<\/strong> \u2013 Expanding schema design capabilities and enabling modern API-driven workflows to make database access seamless for application developers.<\/li>\n<\/ul>\n<h3>What is next in 2025?<\/h3>\n<div>\n<p class=\"p1\">We have exciting updates lined up to enhance the MSSQL extension and make SQL development even more seamless:<\/p>\n<ul>\n<li class=\"p2\"><b>General Availability of UI Enhancements<\/b><span class=\"s1\"> \u2013 Bringing <\/span><b>Connection Dialog, Object Explorer, Query Results, and Table Designer<\/b><span class=\"s1\"> to full stability and refinement.<\/span><\/li>\n<li class=\"p2\"><b>Local-to-Cloud Deployments<\/b><span class=\"s1\"> \u2013 Easily transition from local development to the cloud with <\/span>Local Database Containers, Dev Containers, and Cloud Database Deployment<span class=\"s1\">.<\/span><\/li>\n<li class=\"p2\"><b>Expanded Import\/Export Capabilities<\/b><span class=\"s1\"> \u2013 Support for <\/span>Flat File Import and DACPAC Import\/Export<span class=\"s1\">.<\/span><\/li>\n<li class=\"p2\"><b>Complete Schema Management<\/b><span class=\"s1\"> \u2013 A more intuitive experience with <\/span>Schema Designer and Schema Compare<span class=\"s1\">.<\/span><\/li>\n<li class=\"p3\"><span class=\"s2\"><b>Developer Tools<\/b><\/span> \u2013 <span class=\"s2\">Data API Builder<\/span> integration for seamless API generation.<\/li>\n<\/ul>\n<p><!--ScriptorEndFragment--><\/p>\n<\/div>\n<h3>How you can help us shape the future<\/h3>\n<p class=\"p1\"><span class=\"s1\">The <\/span>MSSQL Extension for VS Code<span class=\"s1\"> is built with <\/span>developer feedback at its core<span class=\"s1\">. While we strive to bring the best SQL development experience, <\/span><strong>not every feature request is feasible<\/strong><span class=\"s1\"> due to <\/span>technical limitations and other constraints<span class=\"s1\">.<\/span><\/p>\n<p class=\"p1\">But your <span class=\"s1\">input helps us prioritize<\/span>! If there\u2019s something you\u2019d love to see in a future update, here\u2019s how you can contribute:<\/p>\n<ul>\n<li>\ud83d\udcac <a href=\"https:\/\/aka.ms\/vscode-mssql-discussions\" target=\"_blank\" rel=\"noopener\">GitHub discussions<\/a> &#8211; Share your ideas and suggestions to improve the extension.<\/li>\n<li>\u2728 <a href=\"https:\/\/aka.ms\/vscode-mssql-feature-request\" target=\"_blank\" rel=\"noopener\">New feature requests<\/a> &#8211; Request missing capabilities and help shape future updates.<\/li>\n<li>\ud83d\udc1e <a href=\"https:\/\/aka.ms\/vscode-mssql-bug\" target=\"_blank\" rel=\"noopener\">Report bugs<\/a> &#8211; Help us track down and fix issues to make the extension more reliable.<\/li>\n<\/ul>\n<h2>Conclusion<\/h2>\n<p class=\"p1\">The latest updates in <span class=\"s1\">v1.29.0<\/span> bring important improvements, but <strong>we\u2019re just getting started<\/strong>. With <span class=\"s1\">major enhancements on the way<\/span>, we\u2019re committed to making SQL development <span class=\"s1\">more productive, seamless, and intuitive<\/span> inside VS Code.<\/p>\n<p class=\"p1\">As we continue to evolve the extension, <span class=\"s1\">we encourage feedback and collaboration<\/span> to help us refine and improve the experience. Thank you for being part of this journey! \ud83d\ude80<\/p>\n","protected":false},"excerpt":{"rendered":"<p>The MSSQL extension for Visual Studio Code continues to evolve, bringing powerful new features and enhancements that make SQL development more seamless and efficient. In this update, we\u2019re excited to share the latest improvements in v1.29.0 and give you a sneak peek at what\u2019s coming next in our open roadmap. This extension is designed for [&hellip;]<\/p>\n","protected":false},"author":132338,"featured_media":4318,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[1,625],"tags":[529,510,449,638,558,682],"class_list":["post-4307","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-azure-sql","category-vs-code","tag-azure-sql","tag-azure-sql-database","tag-development","tag-sql-database-in-fabric","tag-vs-code","tag-vscode-mssql"],"acf":[],"blog_post_summary":"<p>The MSSQL extension for Visual Studio Code continues to evolve, bringing powerful new features and enhancements that make SQL development more seamless and efficient. In this update, we\u2019re excited to share the latest improvements in v1.29.0 and give you a sneak peek at what\u2019s coming next in our open roadmap. This extension is designed for [&hellip;]<\/p>\n","_links":{"self":[{"href":"https:\/\/devblogs.microsoft.com\/azure-sql\/wp-json\/wp\/v2\/posts\/4307","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\/132338"}],"replies":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/azure-sql\/wp-json\/wp\/v2\/comments?post=4307"}],"version-history":[{"count":0,"href":"https:\/\/devblogs.microsoft.com\/azure-sql\/wp-json\/wp\/v2\/posts\/4307\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/azure-sql\/wp-json\/wp\/v2\/media\/4318"}],"wp:attachment":[{"href":"https:\/\/devblogs.microsoft.com\/azure-sql\/wp-json\/wp\/v2\/media?parent=4307"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/azure-sql\/wp-json\/wp\/v2\/categories?post=4307"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/azure-sql\/wp-json\/wp\/v2\/tags?post=4307"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}