{"id":31707,"date":"2020-07-22T11:00:15","date_gmt":"2020-07-22T18:00:15","guid":{"rendered":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/?p=31707"},"modified":"2024-01-22T22:51:26","modified_gmt":"2024-01-23T06:51:26","slug":"sql-server-management-studio-18-6-is-now-generally-available","status":"publish","type":"post","link":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2020\/07\/22\/sql-server-management-studio-18-6-is-now-generally-available\/","title":{"rendered":"SQL Server Management Studio 18.6 is now generally available\u00a0"},"content":{"rendered":"<p><span data-contrast=\"auto\">The release of SQL Server Management Studio (SSMS) 18.6 is now available<\/span><span data-contrast=\"auto\">\u00a0for download<\/span><span data-contrast=\"auto\">. Today<\/span><span data-contrast=\"auto\">\u00a0we\u2019re sharing some of the\u00a0<\/span><span data-contrast=\"auto\">updates from the release<\/span><span data-contrast=\"auto\">\u00a0and the\u00a0<\/span><span data-contrast=\"auto\">ongoing\u00a0<\/span><span data-contrast=\"auto\">work\u00a0<\/span><span data-contrast=\"auto\">in<\/span><span data-contrast=\"auto\">\u00a0SQL Server Management Studio.<\/span><span data-contrast=\"auto\">\u00a0<\/span><a href=\"https:\/\/aka.ms\/ssmsfullsetup\" target=\"_blank\" rel=\"noopener noreferrer\"><span data-contrast=\"none\">Download SSMS 18.6<\/span><\/a><span data-contrast=\"auto\">\u00a0and read on for some highlights from the\u00a0<\/span><a href=\"https:\/\/docs.microsoft.com\/sql\/ssms\/sql-server-management-studio-changelog-ssms?view=sqlallproducts-allversions\" target=\"_blank\" rel=\"noopener noreferrer\"><span data-contrast=\"none\">SSMS\u00a0<\/span><span data-contrast=\"none\">Release Notes<\/span><\/a><span data-contrast=\"auto\">.<\/span><span data-ccp-props=\"{&quot;201341983&quot;:0,&quot;335559739&quot;:160,&quot;335559740&quot;:259}\">\u00a0<\/span><\/p>\n<p><span data-contrast=\"auto\">The 18.6 release is the\u00a0<\/span><span data-contrast=\"auto\">second\u00a0<\/span><span data-contrast=\"auto\">major release of SSMS in 2020<\/span><span data-contrast=\"auto\">\u00a0and packs<\/span><span data-contrast=\"auto\">\u00a0several high\u00a0<\/span><span data-contrast=\"auto\">impact<\/span><span data-contrast=\"auto\">\u00a0<\/span><span data-contrast=\"auto\">changes<\/span><span data-contrast=\"auto\">, including a fix for\u00a0<\/span><span data-contrast=\"auto\">crashes in database diagram<\/span><span data-contrast=\"auto\">s.\u00a0<\/span><span data-contrast=\"auto\">Key fixes include:<\/span><span data-contrast=\"auto\">\u00a0<\/span><span data-ccp-props=\"{&quot;201341983&quot;:0,&quot;335559739&quot;:160,&quot;335559740&quot;:259}\">\u00a0<\/span><\/p>\n<ul>\n<li data-leveltext=\"\uf0b7\" data-font=\"Symbol\" data-listid=\"36\" data-aria-posinset=\"1\" data-aria-level=\"1\"><span data-contrast=\"auto\">Save to XEL file<\/span><span data-contrast=\"auto\"> error fix.<\/span><span data-ccp-props=\"{&quot;134233279&quot;:true,&quot;201341983&quot;:0,&quot;335559739&quot;:160,&quot;335559740&quot;:259}\">\u00a0<\/span><\/li>\n<li data-leveltext=\"\uf0b7\" data-font=\"Symbol\" data-listid=\"36\" data-aria-posinset=\"2\" data-aria-level=\"1\"><span data-contrast=\"auto\">B<\/span><span data-contrast=\"auto\">acpac<\/span><span data-contrast=\"auto\">\u00a0file<\/span><span data-contrast=\"auto\">\u00a0import<\/span><span data-contrast=\"auto\">\u00a0error<\/span><span data-contrast=\"auto\"> fix.<\/span><span data-ccp-props=\"{&quot;134233279&quot;:true,&quot;201341983&quot;:0,&quot;335559739&quot;:160,&quot;335559740&quot;:259}\">\u00a0<\/span><\/li>\n<li data-leveltext=\"\uf0b7\" data-font=\"Symbol\" data-listid=\"36\" data-aria-posinset=\"2\" data-aria-level=\"1\"><span data-contrast=\"auto\">Database diagrams<\/span><span data-contrast=\"auto\"> crash fix.<\/span><span data-ccp-props=\"{&quot;134233279&quot;:true,&quot;201341983&quot;:0,&quot;335559739&quot;:160,&quot;335559740&quot;:259}\">\u00a0<\/span><\/li>\n<li data-leveltext=\"\uf0b7\" data-font=\"Symbol\" data-listid=\"36\" data-aria-posinset=\"2\" data-aria-level=\"1\"><span data-contrast=\"auto\">Addressed sources o<\/span><span data-contrast=\"auto\">f three common application hangs.<\/span><span data-ccp-props=\"{&quot;134233279&quot;:true,&quot;201341983&quot;:0,&quot;335559739&quot;:160,&quot;335559740&quot;:259}\">\u00a0<\/span><\/li>\n<\/ul>\n<p><b><span data-contrast=\"auto\">Database diagrams<\/span><\/b><span data-ccp-props=\"{&quot;201341983&quot;:0,&quot;335559739&quot;:160,&quot;335559740&quot;:259}\">\u00a0<\/span><\/p>\n<p><span data-contrast=\"auto\">Database Designer is a visual tool<\/span><span data-contrast=\"auto\">\u00a0in SQL Server Management Studio<\/span><span data-contrast=\"auto\">\u00a0that allows you to design and visualize a\u00a0<\/span><span data-contrast=\"auto\">connected\u00a0<\/span><span data-contrast=\"auto\">database. <\/span><span data-contrast=\"auto\">This tool is helpful in both creating\u00a0<\/span><span data-contrast=\"auto\">tables as well as describing existing structures. For creating tables, <\/span><span data-contrast=\"auto\">database diagrams\u00a0<\/span><span data-contrast=\"auto\">facilitate<\/span><span data-contrast=\"auto\">\u00a0specifying column names and\u00a0<\/span><span data-contrast=\"auto\">data types<\/span><span data-contrast=\"auto\">\u00a0as well as\u00a0<\/span><span data-contrast=\"auto\">visually linking tables with foreign keys and other relationships.<\/span><span data-contrast=\"auto\">\u00a0<\/span><span data-contrast=\"auto\">When using database diagrams for describing existing\u00a0<\/span><span data-contrast=\"auto\">databases,<\/span><span data-contrast=\"auto\">\u00a0there are additional\u00a0<\/span><span data-contrast=\"auto\">tools<\/span><span data-contrast=\"auto\">\u00a0to assist. In addition to being able to\u00a0<\/span><span data-contrast=\"auto\">label<\/span> <span data-contrast=\"auto\">relationships<\/span><span data-contrast=\"auto\">\u00a0<\/span><span data-contrast=\"auto\">and display\u00a0<\/span><span data-contrast=\"auto\">differing levels of details about each table, general text annotations can be leveraged for additional commentary.<\/span><span data-ccp-props=\"{&quot;201341983&quot;:0,&quot;335559739&quot;:160,&quot;335559740&quot;:259}\">\u00a0<\/span><\/p>\n<p><span data-contrast=\"auto\">If you created or saved a diagram using SSMS 18.0 through 18.5.1, and that diagram includes a Text Annotation, you won&#8217;t be able to open that diagram in any version of SSMS. With this fix, SSMS 18.6 can open and save a diagram created by SSMS 17.9.1 and prior as well as by other SSMS 18.6 instances. SSMS 17.9.1 and prior versions will also be able to open the diagram after being saved by SSMS 18.6.<\/span><span data-ccp-props=\"{&quot;201341983&quot;:0,&quot;335559739&quot;:160,&quot;335559740&quot;:259}\">\u00a0<\/span><\/p>\n<p><span data-contrast=\"auto\">For more information on Database Diagrams in SQL Server Management Studio, please <\/span><a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/ssms\/visual-db-tools\/design-database-diagrams-visual-database-tools\"><span data-contrast=\"none\">check out the documentation<\/span><\/a><span data-contrast=\"auto\">.<\/span><span data-ccp-props=\"{&quot;201341983&quot;:0,&quot;335559739&quot;:160,&quot;335559740&quot;:259}\">\u00a0<\/span><\/p>\n<p><b><span data-contrast=\"auto\">Integration with Azure Data Studio<\/span><\/b><span data-ccp-props=\"{&quot;201341983&quot;:0,&quot;335559739&quot;:160,&quot;335559740&quot;:259}\">\u00a0<\/span><\/p>\n<p><span data-contrast=\"auto\">Azure Data Studio is\u00a0<\/span><span data-contrast=\"auto\">a multi-database, cross-platform desktop environment for data professionals using the family of on-premises and cloud data platforms on Windows, MacOS, and Linux<\/span><span data-contrast=\"auto\">.\u00a0<\/span><span data-contrast=\"auto\">SQL Server Management Studio<\/span><span data-contrast=\"auto\">\u00a0and Azure Data Studio are complementary tools<\/span><span data-contrast=\"auto\">\u00a0on a Windows\u00a0<\/span><span data-contrast=\"auto\">desktop,<\/span><span data-contrast=\"auto\">\u00a0especially for a database administrator\u2019s workload.<\/span><span data-contrast=\"auto\"> In recent releases, several points of integration between Azure Data Studio and\u00a0<\/span><span data-contrast=\"auto\">SSMS<\/span><span data-contrast=\"auto\">\u00a0have been introduced.<\/span><span data-ccp-props=\"{&quot;201341983&quot;:0,&quot;335559739&quot;:160,&quot;335559740&quot;:259}\">\u00a0<\/span><\/p>\n<ul>\n<li data-leveltext=\"\uf0b7\" data-font=\"Symbol\" data-listid=\"1\" data-aria-posinset=\"1\" data-aria-level=\"1\"><span data-contrast=\"auto\">SQL Server Management Studio<\/span><span data-contrast=\"auto\"> experiences.<\/span><span data-ccp-props=\"{&quot;134233279&quot;:true,&quot;201341983&quot;:0,&quot;335559739&quot;:160,&quot;335559740&quot;:259}\">\u00a0<\/span><\/li>\n<li data-leveltext=\"\uf0b7\" data-font=\"Symbol\" data-listid=\"1\" data-aria-posinset=\"1\" data-aria-level=\"1\"><span data-contrast=\"auto\">New query and new notebook\u00a0<\/span><span data-contrast=\"auto\">in Azure Data Studio\u00a0<\/span><span data-contrast=\"auto\">from\u00a0<\/span><span data-contrast=\"auto\">database and server nodes in object explorer.<\/span><span data-ccp-props=\"{&quot;134233279&quot;:true,&quot;201341983&quot;:0,&quot;335559739&quot;:160,&quot;335559740&quot;:259}\">\u00a0<\/span><\/li>\n<li data-leveltext=\"\uf0b7\" data-font=\"Symbol\" data-listid=\"1\" data-aria-posinset=\"1\" data-aria-level=\"1\"><span data-contrast=\"auto\">Generate\u00a0<\/span><span data-contrast=\"auto\">S<\/span><span data-contrast=\"auto\">cripts wizard\u00a0<\/span><span data-contrast=\"auto\">output<\/span><span data-contrast=\"auto\">\u00a0option for<\/span><span data-contrast=\"auto\">\u00a0<\/span><span data-contrast=\"auto\">a\u00a0<\/span><span data-contrast=\"auto\">notebook.<\/span><span data-ccp-props=\"{&quot;134233279&quot;:true,&quot;201341983&quot;:0,&quot;335559739&quot;:160,&quot;335559740&quot;:259}\">\u00a0<\/span><\/li>\n<li data-leveltext=\"\uf0b7\" data-font=\"Symbol\" data-listid=\"1\" data-aria-posinset=\"1\" data-aria-level=\"1\"><span data-contrast=\"auto\">Azure Data Studio<\/span><span data-contrast=\"auto\"> experiences.<\/span><span data-ccp-props=\"{&quot;134233279&quot;:true,&quot;201341983&quot;:0,&quot;335559739&quot;:160,&quot;335559740&quot;:259}\">\u00a0<\/span><\/li>\n<li data-leveltext=\"\uf0b7\" data-font=\"Symbol\" data-listid=\"1\" data-aria-posinset=\"1\" data-aria-level=\"1\"><a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/ssms\/scripting\/use-the-properties-window-in-management-studio\" target=\"_blank\" rel=\"noopener noreferrer\"><span data-contrast=\"none\">SSMS p<\/span><span data-contrast=\"none\">roperties<\/span><span data-contrast=\"none\">\u00a0dialog<\/span><\/a>.<span data-ccp-props=\"{&quot;134233279&quot;:true,&quot;201341983&quot;:0,&quot;335559739&quot;:160,&quot;335559740&quot;:259}\">\u00a0<\/span><\/li>\n<li data-leveltext=\"\uf0b7\" data-font=\"Symbol\" data-listid=\"1\" data-aria-posinset=\"1\" data-aria-level=\"1\"><a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/ssms\/scripting\/generate-and-publish-scripts-wizard\" target=\"_blank\" rel=\"noopener noreferrer\"><span data-contrast=\"none\">SSMS g<\/span><span data-contrast=\"none\">enerate s<\/span><span data-contrast=\"none\">cripts wizard<\/span><\/a>.<span data-ccp-props=\"{&quot;134233279&quot;:true,&quot;201341983&quot;:0,&quot;335559739&quot;:160,&quot;335559740&quot;:259}\">\u00a0<\/span><\/li>\n<\/ul>\n<p><span data-contrast=\"auto\">To enable the Azure Data Studio experiences\u00a0<\/span><span data-contrast=\"auto\">listed above, install the \u201c<\/span><span data-contrast=\"auto\">Database Admin<\/span><span data-contrast=\"auto\">istration<\/span><span data-contrast=\"auto\">\u00a0Tool Extensions for Windows<\/span><span data-contrast=\"auto\">\u201d<\/span><span data-contrast=\"auto\">\u00a0from the extension marketplace in Azure Data Studio.<\/span><span data-contrast=\"auto\">\u00a0Note: this functionality only works on Windows.<\/span><span data-ccp-props=\"{&quot;201341983&quot;:0,&quot;335559739&quot;:160,&quot;335559740&quot;:259}\">\u00a0<\/span><\/p>\n<p><b><span data-contrast=\"auto\">Import\u00a0<\/span><\/b><b><span data-contrast=\"auto\">Flat File Wizard<\/span><\/b><span data-ccp-props=\"{&quot;201341983&quot;:0,&quot;335559739&quot;:160,&quot;335559740&quot;:259}\">\u00a0<\/span><\/p>\n<p><span data-contrast=\"auto\">The f<\/span><span data-contrast=\"auto\">lat file import\u00a0<\/span><span data-contrast=\"auto\">wizard, powered by PROSE (<\/span><span data-contrast=\"auto\">Program Synthesis using Examples<\/span><span data-contrast=\"auto\">)<\/span><span data-contrast=\"auto\">,\u00a0<\/span><span data-contrast=\"auto\">is a powerful tool included in SSMS that\u00a0<\/span><span data-contrast=\"auto\">streamlines importing data by inferring column names and data types.<\/span><span data-contrast=\"auto\">\u00a0<\/span><span data-contrast=\"auto\">In this update, import from<\/span><span data-contrast=\"auto\">\u00a0<\/span><span data-contrast=\"auto\">fixed-width <\/span><span data-contrast=\"auto\">format files\u00a0<\/span><span data-contrast=\"auto\">and automatic detection\u00a0<\/span><span data-contrast=\"auto\">of<\/span><span data-contrast=\"auto\">\u00a0<\/span><span data-contrast=\"auto\">file\u00a0<\/span><span data-contrast=\"auto\">format<\/span><span data-contrast=\"auto\">\u00a0is now supported<\/span><span data-contrast=\"auto\">\u00a0as well as improved handling for escaped quotes<\/span><span data-contrast=\"auto\">. <\/span><span data-contrast=\"auto\">You can find the Im<\/span><span data-contrast=\"auto\">port Flat File wizard in object explorer at the database node level under tasks.<\/span><span data-contrast=\"auto\">\u00a0For more information on the import flat file wizard, please <\/span><a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/relational-databases\/import-export\/import-flat-file-wizard\" target=\"_blank\" rel=\"noopener noreferrer\"><span data-contrast=\"none\">check out the documentation<\/span><\/a><span data-contrast=\"auto\">.<\/span><span data-ccp-props=\"{&quot;201341983&quot;:0,&quot;335559739&quot;:160,&quot;335559740&quot;:259}\">\u00a0<\/span><\/p>\n<p><b><span data-contrast=\"auto\">Looking forward<\/span><\/b><span data-ccp-props=\"{&quot;201341983&quot;:0,&quot;335559739&quot;:160,&quot;335559740&quot;:259}\">\u00a0<\/span><\/p>\n<p><span data-contrast=\"auto\">To users who have submitted items, commented, or voted on SQL Server user feedback\u2014thank you. <\/span><span data-contrast=\"auto\">Work items for SSMS 18.6 were heavily influenced by user feedback.\u00a0<\/span><span data-contrast=\"auto\">Regular u<\/span><span data-contrast=\"auto\">pdates to SQL Server Management Studio will\u00a0<\/span><span data-contrast=\"auto\">continue to be released on a<\/span><span data-contrast=\"auto\">n approximately bi-monthly cadence<\/span><span data-contrast=\"auto\">\u00a0and\u00a0<\/span><span data-contrast=\"auto\">your feedback is an integral part of\u00a0<\/span><span data-contrast=\"auto\">our<\/span><span data-contrast=\"auto\">\u00a0planning.<\/span><span data-contrast=\"auto\">\u00a0<\/span><span data-contrast=\"auto\">Submit feedback anytime on\u00a0<\/span><a href=\"https:\/\/aka.ms\/sqlfeedback\"><span data-contrast=\"none\">User Voice for SQL Server<\/span><\/a><span data-contrast=\"auto\">.<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>The release of SQL Server Management Studio (SSMS) 18.6 is now available\u00a0for download. Today\u00a0we\u2019re sharing some of the\u00a0updates from the release\u00a0and the\u00a0ongoing\u00a0work\u00a0in\u00a0SQL Server Management Studio.\u00a0Download SSMS 18.6\u00a0and read on for some highlights from the\u00a0SSMS\u00a0Release Notes.\u00a0 The 18.6 release is the\u00a0second\u00a0major release of SSMS in 2020\u00a0and packs\u00a0several high\u00a0impact\u00a0changes, including a fix for\u00a0crashes in database diagrams.\u00a0Key fixes<\/p>\n","protected":false},"author":1457,"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,2448],"topic":[],"coauthors":[2487],"class_list":["post-31707","post","type-post","status-publish","format-standard","hentry","product-azure","product-azure-data-studio","product-sql","product-sql-server-management","content-type-announcements","content-type-updates","review-flag-1-1593580431-15","review-flag-5-1593580452-31","review-flag-6-1593580457-144","review-flag-9-1593580472-173","review-flag-new-1593580247-437"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v23.9 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>SQL Server Management Studio 18.6 is now generally available\u00a0 - 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\/07\/22\/sql-server-management-studio-18-6-is-now-generally-available\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SQL Server Management Studio 18.6 is now generally available\u00a0 - Microsoft SQL Server Blog\" \/>\n<meta property=\"og:description\" content=\"The release of SQL Server Management Studio (SSMS) 18.6 is now available\u00a0for download. Today\u00a0we\u2019re sharing some of the\u00a0updates from the release\u00a0and the\u00a0ongoing\u00a0work\u00a0in\u00a0SQL Server Management Studio.\u00a0Download SSMS 18.6\u00a0and read on for some highlights from the\u00a0SSMS\u00a0Release Notes.\u00a0 The 18.6 release is the\u00a0second\u00a0major release of SSMS in 2020\u00a0and packs\u00a0several high\u00a0impact\u00a0changes, including a fix for\u00a0crashes in database diagrams.\u00a0Key fixes\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2020\/07\/22\/sql-server-management-studio-18-6-is-now-generally-available\/\" \/>\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-07-22T18:00:15+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-01-23T06:51:26+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/08\/cropped-microsoft_logo_element.png\" \/>\n\t<meta property=\"og:image:width\" content=\"512\" \/>\n\t<meta property=\"og:image:height\" content=\"512\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"SQL Server Team\" \/>\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=\"SQL Server Team\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 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\/07\/22\/sql-server-management-studio-18-6-is-now-generally-available\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2020\/07\/22\/sql-server-management-studio-18-6-is-now-generally-available\/\"},\"author\":[{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/author\/sql-server-team\/\",\"@type\":\"Person\",\"@name\":\"SQL Server Team\"}],\"headline\":\"SQL Server Management Studio 18.6 is now generally available\u00a0\",\"datePublished\":\"2020-07-22T18:00:15+00:00\",\"dateModified\":\"2024-01-23T06:51:26+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2020\/07\/22\/sql-server-management-studio-18-6-is-now-generally-available\/\"},\"wordCount\":599,\"publisher\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization\"},\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2020\/07\/22\/sql-server-management-studio-18-6-is-now-generally-available\/\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2020\/07\/22\/sql-server-management-studio-18-6-is-now-generally-available\/\",\"name\":\"SQL Server Management Studio 18.6 is now generally available\u00a0 - Microsoft SQL Server Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#website\"},\"datePublished\":\"2020-07-22T18:00:15+00:00\",\"dateModified\":\"2024-01-23T06:51:26+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2020\/07\/22\/sql-server-management-studio-18-6-is-now-generally-available\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2020\/07\/22\/sql-server-management-studio-18-6-is-now-generally-available\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2020\/07\/22\/sql-server-management-studio-18-6-is-now-generally-available\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"SQL Server Management Studio 18.6 is now generally available\u00a0\"}]},{\"@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 Server Management Studio 18.6 is now generally available\u00a0 - 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\/07\/22\/sql-server-management-studio-18-6-is-now-generally-available\/","og_locale":"en_US","og_type":"article","og_title":"SQL Server Management Studio 18.6 is now generally available\u00a0 - Microsoft SQL Server Blog","og_description":"The release of SQL Server Management Studio (SSMS) 18.6 is now available\u00a0for download. Today\u00a0we\u2019re sharing some of the\u00a0updates from the release\u00a0and the\u00a0ongoing\u00a0work\u00a0in\u00a0SQL Server Management Studio.\u00a0Download SSMS 18.6\u00a0and read on for some highlights from the\u00a0SSMS\u00a0Release Notes.\u00a0 The 18.6 release is the\u00a0second\u00a0major release of SSMS in 2020\u00a0and packs\u00a0several high\u00a0impact\u00a0changes, including a fix for\u00a0crashes in database diagrams.\u00a0Key fixes","og_url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2020\/07\/22\/sql-server-management-studio-18-6-is-now-generally-available\/","og_site_name":"Microsoft SQL Server Blog","article_publisher":"http:\/\/www.facebook.com\/sqlserver","article_published_time":"2020-07-22T18:00:15+00:00","article_modified_time":"2024-01-23T06:51:26+00:00","og_image":[{"width":512,"height":512,"url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/08\/cropped-microsoft_logo_element.png","type":"image\/png"}],"author":"SQL Server Team","twitter_card":"summary_large_image","twitter_creator":"@SQLServer","twitter_site":"@SQLServer","twitter_misc":{"Written by":"SQL Server Team","Est. reading time":"2 min read"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2020\/07\/22\/sql-server-management-studio-18-6-is-now-generally-available\/#article","isPartOf":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2020\/07\/22\/sql-server-management-studio-18-6-is-now-generally-available\/"},"author":[{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/author\/sql-server-team\/","@type":"Person","@name":"SQL Server Team"}],"headline":"SQL Server Management Studio 18.6 is now generally available\u00a0","datePublished":"2020-07-22T18:00:15+00:00","dateModified":"2024-01-23T06:51:26+00:00","mainEntityOfPage":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2020\/07\/22\/sql-server-management-studio-18-6-is-now-generally-available\/"},"wordCount":599,"publisher":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization"},"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2020\/07\/22\/sql-server-management-studio-18-6-is-now-generally-available\/","url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2020\/07\/22\/sql-server-management-studio-18-6-is-now-generally-available\/","name":"SQL Server Management Studio 18.6 is now generally available\u00a0 - Microsoft SQL Server Blog","isPartOf":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#website"},"datePublished":"2020-07-22T18:00:15+00:00","dateModified":"2024-01-23T06:51:26+00:00","breadcrumb":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2020\/07\/22\/sql-server-management-studio-18-6-is-now-generally-available\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2020\/07\/22\/sql-server-management-studio-18-6-is-now-generally-available\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2020\/07\/22\/sql-server-management-studio-18-6-is-now-generally-available\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/"},{"@type":"ListItem","position":2,"name":"SQL Server Management Studio 18.6 is now generally available\u00a0"}]},{"@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\/31707"}],"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\/1457"}],"replies":[{"embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/comments?post=31707"}],"version-history":[{"count":0,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/posts\/31707\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/media?parent=31707"}],"wp:term":[{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/post_tag?post=31707"},{"taxonomy":"product","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/product?post=31707"},{"taxonomy":"content-type","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/content-type?post=31707"},{"taxonomy":"topic","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/topic?post=31707"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/coauthors?post=31707"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}