{"id":24907,"date":"2018-09-05T11:00:45","date_gmt":"2018-09-05T18:00:45","guid":{"rendered":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/?p=24907"},"modified":"2024-01-29T10:34:31","modified_gmt":"2024-01-29T18:34:31","slug":"ssms-17-9-is-now-available","status":"publish","type":"post","link":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/09\/05\/ssms-17-9-is-now-available\/","title":{"rendered":"SSMS 17.9 is now available"},"content":{"rendered":"<p><em>Update:\u00a0<a href=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2019\/06\/11\/sql-server-management-studio-ssms-18-1-is-now-generally-available\/\">SQL Server Management Studio 18.1<\/a>\u00a0is now generally available.\u00a0<\/em><\/p>\n<p><strong>We are excited to announce the release of SQL Server Management Studio (SSMS) 17.9!<\/strong><\/p>\n<p><a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/ssms\/download-sql-server-management-studio-ssms\">Download SSMS 17.9<\/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.9 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.9 comes with several new features:<\/p>\n<ul>\n<li><strong>ShowPlan improvements<\/strong><\/li>\n<li><strong>Azure SQL support for vCore SKUs<\/strong><\/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>ShowPlan improvements<\/h2>\n<p>Graphical Showplan now shows the new row mode memory grant feedback attributes when the feature is activated for a specific plan: <strong>IsMemoryGrantFeedbackAdjusted<\/strong> and <strong>LastRequestedMemory<\/strong> added to the <strong>MemoryGrantInfo<\/strong> query plan XML element. For more on row mode memory grant feedback, see <a href=\"https:\/\/na01.safelinks.protection.outlook.com\/?url=https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fsql%2Frelational-databases%2Fperformance%2Fadaptive-query-processing%3Fview%3Dsql-server-2017&amp;data=02%7C01%7C%7Cb20eacb1293441a4454b08d60a03a7ba%7C72f988bf86f141af91ab2d7cd011db47%7C1%7C0%7C636707408139873519&amp;sdata=SCyoNKRgjNqwEl8MC6Qks3a1HpJj6ypo6nzJR9IIrek%3D&amp;reserved=0\">Books Online<\/a>.<\/p>\n<p>For more on row mode memory grant feedback, view the <a href=\"https:\/\/docs.microsoft.com\/sql\/relational-databases\/performance\/adaptive-query-processing?view=sql-server-2017\">Adaptive Query Processing documentation.<\/a><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-24928 aligncenter\" src=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/09\/adaptive-query-processing.png\" alt=\"\" width=\"949\" height=\"351\" srcset=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/09\/adaptive-query-processing.webp 949w, https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/09\/adaptive-query-processing-300x111.webp 300w, https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/09\/adaptive-query-processing-768x284.webp 768w, https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/09\/adaptive-query-processing-330x122.webp 330w, https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/09\/adaptive-query-processing-800x296.webp 800w, https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/09\/adaptive-query-processing-400x148.webp 400w\" sizes=\"auto, (max-width: 949px) 100vw, 949px\" \/><\/p>\n<p style=\"text-align: center\"><a href=\"https:\/\/docs.microsoft.com\/sql\/relational-databases\/performance\/adaptive-query-processing?view=sql-server-2017\">Image from Adaptive Query Processing<\/a><\/p>\n<h2>Azure SQL support for vCore SKUs<\/h2>\n<p>Added support for vCore SKUs in Azure DB creation. For more information on vCore, <a href=\"https:\/\/azure.microsoft.com\/blog\/a-flexible-new-way-to-purchase-azure-sql-database\/\">check out the full blog.<\/a><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-24931 aligncenter\" src=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/09\/Azure-SQL-Database.png\" alt=\"\" width=\"1024\" height=\"428\" srcset=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/09\/Azure-SQL-Database.webp 1024w, https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/09\/Azure-SQL-Database-300x125.webp 300w, https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/09\/Azure-SQL-Database-768x321.webp 768w, https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/09\/Azure-SQL-Database-330x138.webp 330w, https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/09\/Azure-SQL-Database-800x334.webp 800w, https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/09\/Azure-SQL-Database-400x167.webp 400w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/p>\n<p style=\"text-align: center\"><a href=\"https:\/\/azure.microsoft.com\/blog\/a-flexible-new-way-to-purchase-azure-sql-database\/\">Image from Azure SQL DB blog<\/a><\/p>\n<h2>Bug fixes<\/h2>\n<p>In SSMS 17.9, there were many bug fixes.<\/p>\n<ul>\n<li><strong>Replication Monitor<\/strong>\n<ul>\n<li>Fixed an issue that was causing Replication Monitor (SqlMonitor.exe) not to start (<a href=\"https:\/\/feedback.azure.com\/forums\/908035-sql-server\/suggestions\/34791079\">User Voice item<\/a>)<\/li>\n<\/ul>\n<\/li>\n<li><strong>Import Flat File Wizard<\/strong>\n<ul>\n<li>Fixed the link to the help page for &#8220;Flat File Wizard&#8221; dialog<\/li>\n<li>Fixed issue where the wizard did not allow changing the destination table when the table already existed: this allows users to retry without having to exit the wizard, delete the failed table, and then re-enter the information into the wizard (<a href=\"https:\/\/feedback.azure.com\/forums\/908035-sql-server\/suggestions\/32896186\">User Voice item<\/a>)<\/li>\n<\/ul>\n<\/li>\n<li><strong>Import\/Export Data-Tier Application<\/strong>\n<ul>\n<li>Fixed an issue (in DacFx) which was causing the import of a .bacpac could fail with a message like &#8220;Error SQL72014: .Net SqlClient Data Provider: Msg 9108, Level 16, State 10, Line 1 This type of statistics is not supported to be incremental. &#8221; when dealing with tables with partitions defined and no indexes on the table<\/li>\n<\/ul>\n<\/li>\n<li><strong>Intellisense<\/strong>\n<ul>\n<li>Fixed an issue where Intellisense completion was not working when using AAD with MFA.<\/li>\n<\/ul>\n<\/li>\n<li><strong>Object Explorer<\/strong>\n<ul>\n<li>Fixed an issue where the &#8220;Filter Dialog&#8221; was displayed on random monitors instead of the monitor where SSMS was running (multi-monitor systems)<\/li>\n<\/ul>\n<\/li>\n<li><strong>Azure SQL<\/strong>\n<ul>\n<li>Fixed an issue related to enumeration of databases in the &#8220;Available Databases&#8221; where &#8220;master&#8221; was not displayed in the dropdown when connected to a specific database.<\/li>\n<li>Fixed an issue where trying to generate a script (&#8220;Data&#8221; or &#8220;Schema and Data&#8221;) was failing then connected to the SQL Azure DB using AAD with MFA.<\/li>\n<li>Fixed an issue in the View Designer (Views) where it was not possible to select &#8220;Add Tables&#8221; from the UI when connected to a SQL Azure DB.<\/li>\n<li>Fixed an issue where SSMS Query Editor was silently closing and reopening connections during MFA token renewal. This will prevent side effects unbeknownst to the user (like closing a transaction and never reopening again) from happening. The change adds the token expiration time to the properties window.<\/li>\n<li>Fixed an issue where SSMS was not enforcing password prompts for imported MSA accounts for AAD with MFA login<\/li>\n<\/ul>\n<\/li>\n<li><strong>Activity Monitor<\/strong>\n<ul>\n<li>Fixed an issue that was causing &#8220;Live Query Statistics&#8221; to hang when launched from Activity Monitor and SQL Authentication was used.<\/li>\n<\/ul>\n<\/li>\n<li><strong>Microsoft Azure integration<\/strong>\n<ul>\n<li>Fixed an issue where SSMS only shows the first 50 subscriptions (Always Encrypted dialogs, Backup\/Restore from URL dialogs, etc)<\/li>\n<li>Fixed an issue where SSMS was throwing an exception (&#8220;Index out of range&#8221;) while trying to log on to a Microsoft Azure account which did not have any storage account (in Restore Backup from URL dialog)<\/li>\n<\/ul>\n<\/li>\n<li><strong>Object Scripting<\/strong>\n<ul>\n<li>When scripting &#8220;Drop and Create&#8221;, SSMS now avoids generating dynamic T-SQL<\/li>\n<li>When scripting a database object, SSMS now does not generate script to set database scoped configurations, if they are set to default values<\/li>\n<\/ul>\n<\/li>\n<li><strong>Help<\/strong>\n<ul>\n<li>Fixed a long outstanding issue where &#8220;Help on Help&#8221; was not honoring the online\/offline mode<\/li>\n<li>When clicking on &#8220;Help | Community Projects and Samples&#8221; SSMS now opens the default browser that points to a Git page and shows no errors\/warnings due to the old browser being used<\/li>\n<\/ul>\n<\/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<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Update:\u00a0SQL Server Management Studio 18.1\u00a0is now generally available.\u00a0 We are excited to announce the release of SQL Server Management Studio (SSMS) 17.9! Download SSMS 17.9 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-24907","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.9 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\/09\/05\/ssms-17-9-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.9 is now available - Microsoft SQL Server Blog\" \/>\n<meta property=\"og:description\" content=\"Update:\u00a0SQL Server Management Studio 18.1\u00a0is now generally available.\u00a0 We are excited to announce the release of SQL Server Management Studio (SSMS) 17.9! Download SSMS 17.9 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\/09\/05\/ssms-17-9-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-09-05T18:00:45+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-01-29T18:34:31+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/09\/adaptive-query-processing.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=\"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\/2018\/09\/05\/ssms-17-9-is-now-available\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/09\/05\/ssms-17-9-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.9 is now available\",\"datePublished\":\"2018-09-05T18:00:45+00:00\",\"dateModified\":\"2024-01-29T18:34:31+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/09\/05\/ssms-17-9-is-now-available\/\"},\"wordCount\":724,\"commentCount\":3,\"publisher\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/09\/05\/ssms-17-9-is-now-available\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/09\/adaptive-query-processing.png\",\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/09\/05\/ssms-17-9-is-now-available\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/09\/05\/ssms-17-9-is-now-available\/\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/09\/05\/ssms-17-9-is-now-available\/\",\"name\":\"SSMS 17.9 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\/09\/05\/ssms-17-9-is-now-available\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/09\/05\/ssms-17-9-is-now-available\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/09\/adaptive-query-processing.png\",\"datePublished\":\"2018-09-05T18:00:45+00:00\",\"dateModified\":\"2024-01-29T18:34:31+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/09\/05\/ssms-17-9-is-now-available\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/09\/05\/ssms-17-9-is-now-available\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/09\/05\/ssms-17-9-is-now-available\/#primaryimage\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/09\/adaptive-query-processing.png\",\"contentUrl\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/09\/adaptive-query-processing.png\",\"width\":949,\"height\":351,\"caption\":\"a screenshot of a cell phone\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/09\/05\/ssms-17-9-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.9 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.9 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\/09\/05\/ssms-17-9-is-now-available\/","og_locale":"en_US","og_type":"article","og_title":"SSMS 17.9 is now available - Microsoft SQL Server Blog","og_description":"Update:\u00a0SQL Server Management Studio 18.1\u00a0is now generally available.\u00a0 We are excited to announce the release of SQL Server Management Studio (SSMS) 17.9! Download SSMS 17.9 and review the Release Notes to get started. SSMS 17.","og_url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/09\/05\/ssms-17-9-is-now-available\/","og_site_name":"Microsoft SQL Server Blog","article_publisher":"http:\/\/www.facebook.com\/sqlserver","article_published_time":"2018-09-05T18:00:45+00:00","article_modified_time":"2024-01-29T18:34:31+00:00","og_image":[{"url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/09\/adaptive-query-processing.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":"3 min read"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/09\/05\/ssms-17-9-is-now-available\/#article","isPartOf":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/09\/05\/ssms-17-9-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.9 is now available","datePublished":"2018-09-05T18:00:45+00:00","dateModified":"2024-01-29T18:34:31+00:00","mainEntityOfPage":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/09\/05\/ssms-17-9-is-now-available\/"},"wordCount":724,"commentCount":3,"publisher":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization"},"image":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/09\/05\/ssms-17-9-is-now-available\/#primaryimage"},"thumbnailUrl":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/09\/adaptive-query-processing.png","inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/09\/05\/ssms-17-9-is-now-available\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/09\/05\/ssms-17-9-is-now-available\/","url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/09\/05\/ssms-17-9-is-now-available\/","name":"SSMS 17.9 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\/09\/05\/ssms-17-9-is-now-available\/#primaryimage"},"image":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/09\/05\/ssms-17-9-is-now-available\/#primaryimage"},"thumbnailUrl":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/09\/adaptive-query-processing.png","datePublished":"2018-09-05T18:00:45+00:00","dateModified":"2024-01-29T18:34:31+00:00","breadcrumb":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/09\/05\/ssms-17-9-is-now-available\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/09\/05\/ssms-17-9-is-now-available\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/09\/05\/ssms-17-9-is-now-available\/#primaryimage","url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/09\/adaptive-query-processing.png","contentUrl":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/09\/adaptive-query-processing.png","width":949,"height":351,"caption":"a screenshot of a cell phone"},{"@type":"BreadcrumbList","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/09\/05\/ssms-17-9-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.9 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\/24907","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=24907"}],"version-history":[{"count":0,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/posts\/24907\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/media?parent=24907"}],"wp:term":[{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/post_tag?post=24907"},{"taxonomy":"product","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/product?post=24907"},{"taxonomy":"content-type","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/content-type?post=24907"},{"taxonomy":"topic","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/topic?post=24907"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/coauthors?post=24907"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}