{"id":33155,"date":"2020-12-17T11:00:26","date_gmt":"2020-12-17T19:00:26","guid":{"rendered":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/?p=33155"},"modified":"2024-01-08T21:56:06","modified_gmt":"2024-01-09T05:56:06","slug":"sql-tools-december-release-recap","status":"publish","type":"post","link":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2020\/12\/17\/sql-tools-december-release-recap\/","title":{"rendered":"SQL Tools December release recap"},"content":{"rendered":"

The December releases of Azure Data Studio<\/a> 1.25 and SQL Server Management Studio<\/a> (SSMS) 18.8 are now generally available.\u00a0 Additionally, the mssql extension<\/a> for Visual Studio Code has recently been updated to version 1.10.0. Read on to learn more about each of these updates and grab the latest versions of SSMS, Azure Data Studio, or the mssql extension for VS Code.<\/p>\n

Azure Data Studio v1.25<\/h2>\n

Azure Data Studio follows a four by two development model, where the development cycle includes a two month effort for fundamentals between a four month period focused on improvements and feature creation. In looking at this month\u2019s release notes<\/a>, you will see that limited features were added but over 30 bugs were fixed. Taking a period to focus engineering work on fundamentals helps keep the codebase healthy and ensures we dedicate attention to addressing imperceivable functionality and improving engineering processes.<\/p>\n

\"Upper<\/p>\n

SQL Database Projects extension in Azure Data Studio<\/h2>\n

The 1.25 release of Azure Data Studio is accompanied by an update to the SQL Database Projects extension, which introduces workspaces and an improved viewlet focused on projects in the sidebar. A workspace is a logical collection of projects and can contain a single project or multiple projects. The new projects viewlet displays any projects in the current workspace and the associated objects and actions, including pre or post deployment scripts and database references. Containing projects in workspaces facilitates quickly reopening the same set of projects<\/p>\n

Azure Data Studio included with SQL Server Management Studio<\/h2>\n

As highlighted in a previous blog post<\/a>, starting with SQL Server Management Studio 18.7, Azure Data Studio is now included in the SSMS installer. This change brings new features to SSMS, now and increasingly in the future. Since this release, we have had the opportunity to discuss some of the unique challenges that users face in deploying SQL tools. Today we\u2019d like to share more information about the roadmap and current installation processes for SSMS and Azure Data Studio. Before we discuss these details, we\u2019d like to thank those who stepped forward to engage in discussions about the specifics of their environments.<\/p>\n

The roadmap for graphical SQL tools can be scoped in two phases, continued version 18 releases and a future major version of SSMS. For the remainder of v18, skipping the installation of Azure Data Studio can be accomplished via a command line flag. A future version of SSMS will require dependencies provided by Azure Data Studio but this change will be communicated ahead of the release.\u00a0 At this time, installation without Azure Data Studio can be accomplished through the command line flag \u201cDoNotInstallAzureDataStudio=1\u201d.\u00a0 An example use of this would be:<\/p>\n

SSMS-Setup-ENU.exe \/Passive DoNotInstallAzureDataStudio=1<\/p>\n

A common set of questions about the combined installation has led to additional information in our installation documentation<\/a>, but the most frequent question was \u201cCan Azure Data Studio be updated separately?\u201d The SQL Server Management Studio installation will not overwrite an equivalent or newer version of Azure Data Studio, allowing independent Azure Data Studio updates if desired.<\/p>\n

SQL Server Management Studio (SSMS) v18.8<\/h2>\n

Rounding out the year with a fourth release of SSMS, this release includes a handful of fixes and new functionality added for auditing in Azure SQL Managed Instance (MI). For more about the EXTERNAL_MONITOR keyword, review the documentation<\/a>.<\/p>\n

The introduction of filtering of Extended Events by the wait_type name introduced a defect and has been temporarily removed while the defect is corrected. Details on the other changes can be found in the release notes<\/a>, including fixes for a long-standing issue with XML column reordering and the SQL Replication Monitor auto-connect capability.<\/p>\n

mssql extension v1.10.0 for Visual Studio Code<\/h2>\n

The v1.10.0 release of the mssql extension<\/a> for Visual Studio Code brings Azure Active Directory (AAD) authentication support, improvements to syntax colorization, and some bug fixes.<\/p>\n

2020 recap<\/h2>\n

The Azure data platform user base is growing across their choice of deployment options, platforms, and current skillsets. During the past year, we have seen a progression of SQL Server tools to support new workflows and experiences, including Azure Arc, Azure SQL Edge, and SQL Server on Linux. Of the flagship graphical tools, this included four version releases of SSMS and monthly releases of Azure Data Studio. We look forward to continuing to bring new capabilities to you in 2021.<\/p>\n","protected":false},"excerpt":{"rendered":"

The December releases of Azure Data Studio 1.25 and SQL Server Management Studio (SSMS) 18.8 are now generally available.\u00a0 Additionally, the mssql extension for Visual Studio Code has recently been updated to version 1.10.0. Read on to learn more about each of these updates and grab the latest versions of SSMS, Azure Data Studio, or<\/p>\n","protected":false},"author":6051,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"ep_exclude_from_search":false,"_classifai_error":"","footnotes":""},"post_tag":[],"product":[5226,2542,5227,2524],"content-type":[2421],"topic":[],"coauthors":[3546],"class_list":["post-33155","post","type-post","status-publish","format-standard","hentry","product-azure","product-azure-data-studio","product-sql","product-sql-server-management","content-type-announcements","review-flag-1593580427-503","review-flag-1-1593580431-15","review-flag-7-1593580462-294","review-flag-8-1593580467-480","review-flag-new-1593580247-437"],"yoast_head":"\nSQL Tools December release recap - Microsoft SQL Server Blog<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2020\/12\/17\/sql-tools-december-release-recap\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SQL Tools December release recap - Microsoft SQL Server Blog\" \/>\n<meta property=\"og:description\" content=\"The December releases of Azure Data Studio 1.25 and SQL Server Management Studio (SSMS) 18.8 are now generally available.\u00a0 Additionally, the mssql extension for Visual Studio Code has recently been updated to version 1.10.0. Read on to learn more about each of these updates and grab the latest versions of SSMS, Azure Data Studio, or\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2020\/12\/17\/sql-tools-december-release-recap\/\" \/>\n<meta property=\"og:site_name\" content=\"Microsoft SQL Server Blog\" \/>\n<meta property=\"article:publisher\" content=\"http:\/\/www.facebook.com\/sqlserver\" \/>\n<meta property=\"article:published_time\" content=\"2020-12-17T19:00:26+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-01-09T05:56:06+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2020\/12\/1131.png\" \/>\n<meta name=\"author\" content=\"Drew Skwiers-Koballa\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@SQLServer\" \/>\n<meta name=\"twitter:site\" content=\"@SQLServer\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Drew Skwiers-Koballa\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 min read\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2020\/12\/17\/sql-tools-december-release-recap\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2020\/12\/17\/sql-tools-december-release-recap\/\"},\"author\":[{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/author\/drew-skwiers-koballa\/\",\"@type\":\"Person\",\"@name\":\"Drew Skwiers-Koballa\"}],\"headline\":\"SQL Tools December release recap\",\"datePublished\":\"2020-12-17T19:00:26+00:00\",\"dateModified\":\"2024-01-09T05:56:06+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2020\/12\/17\/sql-tools-december-release-recap\/\"},\"wordCount\":714,\"publisher\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2020\/12\/17\/sql-tools-december-release-recap\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2020\/12\/1131.png\",\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2020\/12\/17\/sql-tools-december-release-recap\/\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2020\/12\/17\/sql-tools-december-release-recap\/\",\"name\":\"SQL Tools December release recap - Microsoft SQL Server Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2020\/12\/17\/sql-tools-december-release-recap\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2020\/12\/17\/sql-tools-december-release-recap\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2020\/12\/1131.png\",\"datePublished\":\"2020-12-17T19:00:26+00:00\",\"dateModified\":\"2024-01-09T05:56:06+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2020\/12\/17\/sql-tools-december-release-recap\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2020\/12\/17\/sql-tools-december-release-recap\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2020\/12\/17\/sql-tools-december-release-recap\/#primaryimage\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2020\/12\/1131.png\",\"contentUrl\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2020\/12\/1131.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2020\/12\/17\/sql-tools-december-release-recap\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"SQL Tools December release recap\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#website\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/\",\"name\":\"Microsoft SQL Server Blog\",\"description\":\"Official News from Microsoft\u2019s Information Platform\",\"publisher\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization\",\"name\":\"Microsoft SQL Server Blog\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2019\/08\/Microsoft-Logo.png\",\"contentUrl\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2019\/08\/Microsoft-Logo.png\",\"width\":259,\"height\":194,\"caption\":\"Microsoft SQL Server Blog\"},\"image\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"http:\/\/www.facebook.com\/sqlserver\",\"https:\/\/x.com\/SQLServer\",\"https:\/\/www.youtube.com\/user\/MSCloudOS\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"SQL Tools December release recap - Microsoft SQL Server Blog","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2020\/12\/17\/sql-tools-december-release-recap\/","og_locale":"en_US","og_type":"article","og_title":"SQL Tools December release recap - Microsoft SQL Server Blog","og_description":"The December releases of Azure Data Studio 1.25 and SQL Server Management Studio (SSMS) 18.8 are now generally available.\u00a0 Additionally, the mssql extension for Visual Studio Code has recently been updated to version 1.10.0. Read on to learn more about each of these updates and grab the latest versions of SSMS, Azure Data Studio, or","og_url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2020\/12\/17\/sql-tools-december-release-recap\/","og_site_name":"Microsoft SQL Server Blog","article_publisher":"http:\/\/www.facebook.com\/sqlserver","article_published_time":"2020-12-17T19:00:26+00:00","article_modified_time":"2024-01-09T05:56:06+00:00","og_image":[{"url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2020\/12\/1131.png"}],"author":"Drew Skwiers-Koballa","twitter_card":"summary_large_image","twitter_creator":"@SQLServer","twitter_site":"@SQLServer","twitter_misc":{"Written by":"Drew Skwiers-Koballa","Est. reading time":"3 min read"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2020\/12\/17\/sql-tools-december-release-recap\/#article","isPartOf":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2020\/12\/17\/sql-tools-december-release-recap\/"},"author":[{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/author\/drew-skwiers-koballa\/","@type":"Person","@name":"Drew Skwiers-Koballa"}],"headline":"SQL Tools December release recap","datePublished":"2020-12-17T19:00:26+00:00","dateModified":"2024-01-09T05:56:06+00:00","mainEntityOfPage":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2020\/12\/17\/sql-tools-december-release-recap\/"},"wordCount":714,"publisher":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization"},"image":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2020\/12\/17\/sql-tools-december-release-recap\/#primaryimage"},"thumbnailUrl":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2020\/12\/1131.png","inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2020\/12\/17\/sql-tools-december-release-recap\/","url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2020\/12\/17\/sql-tools-december-release-recap\/","name":"SQL Tools December release recap - Microsoft SQL Server Blog","isPartOf":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2020\/12\/17\/sql-tools-december-release-recap\/#primaryimage"},"image":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2020\/12\/17\/sql-tools-december-release-recap\/#primaryimage"},"thumbnailUrl":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2020\/12\/1131.png","datePublished":"2020-12-17T19:00:26+00:00","dateModified":"2024-01-09T05:56:06+00:00","breadcrumb":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2020\/12\/17\/sql-tools-december-release-recap\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2020\/12\/17\/sql-tools-december-release-recap\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2020\/12\/17\/sql-tools-december-release-recap\/#primaryimage","url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2020\/12\/1131.png","contentUrl":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2020\/12\/1131.png"},{"@type":"BreadcrumbList","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2020\/12\/17\/sql-tools-december-release-recap\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/"},{"@type":"ListItem","position":2,"name":"SQL Tools December release recap"}]},{"@type":"WebSite","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#website","url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/","name":"Microsoft SQL Server Blog","description":"Official News from Microsoft\u2019s Information Platform","publisher":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization","name":"Microsoft SQL Server Blog","url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2019\/08\/Microsoft-Logo.png","contentUrl":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2019\/08\/Microsoft-Logo.png","width":259,"height":194,"caption":"Microsoft SQL Server Blog"},"image":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#\/schema\/logo\/image\/"},"sameAs":["http:\/\/www.facebook.com\/sqlserver","https:\/\/x.com\/SQLServer","https:\/\/www.youtube.com\/user\/MSCloudOS"]}]}},"_links":{"self":[{"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/posts\/33155"}],"collection":[{"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/users\/6051"}],"replies":[{"embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/comments?post=33155"}],"version-history":[{"count":0,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/posts\/33155\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/media?parent=33155"}],"wp:term":[{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/post_tag?post=33155"},{"taxonomy":"product","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/product?post=33155"},{"taxonomy":"content-type","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/content-type?post=33155"},{"taxonomy":"topic","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/topic?post=33155"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/coauthors?post=33155"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}