{"id":25156,"date":"2018-10-03T09:00:00","date_gmt":"2018-10-03T16:00:00","guid":{"rendered":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/?p=25156"},"modified":"2018-10-03T13:17:17","modified_gmt":"2018-10-03T20:17:17","slug":"ssms-18-0-public-preview-released","status":"publish","type":"post","link":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/10\/03\/ssms-18-0-public-preview-released\/","title":{"rendered":"SSMS 18.0 public preview released"},"content":{"rendered":"<p>We are very excited to announce the public preview of SQL Server Management Studio 18.0. SSMS has been ported to the VS 2017 Isolated Shell, which brings with it many improvements to look and feel and accessibility. This release expands platform support to keep up with the announcements at Microsoft Ignite last week and includes bug fixes and feature updates across the board.<\/p>\n<p>Download your copy of <a href=\"https:\/\/aka.ms\/ssms\">SSMS 18 public preview<\/a> today.<\/p>\n<h2>New platform and feature support<\/h2>\n<ul>\n<li>Support for SQL 2019<\/li>\n<li>Support for Azure SQL Managed Instance<\/li>\n<li>Azure SQL Database support\n<ul>\n<li>SLO\/Edition<\/li>\n<li>Support for updated Azure SQL SKUs<\/li>\n<\/ul>\n<\/li>\n<li>Support for Always Encrypted with secure enclaves<\/li>\n<li>UTF-8 support on collation dialog<\/li>\n<\/ul>\n<h2>Shell improvements<\/h2>\n<ul>\n<li>SSMS is based on the new VS 2017 Isolated Shell. This means a modern shell that unlocks all the accessibility features from both SSMS and VS 2017.<\/li>\n<li>Smaller download size (~400 MB). This is less than half of what SSMS 17.x is.<\/li>\n<li>SSMS can be installed in a custom folder. Currently, this is only available on the command line setup. Pass the extra argument to SSMS-Setup-ENU.exe, SSMSInstallRoot = C:\\MyFolder<\/li>\n<li>High DPI enabled by default.<\/li>\n<li>Better support for multiple monitors to ensure dialogs and windows pop up on the expected monitor.<\/li>\n<li>Isolation from SQL Engine. SSMS does not share components with SQL engine anymore. More isolation from SQL engine allows for more frequent updates.<\/li>\n<li>Package Ids no longer needed to develop SSMS Extensions.<\/li>\n<\/ul>\n<h2>Existing feature improvements<\/h2>\n<ul>\n<li>Changed authentication mode from Storage Account Key to Azure AD.<\/li>\n<li>AUTOGROW_ALL_FILES config option for Filegroups.<\/li>\n<li>Removed \u201clightweight pooling\u201d and \u201cpriority boost\u201d options from GUI as these have been in the <a href=\"https:\/\/blogs.msdn.microsoft.com\/arvindsh\/2010\/01\/26\/priority-boost-details-and-why-its-not-recommended\/\">not recommended list<\/a> for a long time.<\/li>\n<li>Switched to \u201cWindows Credential Manager\u201d for connection dialog MRU passwords.<\/li>\n<li>Exposed the \u201cbackup checksum default\u201d property in the Default Settings Page under Server Properties dialog.<\/li>\n<li>Added actual time elapsed, actual vs estimated rows under Show Plan operator node, if they are available. This will allow actual plan to be consistent with Live Query Stats plan.<\/li>\n<li>Modified tooltip and added comment for Show Plan. Edit Query Button to indicate query text may be truncated if it\u2019s over 4000 characters.<\/li>\n<li>Added logic to display the \u201cMaterializer Operator (External Select)\u201d.<\/li>\n<li>Added new show plan attribute \u201cBatchModeOnRowStoreUSed\u201d to easily identify queries that are using the \u201cbatch-mode scan on rowstores\u201d feature.<\/li>\n<li>Rehash RTO (Estimated Recovery Time) and RPO (Estimated data loss) in SSMS AlwaysOn dashboard. Additional details here, <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/database-engine\/availability-groups\/windows\/monitor-performance-for-always-on-availability-groups?view=sql-server-2017\">Monitor performance for Always On Availability Groups<\/a>.<\/li>\n<li>SMO\n<ul>\n<li>Scripting performance improvements<\/li>\n<li>Extend SMO support for Resumable Index Creation<\/li>\n<li>Added new event on SMO objects (\u201cProperty Missing\u201d) to help application authors to detect SMO performance issues sooner<\/li>\n<li>Exposed new property DefaultBackupCheckSum on the Configuration object which maps to \u201cbackup checksum default\u201d in server configuration<\/li>\n<\/ul>\n<\/li>\n<li>Several bug fixes in the following areas in addition to crashes\/hangs:\n<ul>\n<li>XEvents<\/li>\n<li>SSMS Options<\/li>\n<li>SSMS Editor<\/li>\n<li>Object Explorer<\/li>\n<li>Backup\/Restore\/Attach\/Detach database<\/li>\n<li>General Azure SQL DB Support<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<p>For a full list of changes, see <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/ssms\/sql-server-management-studio-changelog-ssms?view=sql-server-2017\">Release Notes<\/a>.<\/p>\n<ul>\n<li>We have also deprecated some features, including:<\/li>\n<li>Database Diagram<\/li>\n<li>TSQL Debugger<\/li>\n<li>OSQL.exe<\/li>\n<li>Dreplay Admin UI<\/li>\n<li>Configuration Manager tools, SQL Server Configuration and Reporting Server Configuration Manager<\/li>\n<\/ul>\n<p>The product may be installed side-by-side with SSMS 17.x for testing purposes. As a reminder, the use of pre-GA software in production environments is not supported.<\/p>\n<p>SSMS will continue to be the flagship tool for managing and administering SQL Server on Windows environments. We will continue to make investments to fix bugs, optimize and modernize SSMS as new features get lighted up in SQL Server. <a href=\"https:\/\/aka.ms\/sqlfeedback\">We\u2019d love to hear from you with any questions, comments or feature suggestions<\/a>.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>We are very excited to announce the public preview of SQL Server Management Studio 18.0. SSMS has been ported to the VS 2017 Isolated Shell, which brings with it many improvements to look and feel and accessibility.<\/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":[2524,2418],"content-type":[2448],"topic":[2466],"coauthors":[2548],"class_list":["post-25156","post","type-post","status-publish","format-standard","hentry","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 18.0 public preview released - 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\/10\/03\/ssms-18-0-public-preview-released\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SSMS 18.0 public preview released - Microsoft SQL Server Blog\" \/>\n<meta property=\"og:description\" content=\"We are very excited to announce the public preview of SQL Server Management Studio 18.0. SSMS has been ported to the VS 2017 Isolated Shell, which brings with it many improvements to look and feel and accessibility.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/10\/03\/ssms-18-0-public-preview-released\/\" \/>\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-10-03T16:00:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2018-10-03T20:17:17+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=\"Dinakar Nethi\" \/>\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=\"Dinakar Nethi\" \/>\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\/10\/03\/ssms-18-0-public-preview-released\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/10\/03\/ssms-18-0-public-preview-released\/\"},\"author\":[{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/author\/dinakar-nethi\/\",\"@type\":\"Person\",\"@name\":\"Dinakar Nethi\"}],\"headline\":\"SSMS 18.0 public preview released\",\"datePublished\":\"2018-10-03T16:00:00+00:00\",\"dateModified\":\"2018-10-03T20:17:17+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/10\/03\/ssms-18-0-public-preview-released\/\"},\"wordCount\":595,\"commentCount\":14,\"publisher\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/10\/03\/ssms-18-0-public-preview-released\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/10\/03\/ssms-18-0-public-preview-released\/\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/10\/03\/ssms-18-0-public-preview-released\/\",\"name\":\"SSMS 18.0 public preview released - Microsoft SQL Server Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#website\"},\"datePublished\":\"2018-10-03T16:00:00+00:00\",\"dateModified\":\"2018-10-03T20:17:17+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/10\/03\/ssms-18-0-public-preview-released\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/10\/03\/ssms-18-0-public-preview-released\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/10\/03\/ssms-18-0-public-preview-released\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"SSMS 18.0 public preview released\"}]},{\"@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 18.0 public preview released - 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\/10\/03\/ssms-18-0-public-preview-released\/","og_locale":"en_US","og_type":"article","og_title":"SSMS 18.0 public preview released - Microsoft SQL Server Blog","og_description":"We are very excited to announce the public preview of SQL Server Management Studio 18.0. SSMS has been ported to the VS 2017 Isolated Shell, which brings with it many improvements to look and feel and accessibility.","og_url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/10\/03\/ssms-18-0-public-preview-released\/","og_site_name":"Microsoft SQL Server Blog","article_publisher":"http:\/\/www.facebook.com\/sqlserver","article_published_time":"2018-10-03T16:00:00+00:00","article_modified_time":"2018-10-03T20:17:17+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":"Dinakar Nethi","twitter_card":"summary_large_image","twitter_creator":"@SQLServer","twitter_site":"@SQLServer","twitter_misc":{"Written by":"Dinakar Nethi","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\/10\/03\/ssms-18-0-public-preview-released\/#article","isPartOf":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/10\/03\/ssms-18-0-public-preview-released\/"},"author":[{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/author\/dinakar-nethi\/","@type":"Person","@name":"Dinakar Nethi"}],"headline":"SSMS 18.0 public preview released","datePublished":"2018-10-03T16:00:00+00:00","dateModified":"2018-10-03T20:17:17+00:00","mainEntityOfPage":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/10\/03\/ssms-18-0-public-preview-released\/"},"wordCount":595,"commentCount":14,"publisher":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization"},"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/10\/03\/ssms-18-0-public-preview-released\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/10\/03\/ssms-18-0-public-preview-released\/","url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/10\/03\/ssms-18-0-public-preview-released\/","name":"SSMS 18.0 public preview released - Microsoft SQL Server Blog","isPartOf":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#website"},"datePublished":"2018-10-03T16:00:00+00:00","dateModified":"2018-10-03T20:17:17+00:00","breadcrumb":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/10\/03\/ssms-18-0-public-preview-released\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/10\/03\/ssms-18-0-public-preview-released\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/10\/03\/ssms-18-0-public-preview-released\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/"},{"@type":"ListItem","position":2,"name":"SSMS 18.0 public preview released"}]},{"@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\/25156","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=25156"}],"version-history":[{"count":0,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/posts\/25156\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/media?parent=25156"}],"wp:term":[{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/post_tag?post=25156"},{"taxonomy":"product","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/product?post=25156"},{"taxonomy":"content-type","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/content-type?post=25156"},{"taxonomy":"topic","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/topic?post=25156"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/coauthors?post=25156"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}