{"id":24748,"date":"2018-07-19T11:00:47","date_gmt":"2018-07-19T18:00:47","guid":{"rendered":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/?p=24748"},"modified":"2024-01-29T10:34:50","modified_gmt":"2024-01-29T18:34:50","slug":"the-july-release-of-sql-operations-studio-is-now-available","status":"publish","type":"post","link":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/07\/19\/the-july-release-of-sql-operations-studio-is-now-available\/","title":{"rendered":"The July release of SQL Operations Studio is now available"},"content":{"rendered":"<h4><strong>UPDATE: <\/strong>SQL Operations Studio is now <a href=\"https:\/\/nam06.safelinks.protection.outlook.com\/?url=https%3A%2F%2Fcloudblogs.microsoft.com%2Fsqlserver%2F2018%2F09%2F25%2Fazure-data-studio-for-sql-server%2F&amp;data=02%7C01%7CJenny.Erie%40microsoft.com%7C0a81f1ce9ce4480265e308d6a7258ba4%7C72f988bf86f141af91ab2d7cd011db47%7C1%7C0%7C636880177037462640&amp;sdata=wd2bKF%2Birm7MTrSPOTJTY5kLpZRlh2wy5vZ0hTXpXDk%3D&amp;reserved=0\">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:\/\/nam06.safelinks.protection.outlook.com\/?url=https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fsql%2Fazure-data-studio%2Fdownload%3Fview%3Dsql-server-2017&amp;data=02%7C01%7CJenny.Erie%40microsoft.com%7C0a81f1ce9ce4480265e308d6a7258ba4%7C72f988bf86f141af91ab2d7cd011db47%7C1%7C0%7C636880177037472648&amp;sdata=KMRc4RxDtTq2sJCT%2FNQQhlyveQfFwyNvpxZTlAgf%2Fgo%3D&amp;reserved=0\">download and install the latest release here<\/a>.<\/h4>\n<hr \/>\n<p><strong>We are excited to announce the July 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, <a href=\"https:\/\/github.com\/microsoft\/sqlopsstudio\/\">visit our GitHub<\/a>.<\/p>\n<p>SQL Operations Studio was announced for Public Preview on November 15th at Connect(), and this June release is the eighth major update since the announcement. If you missed it, the <a href=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/06\/20\/the-june-release-of-sql-operations-studio-is-now-available\/\">June release announcement is available here<\/a>.<\/p>\n<p>Highlights for this release include the following.<\/p>\n<ul>\n<li>SQL Server Agent preview extension Job configuration support<\/li>\n<li>SQL Server Profiler preview extension Improvements<\/li>\n<li>Combine Scripts Extension<\/li>\n<li>Wizard and Dialog Extensibility<\/li>\n<li>Social content<\/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 Agent configuration<\/h2>\n<p>As part of our story of bringing over SSMS features and improving user experience, we are excited to introduce SQL Agent configuration support.<\/p>\n<p>Summary of changes include:<\/p>\n<ul>\n<li>Added view of Alerts, Operators, and Proxies and icons on left pane<\/li>\n<li>Added dialogs for New Job, New Job Step, New Alert, and New Operator<\/li>\n<li>Added Delete Job, Delete Alert, and Delete Operator (right-click)<\/li>\n<li>Added Previous Runs visualization<\/li>\n<li>Added Filters for each column name<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-24754 aligncenter\" src=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/07\/agent_walkthrough.gif\" alt=\"\" width=\"1089\" height=\"662\" \/><\/p>\n<p>In addition to jobs, users can now view Alerts, Operators, and Proxies through the icons on the left pane as demonstrated in the gif above.<\/p>\n<p>We also made several improvements for the Job View. Previous Runs visualization can now be seen so that a user can quickly see a job\u2019s history of past runs if they passed or failed.<\/p>\n<p>This release also made it easier to find specific jobs in a large list of jobs. Imagine you had a list of 100+ jobs and you only wanted to see the failed jobs? Now you can by checking out the gif below using the filter column option.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-24751 aligncenter\" src=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/07\/agent_failed.gif\" alt=\"\" width=\"1055\" height=\"596\" \/><\/p>\n<p>With all the improvements in Views, we have added new dialogs so that users can now add Jobs, Alerts, and Operators without having to go to SSMS. To open each dialog, click <strong>New Job<\/strong> above each respective view.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-24760 aligncenter\" src=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/07\/SQL-Server-agent-experience.png\" alt=\"\" width=\"936\" height=\"758\" srcset=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/07\/SQL-Server-agent-experience.webp 936w, https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/07\/SQL-Server-agent-experience-300x243.webp 300w, https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/07\/SQL-Server-agent-experience-768x622.webp 768w, https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/07\/SQL-Server-agent-experience-309x250.webp 309w, https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/07\/SQL-Server-agent-experience-330x267.webp 330w, https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/07\/SQL-Server-agent-experience-800x648.webp 800w, https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/07\/SQL-Server-agent-experience-400x324.webp 400w\" sizes=\"auto, (max-width: 936px) 100vw, 936px\" \/><\/p>\n<p>For all the SQL Agent enthusiasts out there, we would love for you to try out the new SQL Server Agent experience and let us know what you like and what is still missing for you to use Agent day to day. As part of doing our engineering out in the open, we need your feedback so that we can create experiences that empower you to do your job (pun intended).<\/p>\n<p>To learn more about SQL Server Agent, <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/ssms\/agent\/sql-server-agent?view=sql-server-2017\">check out the documentation.<\/a><\/p>\n<h2>SQL Server Profiler improvements<\/h2>\n<p>With the release of SQL Server Profiler extension last month, our team has been working hard on improvements, especially making launching Profiler quickly.<\/p>\n<p>Summary of changes include:<\/p>\n<ul>\n<li>Added Hotkeys to quickly launch and start\/stop Profiler<\/li>\n<li>Added 5 Default Templates to view Extended Events<\/li>\n<li>Added Server\/Database connection name<\/li>\n<li>Added support for Azure SQL Database instances<\/li>\n<li>Added suggestion to exit Profiler when the tab is closed and Profiler is still running<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-24757 aligncenter\" src=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/07\/profiler_templates.gif\" alt=\"\" width=\"1069\" height=\"501\" \/><\/p>\n<p>As seen in this gif, you can quickly get Profiler open after making a server\/database connection. With this release, we added Keyboard Shortcuts to Launch Profiler (<strong>Windows: Alt + P Mac: Ctrl+ALT+P<\/strong>) and Start\/Stop Profiler (<strong>Windows: Alt + S Mac: Ctrl+ALT+S<\/strong>). From our user survey, the highest priority for users is to be able to start Profiling as quickly as possible. Now with two keyboard strokes, you can start Profiler.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-24763 aligncenter\" src=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/07\/Profiler.png\" alt=\"\" width=\"883\" height=\"184\" srcset=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/07\/Profiler.webp 883w, https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/07\/Profiler-300x63.webp 300w, https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/07\/Profiler-768x160.webp 768w, https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/07\/Profiler-330x69.webp 330w, https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/07\/Profiler-800x167.webp 800w, https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/07\/Profiler-400x83.webp 400w\" sizes=\"auto, (max-width: 883px) 100vw, 883px\" \/><\/p>\n<p>In addition, Profiler now has added Default templates for five different views: Standard, TSQL, Tuning, TSQL_Locks, and TSQL_Duration. When you click on each one, a different list of columns will generate in your Profiler view so that you can focus on the areas that you are investigating. At the moment, it will reset the view each time.<\/p>\n<p>In addition, each Profiler tab will show the server\/database the Profiler instance is connected to. You can see the name in the top right of the above screenshot, which is localhost\/Adventureworks2014.<\/p>\n<p>Please let us know what you think and what you would like to see in Profiler.<\/p>\n<h2>Combine Scripts Extension<\/h2>\n<p>We have a new community extension published in our Extensions Manager. Created by Cobus Kruger, the <a href=\"https:\/\/github.com\/BateleurIO\/sqlops-combine-scripts\">Combine Scripts Extension for SQL Operations Studio<\/a> is now available.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-24766 aligncenter\" src=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/07\/combine-scripts.png\" alt=\"\" width=\"770\" height=\"186\" srcset=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/07\/combine-scripts.webp 770w, https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/07\/combine-scripts-300x72.webp 300w, https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/07\/combine-scripts-768x186.webp 768w, https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/07\/combine-scripts-330x80.webp 330w, https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/07\/combine-scripts-400x97.webp 400w\" sizes=\"auto, (max-width: 770px) 100vw, 770px\" \/><\/p>\n<p>From the extension description: Ever needed to execute several scripts spread over several folders? Now you can select several files and folders, right click and click <strong>Combine Scripts<\/strong>, and generate a single combined file to execute or use any way you choose.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-24769 aligncenter\" src=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/07\/combine-scripts-screenshot.png\" alt=\"\" width=\"424\" height=\"365\" srcset=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/07\/combine-scripts-screenshot.webp 424w, https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/07\/combine-scripts-screenshot-300x258.webp 300w, https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/07\/combine-scripts-screenshot-290x250.webp 290w, https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/07\/combine-scripts-screenshot-330x284.webp 330w, https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/07\/combine-scripts-screenshot-400x344.webp 400w\" sizes=\"auto, (max-width: 424px) 100vw, 424px\" \/><\/p>\n<p>For those new to extensions, <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/sql-operations-studio\/extensions?view=sql-server-2017\">here are the instructions<\/a> to access the Extensions Manager and download the Combine Scripts extension. For this extension, in particular, the install button will take you to a download link for the VSIX package. Download the VSIX, and then click <strong>File -&gt; Install Extension from VSIX Package.<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-24772 aligncenter\" src=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/07\/vsix-package.png\" alt=\"\" width=\"328\" height=\"447\" srcset=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/07\/vsix-package.webp 328w, https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/07\/vsix-package-220x300.webp 220w, https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/07\/vsix-package-183x250.webp 183w, https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/07\/vsix-package-257x350.webp 257w\" sizes=\"auto, (max-width: 328px) 100vw, 328px\" \/><\/p>\n<h2>Dialog and Wizard extensibility<\/h2>\n<p>With this release, we are continuing to provide more opportunities for extension authors, <a href=\"https:\/\/github.com\/microsoft\/sqlopsstudio\/wiki\/Getting-started-with-Extensibility\">which we highly encourage you to participate.<\/a> The highlight for this release is we have now provided options for extension authors to incorporate Dialogs and Wizards in their extensions.<\/p>\n<p style=\"padding-left: 180px\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-24778 aligncenter\" src=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/07\/test-dialogue.png\" alt=\"\" width=\"411\" height=\"416\" srcset=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/07\/test-dialogue.webp 411w, https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/07\/test-dialogue-296x300.webp 296w, https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/07\/test-dialogue-247x250.webp 247w, https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/07\/test-dialogue-330x334.webp 330w, https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/07\/test-dialogue-400x405.webp 400w\" sizes=\"auto, (max-width: 411px) 100vw, 411px\" \/> <img loading=\"lazy\" decoding=\"async\" class=\"wp-image-24775 aligncenter\" src=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/07\/test-wizard.png\" alt=\"\" width=\"605\" height=\"416\" srcset=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/07\/test-wizard.webp 1410w, https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/07\/test-wizard-300x206.webp 300w, https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/07\/test-wizard-1024x704.webp 1024w, https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/07\/test-wizard-768x528.webp 768w, https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/07\/test-wizard-330x227.webp 330w, https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/07\/test-wizard-800x550.webp 800w, https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/07\/test-wizard-400x275.webp 400w\" sizes=\"auto, (max-width: 605px) 100vw, 605px\" \/><\/p>\n<p>The differences between using dialogs and wizards are very similar to SSMS. Generally, use Wizards for step-by-step scenarios, and use dialogs for most other cases.<\/p>\n<p>Extension authors can see the <a href=\"https:\/\/github.com\/Microsoft\/sqlopsstudio\/blob\/master\/src\/sql\/sqlops.proposed.d.ts\">full list of Dialog and Wizard API\u2019s.<\/a><\/p>\n<p>To see this in action, check out our <a href=\"https:\/\/github.com\/Microsoft\/sqlopsstudio\/blob\/master\/samples\/sqlservices\/src\/controllers\/mainController.ts\">sample extension that includes this code.<\/a><\/p>\n<p>We are excited to see what our extension authors can come up with these new extensibility points. If you aren\u2019t an extension author but have ideas in mind, please feel free to share on Twitter or <a href=\"https:\/\/github.com\/Microsoft\/sqlopsstudio\/issues\">GitHub Issues.<\/a><\/p>\n<h2>Social content<\/h2>\n<p>Over the past month, we have seen a lot of great content about SQL Operations Studio as we monitored social media. We highly encourage the community that if you love this tool, consider using this tool in demos and blog posts. We will also make sure to share any of your content with the community through our Twitter handle (<a href=\"https:\/\/twitter.com\/sqlopsstudio\">@sqlopsstudio<\/a>).<\/p>\n<p>If you would like to use SQL Operations Studio at sessions like SQL Saturdays or PASS Summit, feel free to reach out to our team and we can work with you. If there are any demo blockers, <a href=\"https:\/\/github.com\/microsoft\/sqlopsstudio\/issues\">please submit an issue on our GitHub Issues.<\/a> Our engineers will help unblock your scenarios.<\/p>\n<p>With the launch of the Data Double-Click channel, our Principal PM Lead, Vicky Harp, discussed SQL Operations Studio with Scott Klein. Check out the conversation below.<\/p>\n<p><iframe loading=\"lazy\" title=\"Microsoft SQL Operations Studio Overview\" width=\"500\" height=\"281\" src=\"https:\/\/www.youtube-nocookie.com\/embed\/jV3jKt8RaUY?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<p>In addition, Vicky was also interviewed by Joey D\u2019Antoni for Redmond Mag, covering the <a href=\"https:\/\/redmondmag.com\/articles\/2018\/07\/10\/sql-server-tools-development.aspx\">current state of SQL Server Tools development<\/a>.<\/p>\n<p>SQL Ops Studio also had a presence at OSCON in Portland this year, where Shayne Boyer shared <a href=\"https:\/\/tattoocoder.com\/open-source-tools-for-sql-server-on-linux-2\/\">SQL Operations Studio and mssql-cli<\/a>.<\/p>\n<h2>Fixed 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\/728\">#728\u00a0<\/a>No response to Add Connection on macOS<\/li>\n<li><a href=\"https:\/\/github.com\/Microsoft\/sqlopsstudio\/issues\/1718\">#1718\u00a0<\/a>Unable to connect to any data source<\/li>\n<li><a href=\"https:\/\/github.com\/Microsoft\/sqlopsstudio\/issues\/1713\">#1713\u00a0<\/a>Number of rows affected<\/li>\n<li><a href=\"https:\/\/github.com\/Microsoft\/sqlopsstudio\/issues\/1843\">#1843\u00a0<\/a>Better Table organization<\/li>\n<li><a href=\"https:\/\/github.com\/Microsoft\/sqlopsstudio\/issues\/1612\">#1612\u00a0<\/a>Results grid text display is messed up by international characters<\/li>\n<li><a href=\"https:\/\/github.com\/Microsoft\/sqlopsstudio\/issues\/1749\">#1749\u00a0<\/a>BUG: HTML data in a column gets interpreted<\/li>\n<li><a href=\"https:\/\/github.com\/Microsoft\/sqlopsstudio\/issues\/1830\">#1830\u00a0<\/a>Setting iconPath in ButtonComponent after component() is called does not change icon<\/li>\n<li><a href=\"https:\/\/github.com\/Microsoft\/sqlopsstudio\/issues\/1789\">#1789\u00a0<\/a>Extensibility: if you add a connection provider uninstall will never remove it from the list<\/li>\n<li><a href=\"https:\/\/github.com\/Microsoft\/sqlopsstudio\/issues\/1799\">#1799\u00a0<\/a>Top 10 DB Size chart does not work on ccase-sensitive instances<\/li>\n<li><a href=\"https:\/\/github.com\/Microsoft\/sqlopsstudio\/issues\/1724\">#1724\u00a0<\/a>Extension dialogs have stopped working<\/li>\n<li><a href=\"https:\/\/github.com\/Microsoft\/sqlopsstudio\/issues\/1719\">#1719\u00a0<\/a>TypeError when Connecting to Server<\/li>\n<li><a href=\"https:\/\/github.com\/Microsoft\/sqlopsstudio\/issues\/1693\">#1693\u00a0<\/a>Backup dialog: File browser UI is broken<\/li>\n<li><a href=\"https:\/\/github.com\/Microsoft\/sqlopsstudio\/issues\/1817\">#1817\u00a0<\/a>Error de Ortografia<\/li>\n<li><a href=\"https:\/\/github.com\/Microsoft\/sqlopsstudio\/issues\/1791\">#1791\u00a0<\/a>Sqlops Extensions: queryeditor.connect() connects to the target database, but UI does not show the editor is connected<\/li>\n<li><a href=\"https:\/\/github.com\/Microsoft\/sqlopsstudio\/issues\/1814\">#1814\u00a0<\/a>d.ts typo causing implicit &#8216;any&#8217; type definition<\/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 <a href=\"https:\/\/twitter.com\/SQLOpsStudio\">tweet us<\/a>.<\/p>\n<p>&nbsp;<\/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 July 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-24748","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 July 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\/07\/19\/the-july-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 July 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 July release of SQL Operations Studio is now available.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/07\/19\/the-july-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-07-19T18:00:47+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-01-29T18:34:50+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=\"5 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\/07\/19\/the-july-release-of-sql-operations-studio-is-now-available\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/07\/19\/the-july-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 July release of SQL Operations Studio is now available\",\"datePublished\":\"2018-07-19T18:00:47+00:00\",\"dateModified\":\"2024-01-29T18:34:50+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/07\/19\/the-july-release-of-sql-operations-studio-is-now-available\/\"},\"wordCount\":1360,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/07\/19\/the-july-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\/07\/19\/the-july-release-of-sql-operations-studio-is-now-available\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/07\/19\/the-july-release-of-sql-operations-studio-is-now-available\/\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/07\/19\/the-july-release-of-sql-operations-studio-is-now-available\/\",\"name\":\"The July 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\/07\/19\/the-july-release-of-sql-operations-studio-is-now-available\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/07\/19\/the-july-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-07-19T18:00:47+00:00\",\"dateModified\":\"2024-01-29T18:34:50+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/07\/19\/the-july-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\/07\/19\/the-july-release-of-sql-operations-studio-is-now-available\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/07\/19\/the-july-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\/07\/19\/the-july-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 July 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 July 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\/07\/19\/the-july-release-of-sql-operations-studio-is-now-available\/","og_locale":"en_US","og_type":"article","og_title":"The July 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 July release of SQL Operations Studio is now available.","og_url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/07\/19\/the-july-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-07-19T18:00:47+00:00","article_modified_time":"2024-01-29T18:34:50+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":"5 min read"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/07\/19\/the-july-release-of-sql-operations-studio-is-now-available\/#article","isPartOf":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/07\/19\/the-july-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 July release of SQL Operations Studio is now available","datePublished":"2018-07-19T18:00:47+00:00","dateModified":"2024-01-29T18:34:50+00:00","mainEntityOfPage":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/07\/19\/the-july-release-of-sql-operations-studio-is-now-available\/"},"wordCount":1360,"commentCount":0,"publisher":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization"},"image":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/07\/19\/the-july-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\/07\/19\/the-july-release-of-sql-operations-studio-is-now-available\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/07\/19\/the-july-release-of-sql-operations-studio-is-now-available\/","url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/07\/19\/the-july-release-of-sql-operations-studio-is-now-available\/","name":"The July 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\/07\/19\/the-july-release-of-sql-operations-studio-is-now-available\/#primaryimage"},"image":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/07\/19\/the-july-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-07-19T18:00:47+00:00","dateModified":"2024-01-29T18:34:50+00:00","breadcrumb":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/07\/19\/the-july-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\/07\/19\/the-july-release-of-sql-operations-studio-is-now-available\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/07\/19\/the-july-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\/07\/19\/the-july-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 July 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\/24748","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=24748"}],"version-history":[{"count":0,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/posts\/24748\/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=24748"}],"wp:term":[{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/post_tag?post=24748"},{"taxonomy":"product","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/product?post=24748"},{"taxonomy":"content-type","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/content-type?post=24748"},{"taxonomy":"topic","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/topic?post=24748"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/coauthors?post=24748"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}