{"id":24577,"date":"2018-06-20T11:00:22","date_gmt":"2018-06-20T18:00:22","guid":{"rendered":""},"modified":"2024-01-29T10:35:09","modified_gmt":"2024-01-29T18:35:09","slug":"the-june-release-of-sql-operations-studio-is-now-available","status":"publish","type":"post","link":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/06\/20\/the-june-release-of-sql-operations-studio-is-now-available\/","title":{"rendered":"The June release of SQL Operations Studio is now available"},"content":{"rendered":"<h4><b>UPDATE: <\/b>SQL Operations Studio is now <a href=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/09\/25\/azure-data-studio-for-sql-server\/\">GA and renamed to Azure Data Studio<\/a>. For the most up to date information please visit our monthly <a href=\"https:\/\/aka.ms\/azdata-blog\">Azure Data Studio blog post<\/a> and <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/azure-data-studio\/download?view=sql-server-2017\">download and install the latest release here<\/a>.<\/h4>\n<hr \/>\n<p><strong>We are excited to announce the June release of <a href=\"https:\/\/github.com\/microsoft\/sqlopsstudio\/\">SQL Operations Studio<\/a> is now available.<\/strong><\/p>\n<p><a href=\"https:\/\/docs.microsoft.com\/sql\/sql-operations-studio\/download\">Download SQL Operations Studio<\/a> and review the <a href=\"https:\/\/docs.microsoft.com\/sql\/sql-operations-studio\/release-notes\">Release Notes<\/a> to get started.<\/p>\n<p>SQL Operations Studio is a data management tool that enables you to work with SQL Server, Azure SQL DB and SQL DW from Windows, macOS and Linux. To learn more, visit our <a href=\"https:\/\/github.com\/microsoft\/sqlopsstudio\/\">GitHub<\/a>.<\/p>\n<p>SQL Operations Studio was announced for Public Preview on November 15th at Connect(), and this June release is the seventh major update since the announcement. If you missed it, the <a href=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/05\/08\/the-may-release-of-sql-operations-studio-is-now-available\/\">May release announcement can be viewed here<\/a>.<\/p>\n<p>The June public preview release is focused on improving our Extensibility experience with the release of new extensions as well as addressing top GitHub issues.<\/p>\n<p>Highlights for this build include the following.<\/p>\n<ul>\n<li>SQL Server Profiler for SQL Operations Studio Preview extension initial release<\/li>\n<li>Azure SQL Data Warehouse extension<\/li>\n<li>Edit Data Filtering and Sorting<\/li>\n<li>SQL Server Agent for SQL Operations Studio Preview extension enhancements for Jobs and Job History views<\/li>\n<li>Build your own SQL Ops Studio extension<\/li>\n<li>Visual Studio Code Refresh<\/li>\n<li>Fix GitHub Issues<\/li>\n<\/ul>\n<p>For complete updates, refer to the <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/sql-operations-studio\/release-notes?view=sql-server-2017\">Release Notes<\/a>.<\/p>\n<h2>SQL Server Profiler for SQL Operations Studio <em>Preview<\/em><\/h2>\n<p>The SQL Server Profiler for SQL Operations Studio <em>Preview<\/em>\u00a0extension is now available in the Extension Manager. This is the initial preview release for a new lightweight XEvent-based profiler. The SQL Server Profiler extension makes it simple to quickly trace server activity for troubleshooting and monitoring.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-24580 aligncenter\" src=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/06\/sql-ops-studio-preview.png\" alt=\"\" width=\"1431\" height=\"1064\" srcset=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/06\/sql-ops-studio-preview.webp 1431w, https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/06\/sql-ops-studio-preview-300x223.webp 300w, https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/06\/sql-ops-studio-preview-1024x761.webp 1024w, https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/06\/sql-ops-studio-preview-768x571.webp 768w, https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/06\/sql-ops-studio-preview-330x245.webp 330w, https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/06\/sql-ops-studio-preview-800x595.webp 800w, https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/06\/sql-ops-studio-preview-400x297.webp 400w\" sizes=\"auto, (max-width: 1431px) 100vw, 1431px\" \/><\/p>\n<p>If\u00a0you want to try out the SQL Server Profiler extension, follow these instructions:<\/p>\n<ol>\n<li><a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/sql-operations-studio\/extensions?view=sql-server-2017\">Install the extension from the Extensions Manager.<\/a><\/li>\n<li>After you reload SQL Operations Studio, press <strong>Ctrl+Shift+P<\/strong> or open the Command Palette from the Gear icon on the bottom left.<\/li>\n<li>Type \u2018Profiler\u2019 and press Enter on \u2018Profiler: New Profiler\u2019<\/li>\n<li>Press start to see your Extended Events (view gif below)<\/li>\n<\/ol>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-24613 aligncenter\" src=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/06\/profiler.gif\" alt=\"\" width=\"946\" height=\"532\" \/><\/p>\n<p>We&#8217;ll continue to enhance this extension over the next couple releases. This is still a preview version and we would love to hear initial feedback from the community.<\/p>\n<p>Shortly after this blog publishes, an issue will be opened in <a href=\"https:\/\/github.com\/microsoft\/sqlopsstudio\/issues\">GitHub issues<\/a> where we will share our design process for each screen for SQL Server Profiler. We welcome community input there as we work on improving SQL Server Profiler in SQL Operations Studio.<\/p>\n<h2>Azure SQL Data Warehouse Extension<\/h2>\n<p>Last month, the Azure SQL Data Warehouse team blogged on creating a <a href=\"https:\/\/azure.microsoft.com\/en-us\/blog\/extract-management-insights-from-sql-data-warehouse-with-sql-operations-studio\/\">customizable management experience<\/a> with SQL Operations Studio. Instead of asking new users to manually add JSON snippets in Settings, we reached out to the DW team to see if they would be interested in building an extension to improve acquisition for users. After working with us <a href=\"https:\/\/github.com\/microsoft\/sqlopsstudio\/wiki\/Microsoft-Build-lab\">on building a custom insight extension<\/a>, the team is excited to announce the preview release of the Azure SQL Data Warehouse Extension! You can now seamlessly install the extension from the SQL Operations Studio Extensions Manager surfacing a pre-built dashboard for your data warehouse.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-24586 aligncenter\" src=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/06\/pre-built-dashboard-for-your-data-warehouse.png\" alt=\"\" width=\"779\" height=\"314\" srcset=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/06\/pre-built-dashboard-for-your-data-warehouse.webp 779w, https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/06\/pre-built-dashboard-for-your-data-warehouse-300x121.webp 300w, https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/06\/pre-built-dashboard-for-your-data-warehouse-768x310.webp 768w, https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/06\/pre-built-dashboard-for-your-data-warehouse-330x133.webp 330w, https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/06\/pre-built-dashboard-for-your-data-warehouse-400x161.webp 400w\" sizes=\"auto, (max-width: 779px) 100vw, 779px\" \/><\/p>\n<p>Once you install the extension, you simply make a connection to your SQL DW instance, view the server dashboard, and you can see the extension as a tab.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-24592 aligncenter\" src=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/06\/sql-dashboard.png\" alt=\"\" width=\"995\" height=\"376\" srcset=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/06\/sql-dashboard.webp 995w, https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/06\/sql-dashboard-300x113.webp 300w, https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/06\/sql-dashboard-768x290.webp 768w, https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/06\/sql-dashboard-330x125.webp 330w, https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/06\/sql-dashboard-800x302.webp 800w, https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/06\/sql-dashboard-400x151.webp 400w\" sizes=\"auto, (max-width: 995px) 100vw, 995px\" \/><\/p>\n<p>Insight widgets are generated by using T-SQL scripts embedded within SQL Operations Studio. All monitoring scripts are uploaded to the following GitHub repo: <a href=\"https:\/\/github.com\/Microsoft\/sql-data-warehouse-samples\/tree\/master\/samples\/sqlops\/MonitoringScripts\">SQL Data Warehouse samples<\/a>.<\/p>\n<p>We are looking to improve this extension and would love to hear your feedback to improve this extension. Please feel free to contribute or provide <a href=\"https:\/\/github.com\/Microsoft\/sql-data-warehouse-samples\/issues\">feedback<\/a>.<\/p>\n<h2>Edit data filtering and sorting<\/h2>\n<p>Edit data on a table opens the top 200 rows by default. To modify the query, click on the &#8220;Show SQL Pane&#8221; toolbar button to open the query pane. The query can be modified in the SQL editor pane to filter or sort the resultset. Check out the gif below to see this feature in action.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-24583 aligncenter\" src=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/06\/edit-data-filter.gif\" alt=\"\" width=\"1000\" height=\"534\" \/><\/p>\n<h2>Build your own extension<\/h2>\n<p>In the last couple releases, you may have noticed how our Extensions Manager has grown with extensions created by Azure SQL Data Warehouse, Redgate, and community members. We want to continue to work with the community and our partners to create SQL Operations Studio extensions.<\/p>\n<p>If you want to get started, you can learn to build a sample insight extension through our Extension Guide we created for Microsoft Build.<\/p>\n<p>You can further learn how the SSMS keymap extension was created by following Kevin Cunnane\u2019s blogs:<\/p>\n<ul>\n<li><a href=\"https:\/\/medium.com\/@kevcunnane\/writing-a-sql-operations-studio-extension-in-15-minutes-7dfd24a74dfe\">Writing a SQL Operations Studio extension in 15 minutes<\/a><\/li>\n<li><a href=\"https:\/\/medium.com\/@kevcunnane\/publishing-an-extension-for-sql-operations-studio-f5a5b323c13b\">Publishing an extension for SQL Operations Studio<\/a><\/li>\n<\/ul>\n<p>Both the Extension Guide and Kevin\u2019s blog posts use the <a href=\"https:\/\/github.com\/llali\/generator-sqlops\">generator-sqlops yeoman generator<\/a> to help make it even easier to make an extension.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-24595 aligncenter\" src=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/06\/build-your-own-extension.png\" alt=\"\" width=\"570\" height=\"236\" srcset=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/06\/build-your-own-extension.webp 570w, https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/06\/build-your-own-extension-300x124.webp 300w, https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/06\/build-your-own-extension-330x137.webp 330w, https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/06\/build-your-own-extension-400x166.webp 400w\" sizes=\"auto, (max-width: 570px) 100vw, 570px\" \/><\/p>\n<p>If any of these extensions in this generator interest you, feel free to try it out! If you are interested in hosting your extension in our Extensions Manager or would like help building an extension, feel free to reach out to the team on GitHub or email <a href=\"mailto:alayu@microsoft.com\">alayu@microsoft.com<\/a>.<\/p>\n<p>Our team also brought in Wizard and Dialog extensibility support, so feel free to reach out to us if you want to learn more and add wizards and dialogs to your extension. <a href=\"https:\/\/github.com\/microsoft\/sqlopsstudio\/wiki\/Extensibility-API\">You can learn more here<\/a>.<\/p>\n<p>Want to learn more about our roadmap for extensions? Learn from our Microsoft build session if you missed it!<\/p>\n<p><iframe loading=\"lazy\" title=\"Looking ahead with SQL Operations Studio\" width=\"500\" height=\"281\" src=\"https:\/\/www.youtube-nocookie.com\/embed\/zAnrJ7GdsM8?feature=oembed\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" referrerpolicy=\"strict-origin-when-cross-origin\" allowfullscreen><\/iframe><\/p>\n<h2>Visual Studio Code refresh<\/h2>\n<p>Since SQL Operations Studio forks from Visual Studio Code, our team periodically includes \u201crefreshes\u201d based on latest VS Code monthly releases. This usually brings nice features for the editor and configuration.\u00a0The latest refresh picks up VS Code v1.23, which includes the March and April 2018 release.<\/p>\n<ul>\n<li><a href=\"https:\/\/code.visualstudio.com\/updates\/v1_22#_easier-way-to-open-large-files\">Easier way to open large files<\/a><\/li>\n<li><a href=\"https:\/\/code.visualstudio.com\/updates\/v1_22#_syntax-highlighting-optimization\">Syntax highlighting optimization<\/a><\/li>\n<li><a href=\"https:\/\/code.visualstudio.com\/updates\/v1_23#_highlighted-indent-guides\">Highlighted indent guides<\/a><\/li>\n<li><a href=\"https:\/\/code.visualstudio.com\/updates\/v1_23#_column-selection-using-middle-mouse-button\">Column Selection using middle mouse button<\/a><\/li>\n<\/ul>\n<p>For more information, check the <a href=\"https:\/\/code.visualstudio.com\/updates\/v1_23\">VS Code release notes<\/a>.<\/p>\n<h2>Fix GitHub issues<\/h2>\n<p>Here is a summary of issues addressed:<\/p>\n<ul>\n<li><a href=\"https:\/\/github.com\/Microsoft\/sqlopsstudio\/issues\/1204\">#1204<\/a> Feature request: Please make the results grid auto-fit column width to data, and\/or remember manual changes if the same query is re-run<\/li>\n<li><a href=\"https:\/\/github.com\/Microsoft\/sqlopsstudio\/issues\/1398\">#1398<\/a> Should show add message and add account button when linked account is empty<\/li>\n<li><a href=\"https:\/\/github.com\/Microsoft\/sqlopsstudio\/issues\/1399\">#1399<\/a> Linked account tab is broken when the view is collapsed<\/li>\n<li><a href=\"https:\/\/github.com\/Microsoft\/sqlopsstudio\/issues\/1374\">#1374<\/a> SQL Tools Service crashes when opening .sql file from disk<\/li>\n<li><a href=\"https:\/\/github.com\/Microsoft\/sqlopsstudio\/issues\/1372\">#1372<\/a> Missing SQL keyword &#8220;BETWEEN&#8221;<\/li>\n<li><a href=\"https:\/\/github.com\/Microsoft\/sqlopsstudio\/issues\/1395\">#1395<\/a> &#8216;MATCH&#8217; keyword crashes SQL Tools Service<\/li>\n<li><a href=\"https:\/\/github.com\/Microsoft\/sqlopsstudio\/issues\/1496\">#1496<\/a> &#8220;New Profiler&#8221; context menu option in Object Explorer does nothing.<\/li>\n<li><a href=\"https:\/\/github.com\/Microsoft\/sqlopsstudio\/issues\/1495\">#1495<\/a> Query editor &#8220;Explain&#8221; query plan is broken<\/li>\n<\/ul>\n<h2>Contact us<\/h2>\n<p>If you have any feature requests or issues, please submit to <a href=\"https:\/\/github.com\/microsoft\/sqlopsstudio\/issues\">our GitHub issues page.<\/a> For any questions, feel free to comment below, message us on <a href=\"https:\/\/gitter.im\/Microsoft\/sqlopsstudio\">Gitter<\/a>, or tweet us <a href=\"https:\/\/twitter.com\/SQLOpsStudio\">@SQLOpsStudio<\/a>.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>UPDATE: SQL Operations Studio is now GA and renamed to Azure Data Studio. For the most up to date information please visit our monthly Azure Data Studio blog post and download and install the latest release here. We are excited to announce the June release of SQL Operations Studio is now available.<\/p>\n","protected":false},"author":5562,"featured_media":24499,"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":[5226,2542,5227,2521,2406,2409,2418],"content-type":[2448],"topic":[2466],"coauthors":[2487],"class_list":["post-24577","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","product-azure","product-azure-data-studio","product-sql","product-sql-operations","product-sql-server-2017","product-sql-server-2017-on-linux","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>The June release of SQL Operations Studio 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\/20\/the-june-release-of-sql-operations-studio-is-now-available\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"The June release of SQL Operations Studio is now available - Microsoft SQL Server Blog\" \/>\n<meta property=\"og:description\" content=\"UPDATE: SQL Operations Studio is now GA and renamed to Azure Data Studio. For the most up to date information please visit our monthly Azure Data Studio blog post and download and install the latest release here. We are excited to announce the June release of SQL Operations Studio is now available.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/06\/20\/the-june-release-of-sql-operations-studio-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-20T18:00:22+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-01-29T18:35:09+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/05\/SQL-server_SQL-Operations-Studio-Thumbnail_FY18_280x180_V1.png\" \/>\n\t<meta property=\"og:image:width\" content=\"280\" \/>\n\t<meta property=\"og:image:height\" content=\"180\" \/>\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=\"4 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\/20\/the-june-release-of-sql-operations-studio-is-now-available\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/06\/20\/the-june-release-of-sql-operations-studio-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\":\"The June release of SQL Operations Studio is now available\",\"datePublished\":\"2018-06-20T18:00:22+00:00\",\"dateModified\":\"2024-01-29T18:35:09+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/06\/20\/the-june-release-of-sql-operations-studio-is-now-available\/\"},\"wordCount\":1116,\"commentCount\":1,\"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\/20\/the-june-release-of-sql-operations-studio-is-now-available\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/05\/SQL-server_SQL-Operations-Studio-Thumbnail_FY18_280x180_V1.png\",\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/06\/20\/the-june-release-of-sql-operations-studio-is-now-available\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/06\/20\/the-june-release-of-sql-operations-studio-is-now-available\/\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/06\/20\/the-june-release-of-sql-operations-studio-is-now-available\/\",\"name\":\"The June release of SQL Operations Studio 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\/20\/the-june-release-of-sql-operations-studio-is-now-available\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/06\/20\/the-june-release-of-sql-operations-studio-is-now-available\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/05\/SQL-server_SQL-Operations-Studio-Thumbnail_FY18_280x180_V1.png\",\"datePublished\":\"2018-06-20T18:00:22+00:00\",\"dateModified\":\"2024-01-29T18:35:09+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/06\/20\/the-june-release-of-sql-operations-studio-is-now-available\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/06\/20\/the-june-release-of-sql-operations-studio-is-now-available\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/06\/20\/the-june-release-of-sql-operations-studio-is-now-available\/#primaryimage\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/05\/SQL-server_SQL-Operations-Studio-Thumbnail_FY18_280x180_V1.png\",\"contentUrl\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/05\/SQL-server_SQL-Operations-Studio-Thumbnail_FY18_280x180_V1.png\",\"width\":280,\"height\":180,\"caption\":\"a close up of a sign\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/06\/20\/the-june-release-of-sql-operations-studio-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\":\"The June release of SQL Operations Studio 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":"The June release of SQL Operations Studio 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\/20\/the-june-release-of-sql-operations-studio-is-now-available\/","og_locale":"en_US","og_type":"article","og_title":"The June release of SQL Operations Studio is now available - Microsoft SQL Server Blog","og_description":"UPDATE: SQL Operations Studio is now GA and renamed to Azure Data Studio. For the most up to date information please visit our monthly Azure Data Studio blog post and download and install the latest release here. We are excited to announce the June release of SQL Operations Studio is now available.","og_url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/06\/20\/the-june-release-of-sql-operations-studio-is-now-available\/","og_site_name":"Microsoft SQL Server Blog","article_publisher":"http:\/\/www.facebook.com\/sqlserver","article_published_time":"2018-06-20T18:00:22+00:00","article_modified_time":"2024-01-29T18:35:09+00:00","og_image":[{"width":280,"height":180,"url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/05\/SQL-server_SQL-Operations-Studio-Thumbnail_FY18_280x180_V1.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":"4 min read"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/06\/20\/the-june-release-of-sql-operations-studio-is-now-available\/#article","isPartOf":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/06\/20\/the-june-release-of-sql-operations-studio-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":"The June release of SQL Operations Studio is now available","datePublished":"2018-06-20T18:00:22+00:00","dateModified":"2024-01-29T18:35:09+00:00","mainEntityOfPage":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/06\/20\/the-june-release-of-sql-operations-studio-is-now-available\/"},"wordCount":1116,"commentCount":1,"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\/20\/the-june-release-of-sql-operations-studio-is-now-available\/#primaryimage"},"thumbnailUrl":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/05\/SQL-server_SQL-Operations-Studio-Thumbnail_FY18_280x180_V1.png","inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/06\/20\/the-june-release-of-sql-operations-studio-is-now-available\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/06\/20\/the-june-release-of-sql-operations-studio-is-now-available\/","url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/06\/20\/the-june-release-of-sql-operations-studio-is-now-available\/","name":"The June release of SQL Operations Studio 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\/20\/the-june-release-of-sql-operations-studio-is-now-available\/#primaryimage"},"image":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/06\/20\/the-june-release-of-sql-operations-studio-is-now-available\/#primaryimage"},"thumbnailUrl":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/05\/SQL-server_SQL-Operations-Studio-Thumbnail_FY18_280x180_V1.png","datePublished":"2018-06-20T18:00:22+00:00","dateModified":"2024-01-29T18:35:09+00:00","breadcrumb":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/06\/20\/the-june-release-of-sql-operations-studio-is-now-available\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/06\/20\/the-june-release-of-sql-operations-studio-is-now-available\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/06\/20\/the-june-release-of-sql-operations-studio-is-now-available\/#primaryimage","url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/05\/SQL-server_SQL-Operations-Studio-Thumbnail_FY18_280x180_V1.png","contentUrl":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/05\/SQL-server_SQL-Operations-Studio-Thumbnail_FY18_280x180_V1.png","width":280,"height":180,"caption":"a close up of a sign"},{"@type":"BreadcrumbList","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/06\/20\/the-june-release-of-sql-operations-studio-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":"The June release of SQL Operations Studio 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\/24577","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=24577"}],"version-history":[{"count":0,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/posts\/24577\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/media\/24499"}],"wp:attachment":[{"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/media?parent=24577"}],"wp:term":[{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/post_tag?post=24577"},{"taxonomy":"product","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/product?post=24577"},{"taxonomy":"content-type","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/content-type?post=24577"},{"taxonomy":"topic","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/topic?post=24577"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/coauthors?post=24577"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}