{"id":26929,"date":"2019-03-28T11:00:09","date_gmt":"2019-03-28T18:00:09","guid":{"rendered":""},"modified":"2019-03-27T17:42:25","modified_gmt":"2019-03-28T00:42:25","slug":"sql-server-management-studio-18-0-release-candidate-1-is-now-available","status":"publish","type":"post","link":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2019\/03\/28\/sql-server-management-studio-18-0-release-candidate-1-is-now-available\/","title":{"rendered":"SQL Server Management Studio 18.0 Release Candidate 1 is now available"},"content":{"rendered":"<p>As we get closer to the General Availability of SQL Server Management Studio (SSMS) 18, we have decided to have a quick release of the Release Candidate (RC) build.<\/p>\n<p>You can <a href=\"https:\/\/go.microsoft.com\/fwlink\/?linkid=2085742\">download SSMS 18.0 RC1<\/a> today and for more details on what\u2019s included, please see the <a href=\"https:\/\/docs.microsoft.com\/sql\/ssms\/sql-server-management-studio-changelog-ssms?view=sqlallproducts-allversions\">Release Notes<\/a>.<\/p>\n<p>This SQL Server Management Studio 18 RC1 build has some important updates as seen below:<\/p>\n<h2>SSMS improvements:<\/h2>\n<ul>\n<li>Enabling XMLA endpoint connectivity to Power BI datasets: XMLA endpoints provide access to the Analysis Services engine in the Power BI Service. This allows tools such as SSMS and SQL Profiler to connect to Power BI datasets for monitoring, management, and debugging etc. For more details, please review <a href=\"https:\/\/go.microsoft.com\/fwlink\/?linkid=2085204\">XMLA endpoint connectivity<\/a> in the Power BI blog.<\/li>\n<\/ul>\n<h3>SQL Server Management Objects (SMO)<\/h3>\n<ul>\n<li>Added cascade delete support to &#8220;Edge Constraints&#8221; in both SMO and SSMS.<\/li>\n<li>Added support for data classification &#8220;read-write&#8221; permissions.<\/li>\n<\/ul>\n<h3>Audit Files<\/h3>\n<ul>\n<li>Updated the list of known audit actions to include FEATURE RESTRICTION ADD\/CHANGE GROUP\/DROP<\/li>\n<\/ul>\n<p>In addition, we also have several bug fixes in the following areas:<\/p>\n<h4>SSMS:<\/h4>\n<ul>\n<li>Fixed an issue which was preventing MFA authentication when user ids belonged to multiple tenants.<\/li>\n<li>Fixed an issue where the Perf Dashboard Report was reporting PAGELATCH and PAGEIOLATCH waits that could not found in sub-reports.<\/li>\n<li>Fixed an issue which resulted in an &#8220;Index out of range&#8221; exception when clicking on the grid.<\/li>\n<li>Fixed an issue where the grid result background color was being ignored. For more details, you can review <a href=\"https:\/\/feedback.azure.com\/forums\/908035\/suggestions\/32895916\">Azure feedback<\/a>.<\/li>\n<\/ul>\n<h4>Managed Instance support<\/h4>\n<ul>\n<li>Improved the display of Managed Instances server specific properties (hardware generation, service tier, storage used, and reserved).<\/li>\n<\/ul>\n<h4>Azure SQL Database<\/h4>\n<ul>\n<li>Fixed an issue where Service Level Objectives (SLO) were hard-coded, making it harder for SSMS to support newer SQL Azure SLOs. Now users can sign in to Azure and allow SSMS to retrieve all the applicable SLO data (Edition and Max Size).<\/li>\n<\/ul>\n<p>For a full list of changes, please see the <a href=\"https:\/\/docs.microsoft.com\/sql\/ssms\/sql-server-management-studio-changelog-ssms?view=sqlallproducts-allversions\">Release Notes<\/a>.<\/p>\n<p>As usual, if you have a previous version of SSMS 18.0 preview, you will need to uninstall it first. SSMS 18.0 RC1 can 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>We\u2019d love to hear from you!<a href=\"https:\/\/aka.ms\/sqlfeedback\"> Please let us know if you have any questions, comments or feature suggestions<\/a>.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>As we get closer to the General Availability of SQL Server Management Studio (SSMS) 18, we have decided to have a quick release of the Release Candidate (RC) build. You can download SSMS 18.0 RC1 today and for more details on what\u2019s included, please see the Release Notes.<\/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":[2397,2524],"content-type":[2448],"topic":[],"coauthors":[2548],"class_list":["post-26929","post","type-post","status-publish","format-standard","hentry","product-power-bi","product-sql-server-management","content-type-updates"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.2 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>SQL Server Management Studio 18.0 Release Candidate 1 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\/2019\/03\/28\/sql-server-management-studio-18-0-release-candidate-1-is-now-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.0 Release Candidate 1 is now available - Microsoft SQL Server Blog\" \/>\n<meta property=\"og:description\" content=\"As we get closer to the General Availability of SQL Server Management Studio (SSMS) 18, we have decided to have a quick release of the Release Candidate (RC) build. You can download SSMS 18.0 RC1 today and for more details on what\u2019s included, please see the Release Notes.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2019\/03\/28\/sql-server-management-studio-18-0-release-candidate-1-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=\"2019-03-28T18:00:09+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\/2019\/03\/28\/sql-server-management-studio-18-0-release-candidate-1-is-now-available\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2019\/03\/28\/sql-server-management-studio-18-0-release-candidate-1-is-now-available\/\"},\"author\":[{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/author\/dinakar-nethi\/\",\"@type\":\"Person\",\"@name\":\"Dinakar Nethi\"}],\"headline\":\"SQL Server Management Studio 18.0 Release Candidate 1 is now available\",\"datePublished\":\"2019-03-28T18:00:09+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2019\/03\/28\/sql-server-management-studio-18-0-release-candidate-1-is-now-available\/\"},\"wordCount\":394,\"commentCount\":3,\"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\/2019\/03\/28\/sql-server-management-studio-18-0-release-candidate-1-is-now-available\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2019\/03\/28\/sql-server-management-studio-18-0-release-candidate-1-is-now-available\/\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2019\/03\/28\/sql-server-management-studio-18-0-release-candidate-1-is-now-available\/\",\"name\":\"SQL Server Management Studio 18.0 Release Candidate 1 is now available - Microsoft SQL Server Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#website\"},\"datePublished\":\"2019-03-28T18:00:09+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2019\/03\/28\/sql-server-management-studio-18-0-release-candidate-1-is-now-available\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2019\/03\/28\/sql-server-management-studio-18-0-release-candidate-1-is-now-available\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2019\/03\/28\/sql-server-management-studio-18-0-release-candidate-1-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\":\"SQL Server Management Studio 18.0 Release Candidate 1 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":"SQL Server Management Studio 18.0 Release Candidate 1 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\/2019\/03\/28\/sql-server-management-studio-18-0-release-candidate-1-is-now-available\/","og_locale":"en_US","og_type":"article","og_title":"SQL Server Management Studio 18.0 Release Candidate 1 is now available - Microsoft SQL Server Blog","og_description":"As we get closer to the General Availability of SQL Server Management Studio (SSMS) 18, we have decided to have a quick release of the Release Candidate (RC) build. You can download SSMS 18.0 RC1 today and for more details on what\u2019s included, please see the Release Notes.","og_url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2019\/03\/28\/sql-server-management-studio-18-0-release-candidate-1-is-now-available\/","og_site_name":"Microsoft SQL Server Blog","article_publisher":"http:\/\/www.facebook.com\/sqlserver","article_published_time":"2019-03-28T18:00:09+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\/2019\/03\/28\/sql-server-management-studio-18-0-release-candidate-1-is-now-available\/#article","isPartOf":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2019\/03\/28\/sql-server-management-studio-18-0-release-candidate-1-is-now-available\/"},"author":[{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/author\/dinakar-nethi\/","@type":"Person","@name":"Dinakar Nethi"}],"headline":"SQL Server Management Studio 18.0 Release Candidate 1 is now available","datePublished":"2019-03-28T18:00:09+00:00","mainEntityOfPage":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2019\/03\/28\/sql-server-management-studio-18-0-release-candidate-1-is-now-available\/"},"wordCount":394,"commentCount":3,"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\/2019\/03\/28\/sql-server-management-studio-18-0-release-candidate-1-is-now-available\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2019\/03\/28\/sql-server-management-studio-18-0-release-candidate-1-is-now-available\/","url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2019\/03\/28\/sql-server-management-studio-18-0-release-candidate-1-is-now-available\/","name":"SQL Server Management Studio 18.0 Release Candidate 1 is now available - Microsoft SQL Server Blog","isPartOf":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#website"},"datePublished":"2019-03-28T18:00:09+00:00","breadcrumb":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2019\/03\/28\/sql-server-management-studio-18-0-release-candidate-1-is-now-available\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2019\/03\/28\/sql-server-management-studio-18-0-release-candidate-1-is-now-available\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2019\/03\/28\/sql-server-management-studio-18-0-release-candidate-1-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":"SQL Server Management Studio 18.0 Release Candidate 1 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\/26929","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=26929"}],"version-history":[{"count":0,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/posts\/26929\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/media?parent=26929"}],"wp:term":[{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/post_tag?post=26929"},{"taxonomy":"product","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/product?post=26929"},{"taxonomy":"content-type","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/content-type?post=26929"},{"taxonomy":"topic","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/topic?post=26929"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/coauthors?post=26929"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}