{"id":24622,"date":"2018-06-21T11:00:15","date_gmt":"2018-06-21T18:00:15","guid":{"rendered":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/?p=24622"},"modified":"2024-01-29T10:34:59","modified_gmt":"2024-01-29T18:34:59","slug":"ssms-17-8-is-now-available","status":"publish","type":"post","link":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/06\/21\/ssms-17-8-is-now-available\/","title":{"rendered":"SSMS 17.8 is now available"},"content":{"rendered":"<p><em>This post is co-authored by\u00a0Pam Lahoud, Senior Program Manager, SQL Server.<\/em><\/p>\n<p><strong>We are excited to announce the release of SQL Server Management Studio (SSMS) 17.8!<\/strong><\/p>\n<p><a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/ssms\/download-sql-server-management-studio-ssms\">Download SSMS 17.8<\/a> and review the <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/ssms\/sql-server-management-studio-changelog-ssms\">Release Notes<\/a> to get started.<\/p>\n<p>SSMS 17.8 provides support for almost all feature areas on SQL Server 2008 through the latest SQL Server 2017, which is now generally available.<\/p>\n<p>In addition to enhancements and bug fixes, SSMS 17.8 comes with several new features:<\/p>\n<ul>\n<li><strong>Database Properties | FileGroups: <\/strong>This improvement exposes the &#8220;AUTOGROW_ALL_FILES&#8221; configuration option for Filegroups.<\/li>\n<li><strong>SQL Editor: <\/strong>Improved experience with Intellisense in SQL Azure DB when the user lacks master access.<\/li>\n<li><strong>Scripting: <\/strong>General performance improvements, especially over high-latency connections.<\/li>\n<li><strong>Bug Fixes<\/strong><\/li>\n<\/ul>\n<p>View the <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/ssms\/sql-server-management-studio-changelog-ssms\">Release Notes<\/a> for more information.<\/p>\n<h2>Database Properties | FileGroups:<\/h2>\n<p>In this release of SQL Server Management Studio, we have introduced UI and scripting support for the AUTOGROW_ALL_FILES database filegroup property.\u00a0 This property was introduced in SQL Server 2016 to replace <u><a href=\"https:\/\/blogs.msdn.microsoft.com\/sql_server_team\/sql-server-2016-changes-in-default-behavior-for-autogrow-and-allocations-for-tempdb-and-user-databases\/\">trace flag 1117<\/a><\/u>, but it was only settable via T-SQL script.\u00a0 Now you can set the property via a checkbox in the Database Properties -&gt; Filegroups page:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-24625 aligncenter\" src=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/06\/image-1-sql-server.png\" alt=\"\" width=\"694\" height=\"628\" srcset=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/06\/image-1-sql-server.webp 694w, https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/06\/image-1-sql-server-300x271.webp 300w, https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/06\/image-1-sql-server-276x250.webp 276w, https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/06\/image-1-sql-server-330x299.webp 330w, https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/06\/image-1-sql-server-400x362.webp 400w\" sizes=\"auto, (max-width: 694px) 100vw, 694px\" \/><\/p>\n<p>You can also use the \u201cScript\u201d button to script out the change:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-24643 aligncenter\" src=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/06\/Script-button.png\" alt=\"\" width=\"694\" height=\"630\" srcset=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/06\/Script-button.webp 694w, https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/06\/Script-button-300x272.webp 300w, https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/06\/Script-button-275x250.webp 275w, https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/06\/Script-button-330x300.webp 330w, https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/06\/Script-button-400x363.webp 400w\" sizes=\"auto, (max-width: 694px) 100vw, 694px\" \/><\/p>\n<p>This will generate the following script:<\/p>\n<pre>USE [AdventureWorks2016_EXT]\u00a0\r\n\r\nGO\u00a0\r\n\r\ndeclare @autogrow bit\u00a0\r\n\r\nSELECT @autogrow=convert(bit, is_autogrow_all_files) FROM sys.filegroups WHERE name=N'PRIMARY'\u00a0\r\n\r\nif(@autogrow=0)\u00a0\r\n\r\nALTER DATABASE [AdventureWorks2016_EXT] MODIFY FILEGROUP [PRIMARY] AUTOGROW_ALL_FILES\u00a0\r\n\r\nGO<\/pre>\n<p>Scripting support has also been added to the \u201cGenerate Scripts\u201d task and the \u201cScript Database as\u201d context menu in the Object Explorer:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-24646 aligncenter\" src=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/06\/Script-Database-as.png\" alt=\"\" width=\"692\" height=\"348\" srcset=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/06\/Script-Database-as.webp 692w, https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/06\/Script-Database-as-300x151.webp 300w, https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/06\/Script-Database-as-330x166.webp 330w, https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/06\/Script-Database-as-400x201.webp 400w\" sizes=\"auto, (max-width: 692px) 100vw, 692px\" \/><\/p>\n<h2>Bug fixes:<\/h2>\n<p>In SSMS 17.8, there were many bug fixes.<\/p>\n<p>To highlight a few of these:<\/p>\n<ul>\n<li><strong>Maintenance Plans.<\/strong><br \/>\nFixed an issue when editing maintenance plans with Sql Authentication where &#8220;Notify Operator Task&#8221; was failing when using SQL authentication.<\/li>\n<li><strong>Scripting.<\/strong><br \/>\nFixed an issue where PostProcess actions in SMO lead to resource exhaustion and SQL login failures.<\/li>\n<li><strong>SMO.<\/strong><br \/>\nFixed an issue where Table.Alter() fails if adding a column with a default constraint and the table already has data. <a href=\"https:\/\/feedback.azure.com\/forums\/908035-sql-server\/suggestions\/32895625\">More details available here<\/a>.<\/li>\n<li><strong>Always Encrypted.<\/strong><br \/>\nFixed an issue (in DacFx) which was causing a lock timeout error when enabling Always Encrypted on a partitioned table.<\/li>\n<\/ul>\n<p>To learn more about other bug fixes covered in this release, check the <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/ssms\/sql-server-management-studio-changelog-ssms\">Release Notes<\/a>.<\/p>\n<h2>Call to action<\/h2>\n<p>Try it out and let us know what you think! You can message us on our Twitter <a href=\"https:\/\/twitter.com\/sqldatatools\">@sqldatatools<\/a> or reach out to Ken Van Hyning\u2019s twitter <a href=\"https:\/\/twitter.com\/sqltoolsguy\">@sqltoolsguy<\/a>.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>This post is co-authored by\u00a0Pam Lahoud, Senior Program Manager, SQL Server. We are excited to announce the release of SQL Server Management Studio (SSMS) 17.8! Download SSMS 17.8 and review the Release Notes to get started. SSMS 17.<\/p>\n","protected":false},"author":5562,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"ep_exclude_from_search":false,"_classifai_error":"","_classifai_text_to_speech_error":"","footnotes":""},"post_tag":[],"product":[5227,2406,2409,2524,2418],"content-type":[2448],"topic":[2466],"coauthors":[2487],"class_list":["post-24622","post","type-post","status-publish","format-standard","hentry","product-sql","product-sql-server-2017","product-sql-server-2017-on-linux","product-sql-server-management","product-sql-server-on-linux","content-type-updates","topic-developer"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.2 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>SSMS 17.8 is now available - 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\/2018\/06\/21\/ssms-17-8-is-now-available\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SSMS 17.8 is now available - Microsoft SQL Server Blog\" \/>\n<meta property=\"og:description\" content=\"This post is co-authored by\u00a0Pam Lahoud, Senior Program Manager, SQL Server. We are excited to announce the release of SQL Server Management Studio (SSMS) 17.8! Download SSMS 17.8 and review the Release Notes to get started. SSMS 17.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/06\/21\/ssms-17-8-is-now-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=\"2018-06-21T18:00:15+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-01-29T18:34:59+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/06\/image-1-sql-server.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\/2018\/06\/21\/ssms-17-8-is-now-available\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/06\/21\/ssms-17-8-is-now-available\/\"},\"author\":[{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/author\/sql-server-team\/\",\"@type\":\"Person\",\"@name\":\"SQL Server Team\"}],\"headline\":\"SSMS 17.8 is now available\",\"datePublished\":\"2018-06-21T18:00:15+00:00\",\"dateModified\":\"2024-01-29T18:34:59+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/06\/21\/ssms-17-8-is-now-available\/\"},\"wordCount\":370,\"commentCount\":5,\"publisher\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/06\/21\/ssms-17-8-is-now-available\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/06\/image-1-sql-server.png\",\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/06\/21\/ssms-17-8-is-now-available\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/06\/21\/ssms-17-8-is-now-available\/\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/06\/21\/ssms-17-8-is-now-available\/\",\"name\":\"SSMS 17.8 is now available - 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\/2018\/06\/21\/ssms-17-8-is-now-available\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/06\/21\/ssms-17-8-is-now-available\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/06\/image-1-sql-server.png\",\"datePublished\":\"2018-06-21T18:00:15+00:00\",\"dateModified\":\"2024-01-29T18:34:59+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/06\/21\/ssms-17-8-is-now-available\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/06\/21\/ssms-17-8-is-now-available\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/06\/21\/ssms-17-8-is-now-available\/#primaryimage\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/06\/image-1-sql-server.png\",\"contentUrl\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/06\/image-1-sql-server.png\",\"width\":694,\"height\":628,\"caption\":\"a screenshot of a computer\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/06\/21\/ssms-17-8-is-now-available\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"SSMS 17.8 is now available\"}]},{\"@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":"SSMS 17.8 is now available - 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\/2018\/06\/21\/ssms-17-8-is-now-available\/","og_locale":"en_US","og_type":"article","og_title":"SSMS 17.8 is now available - Microsoft SQL Server Blog","og_description":"This post is co-authored by\u00a0Pam Lahoud, Senior Program Manager, SQL Server. We are excited to announce the release of SQL Server Management Studio (SSMS) 17.8! Download SSMS 17.8 and review the Release Notes to get started. SSMS 17.","og_url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/06\/21\/ssms-17-8-is-now-available\/","og_site_name":"Microsoft SQL Server Blog","article_publisher":"http:\/\/www.facebook.com\/sqlserver","article_published_time":"2018-06-21T18:00:15+00:00","article_modified_time":"2024-01-29T18:34:59+00:00","og_image":[{"url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/06\/image-1-sql-server.png","type":"","width":"","height":""}],"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\/2018\/06\/21\/ssms-17-8-is-now-available\/#article","isPartOf":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/06\/21\/ssms-17-8-is-now-available\/"},"author":[{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/author\/sql-server-team\/","@type":"Person","@name":"SQL Server Team"}],"headline":"SSMS 17.8 is now available","datePublished":"2018-06-21T18:00:15+00:00","dateModified":"2024-01-29T18:34:59+00:00","mainEntityOfPage":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/06\/21\/ssms-17-8-is-now-available\/"},"wordCount":370,"commentCount":5,"publisher":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization"},"image":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/06\/21\/ssms-17-8-is-now-available\/#primaryimage"},"thumbnailUrl":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/06\/image-1-sql-server.png","inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/06\/21\/ssms-17-8-is-now-available\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/06\/21\/ssms-17-8-is-now-available\/","url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/06\/21\/ssms-17-8-is-now-available\/","name":"SSMS 17.8 is now available - 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\/2018\/06\/21\/ssms-17-8-is-now-available\/#primaryimage"},"image":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/06\/21\/ssms-17-8-is-now-available\/#primaryimage"},"thumbnailUrl":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/06\/image-1-sql-server.png","datePublished":"2018-06-21T18:00:15+00:00","dateModified":"2024-01-29T18:34:59+00:00","breadcrumb":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/06\/21\/ssms-17-8-is-now-available\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/06\/21\/ssms-17-8-is-now-available\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/06\/21\/ssms-17-8-is-now-available\/#primaryimage","url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/06\/image-1-sql-server.png","contentUrl":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/06\/image-1-sql-server.png","width":694,"height":628,"caption":"a screenshot of a computer"},{"@type":"BreadcrumbList","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/06\/21\/ssms-17-8-is-now-available\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/"},{"@type":"ListItem","position":2,"name":"SSMS 17.8 is now available"}]},{"@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"]}]}},"msxcm_display_generated_audio":false,"msxcm_animated_featured_image":null,"_links":{"self":[{"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/posts\/24622","targetHints":{"allow":["GET"]}}],"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\/5562"}],"replies":[{"embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/comments?post=24622"}],"version-history":[{"count":0,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/posts\/24622\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/media?parent=24622"}],"wp:term":[{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/post_tag?post=24622"},{"taxonomy":"product","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/product?post=24622"},{"taxonomy":"content-type","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/content-type?post=24622"},{"taxonomy":"topic","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/topic?post=24622"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/coauthors?post=24622"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}