{"id":24171,"date":"2018-04-25T11:00:54","date_gmt":"2018-04-25T18:00:54","guid":{"rendered":"https:\/\/blogs.technet.microsoft.com\/dataplatforminsider\/?p=22175"},"modified":"2024-01-22T22:51:16","modified_gmt":"2024-01-23T06:51:16","slug":"the-april-release-of-sql-operations-studio-is-now-available","status":"publish","type":"post","link":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/04\/25\/the-april-release-of-sql-operations-studio-is-now-available\/","title":{"rendered":"The April 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 April 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><a href=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/04\/sql-operations-studio-main.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-22185 aligncenter\" src=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/04\/sql-operations-studio-main.png\" alt=\"\" width=\"2844\" height=\"1611\" \/><\/a><\/p>\n<p>SQL Operations Studio was announced for Public Preview on November 15th at Connect(), and this April release is the fifth major update since the announcement. If you missed the <a href=\"https:\/\/blogs.technet.microsoft.com\/dataplatforminsider\/2018\/03\/28\/the-march-release-of-sql-operations-studio-is-now-available\/\">March release announcement can be viewed here<\/a>.<\/p>\n<p>The April 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>Public preview release of SQL Agent extension<\/li>\n<li>Added new extensions and improved existing extensions\n<ul>\n<li>Improvements to Server Reports Extension<\/li>\n<li>Release of SSMS Keymap extension<\/li>\n<li>Release of AlwaysOn Insights extension<\/li>\n<li>Release of MSSQL Instance Insights<\/li>\n<li>Release of MSSQL Db Insights<\/li>\n<\/ul>\n<\/li>\n<li>Added Visual Studio Code 1.21 platform source code refresh\n<ul>\n<li>Improved large and protected file support for saving Admin protected and &gt;256M files within SQL Ops Studio<\/li>\n<li>Integrated Terminal splitting to work with multiple open terminals at once<\/li>\n<li>Reduced installation on-disk file count footprint for faster installs and startup times<\/li>\n<\/ul>\n<\/li>\n<li>Continue to 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>Preview release of SQL Agent extension<\/h2>\n<p><a href=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/04\/feature-request-sql-agent.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-22195 aligncenter\" src=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/04\/feature-request-sql-agent.png\" alt=\"\" width=\"944\" height=\"92\" \/><\/a><\/p>\n<p>Since SQL Operations Studio was released for public preview, <a href=\"https:\/\/github.com\/Microsoft\/sqlopsstudio\/issues\/27\">one of the most requested features<\/a> was providing SQL Agent support. Bringing over the most popular SSMS features has always been on our roadmap, but we wanted to make sure we did this the right way. For years, customers have submitted issues that were difficult to change due to being built on old dialog and wizard frameworks. With SQL Operations Studio, we had an opportunity to bring a modern user experience to our features while maintaining the same functionality that our users are experts with.<\/p>\n<p><a href=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/04\/sqlagent_community.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-22205 aligncenter\" src=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/04\/sqlagent_community.png\" alt=\"\" width=\"966\" height=\"242\" \/><\/a><\/p>\n<p>To make this possible, the engineering team reached out to the SQL Server community to learn more about your top scenarios and get direct feedback about our initial mock-ups. This involved creating surveys, scheduling user interviews, and <a href=\"https:\/\/github.com\/Microsoft\/sqlopsstudio\/issues\/750\">promoting community discussion<\/a> through a <a href=\"https:\/\/www.youtube.com\/watch?v=xnnVG66rvCk\">demo on Youtube<\/a> showing our initial prototype. With your help and the release of Extensions Manager in the March release, we have provided you an initial preview release of SQL Agent.<\/p>\n<p><a href=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/04\/sqlagent1.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-22215 aligncenter\" src=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/04\/sqlagent1.png\" alt=\"\" width=\"1914\" height=\"1131\" \/><\/a><\/p>\n<p>When you install SQL Agent from the Extension Manager, you can view the SQL Agents extension as a tab on your server dashboard. To learn how to install an extension, <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/sql-operations-studio\/extensions?view=sql-server-2017\">please view this how-to guide<\/a>.<\/p>\n<p>This initial release focuses on providing a great View Jobs and Job History experience. You can see a list of all jobs including color-coded successful and filed jobs, names of jobs, and error messages. To see the job history of a specific job, you simply click on that job. This view lets you see a history of past runs, and also provides the ability run or stop the job.<\/p>\n<p><a href=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/04\/job_history.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-22225 aligncenter\" src=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/04\/job_history.png\" alt=\"\" width=\"1914\" height=\"1130\" \/><\/a><\/p>\n<p>The next step will be to add Job Configuration functionalities, including providing support for creating a job, setting alerts, and scheduling jobs. We would love to hear your feedback about this initial release through our <a href=\"https:\/\/github.com\/microsoft\/sqlopsstudio\/issues\">GitHub Issues page<\/a> and also any suggestions you may have as we build out Job Configuration.<\/p>\n<p>This is the first step as we continue to bring over popular features to SQL Operations Studio from SSMS. Please continue to let us know what are your must-have features and feel free to join the discussion.<\/p>\n<h2>Adding and improving extensions<\/h2>\n<p>In the <a href=\"https:\/\/blogs.technet.microsoft.com\/dataplatforminsider\/2018\/03\/28\/the-march-release-of-sql-operations-studio-is-now-available\/\">March Public Preview release<\/a>, we first introduced the Extension Manager to SQL Operations Studio. With this release, we introduce 5 new extensions that you can now try out in the Extensions Manager (<a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/sql-operations-studio\/extensions?view=sql-server-2017\">to get started, read the how-to install extension guide<\/a>).<\/p>\n<p><a href=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/04\/list-of-extensions.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-22235 aligncenter\" src=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/04\/list-of-extensions.png\" alt=\"\" width=\"263\" height=\"443\" \/><\/a><\/p>\n<ul>\n<li><strong>SQL Agent<\/strong> is the extension to view and run SQL Agent jobs as described earlier.<\/li>\n<li><strong>SSMS Keymap<\/strong> ports the most popular SSMS keyboard shortcuts to SQL Operations Studio. Created by Kevin Cunnane.<\/li>\n<li><strong>AlwaysOn Insights<\/strong> is a collection of widgets designed to provide insights into AlwaysOn Availability Group components to assist DBA\u2019s or similar in managing their environment. Created by Matt Lavery.<\/li>\n<li><strong>MSSQL Instance Insights<\/strong> is a collection of widgets designed to provide insights into MSSQL Instance to further extend the built-in default widgets. Created by Matt Lavery.<\/li>\n<li><strong>MSSQL Db Insights<\/strong> is a collection of widgets that are designed to provide insights into MSSQL Database to further extend the built-in default widgets. Created by Matt Lavery.<\/li>\n<\/ul>\n<p>Over the past month, we have received a lot of emails and tweets from the community who were interested in creating their own extension. One of our engineers, Kevin Cunnane, wrote awesome blog posts that includes his process to create and publish the SSMS Keymap extension:<\/p>\n<ul>\n<li><a href=\"https:\/\/medium.com\/@kevcunnane\/writing-a-sql-operations-studio-extension-in-15-minutes-7dfd24a74dfe\">How to write 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\">How to publish an extension for SQL Operations Studio<\/a><\/li>\n<\/ul>\n<p>For additional resources to get started writing an extension, please refer to our <a href=\"https:\/\/github.com\/microsoft\/sqlopsstudio\/wiki\/Getting-started-with-Extensibility\">GitHub Extensibility Wiki Guide<\/a>. Feel free to also reach out to <a href=\"https:\/\/twitter.com\/sqlopsstudio\">@sqlopsstudio<\/a> on Twitter if you need help getting started after checking out these resources.<\/p>\n<p>In addition to adding new extensions, we also brought updates to existing extensions, especially Server Reports. These changes include:<\/p>\n<ul>\n<li>Fixed DB Space Usage where it threw an error when database names contain special characters<\/li>\n<li>Changed DB Space Usage and DB Buffer Usage to show only top 10 data<\/li>\n<li>Updated ReadMe to reference <a href=\"https:\/\/www.sqlskills.com\/help\/waits\">Paul Randal\u2019s wait types library<\/a> for more info about the Wait Counts widget<\/li>\n<\/ul>\n<p>As we build out our extensibility story, we will continue to collaborate with the community to learn and improve the way we build and publish extensions. This is the way we envision bringing over SSMS features while also empowering the community to contribute and build their own extensions to share with the community.<\/p>\n<h2>Visual Studio Code Refresh<\/h2>\n<p>One of the most significant highlights of this release is the Visual Studio Code 1.21 platform source code refresh. Since we fork from VS Code, we do these periodic updates and also get feature improvements. The key highlights with this refresh specifically for SQL Operations Studio are:<\/p>\n<ul>\n<li>Improved large and protected file support for saving Admin protected and &gt;256M files within SQL Ops Studio<\/li>\n<li>Integrated Terminal splitting to work with multiple open terminals at once<\/li>\n<li>Reduced installation on-disk file count footprint for faster installs and startup times<\/li>\n<\/ul>\n<p>For additional details, checkout the <a href=\"https:\/\/code.visualstudio.com\/updates\/v1_21\">Visual Studio Code February Release Notes<\/a>, and the <a href=\"https:\/\/code.visualstudio.com\/updates\/v1_20\">Visual Studio Code January Release Notes<\/a>.<\/p>\n<h2>Fix GitHub issues<\/h2>\n<p>Fixing user-reported issues may not always get as much recognition as new feature releases, but it is definitely worth calling out. If we truly want to be a community driven tool, we will continue to work on addressing your submitted issues. Here is a summary of issues addressed:<\/p>\n<ul>\n<li><a href=\"https:\/\/github.com\/Microsoft\/sqlopsstudio\/issues\/37\">#37<\/a> When the chart viewer throws an error, unexpected behavior occurs.<\/li>\n<li><a href=\"https:\/\/github.com\/Microsoft\/sqlopsstudio\/issues\/462\">#462<\/a> Feature Request: Option for Server Groups to be expanded by default<\/li>\n<li><a href=\"https:\/\/github.com\/Microsoft\/sqlopsstudio\/issues\/1023\">#1023<\/a> Add square brackets for ms_foreachdb call from flyfishingdba<\/li>\n<li><a href=\"https:\/\/github.com\/Microsoft\/sqlopsstudio\/issues\/1050\">#1050<\/a> Clear insights view before showing error<\/li>\n<li><a href=\"https:\/\/github.com\/Microsoft\/sqlopsstudio\/issues\/1057\">#1057<\/a> Restore and new query actions in explorer-widget are broken<\/li>\n<li><a href=\"https:\/\/github.com\/Microsoft\/sqlopsstudio\/issues\/1068\">#1068<\/a> Dashboard Output windows pops-up with error message for Azure DB<\/li>\n<li><a href=\"https:\/\/github.com\/Microsoft\/sqlopsstudio\/issues\/1069\">#1069<\/a> Connection Dialog shows Server Required error when initially displayed<\/li>\n<li><a href=\"https:\/\/github.com\/Microsoft\/sqlopsstudio\/issues\/1070\">#1070<\/a> Server Groups now require a double-click to expand<\/li>\n<li><a href=\"https:\/\/github.com\/Microsoft\/sqlopsstudio\/issues\/1072\">#1072<\/a> Select control background is semi-transparent<\/li>\n<li><a href=\"https:\/\/github.com\/Microsoft\/sqlopsstudio\/issues\/1115\">#1115<\/a> Fix all high contrast accessibility issues in sqlops<\/li>\n<li><a href=\"https:\/\/github.com\/Microsoft\/sqlopsstudio\/issues\/1101\">#1101<\/a> Extension fails to upgrade &#8220;Download Manually&#8221; link goes to wrong location<\/li>\n<li><a href=\"https:\/\/github.com\/Microsoft\/sqlopsstudio\/issues\/1103\">#1103<\/a> V Scroll not working on Home Tab<\/li>\n<li><a href=\"https:\/\/github.com\/Microsoft\/sqlopsstudio\/issues\/1104\">#1104<\/a> SQL extension tabs stopped working<\/li>\n<li><a href=\"https:\/\/github.com\/Microsoft\/sqlopsstudio\/issues\/967\">#967 <\/a>Expect query plan when select XML showplan in the result grid<\/li>\n<li><a href=\"https:\/\/github.com\/Microsoft\/sqlopsstudio\/issues\/606\">#606<\/a> intellisense &#8211; Bad suggestion for &#8216;update&#8217; command<\/li>\n<li><a href=\"https:\/\/github.com\/Microsoft\/sqlopsstudio\/issues\/1048\">#1048<\/a> Pre-login SSL\/TLS handshake error<\/li>\n<li><a href=\"https:\/\/github.com\/Microsoft\/sqlopsstudio\/issues\/1150\">#1150<\/a> Various types of query charts throw exceptions and don\u2019t render<\/li>\n<\/ul>\n<h3>Contributions and thank you<\/h3>\n<p>We would like to thank all our users who raised issues, and in particular the following users who helped contribute fixes:<\/p>\n<ul>\n<li>flyfishingdba for Add square brackets for ms_foreachdb call (<a href=\"https:\/\/github.com\/Microsoft\/sqlopsstudio\/pull\/1023\">#1023<\/a>)<\/li>\n<\/ul>\n<h2>Contact us<\/h2>\n<p>If you have any feature requests or issues, please submit to our <a href=\"https:\/\/github.com\/microsoft\/sqlopsstudio\/issues\">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 April release of SQL Operations Studio is now available.<\/p>\n","protected":false},"author":1457,"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,2409,2418],"content-type":[2448],"topic":[],"coauthors":[2487],"class_list":["post-24171","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-on-linux","product-sql-server-on-linux","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>The April 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\/04\/25\/the-april-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 April 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 April release of SQL Operations Studio is now available.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/04\/25\/the-april-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-04-25T18:00:54+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-01-23T06:51:16+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=\"6 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\/04\/25\/the-april-release-of-sql-operations-studio-is-now-available\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/04\/25\/the-april-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 April release of SQL Operations Studio is now available\",\"datePublished\":\"2018-04-25T18:00:54+00:00\",\"dateModified\":\"2024-01-23T06:51:16+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/04\/25\/the-april-release-of-sql-operations-studio-is-now-available\/\"},\"wordCount\":1394,\"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\/04\/25\/the-april-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\/04\/25\/the-april-release-of-sql-operations-studio-is-now-available\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/04\/25\/the-april-release-of-sql-operations-studio-is-now-available\/\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/04\/25\/the-april-release-of-sql-operations-studio-is-now-available\/\",\"name\":\"The April 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\/04\/25\/the-april-release-of-sql-operations-studio-is-now-available\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/04\/25\/the-april-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-04-25T18:00:54+00:00\",\"dateModified\":\"2024-01-23T06:51:16+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/04\/25\/the-april-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\/04\/25\/the-april-release-of-sql-operations-studio-is-now-available\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/04\/25\/the-april-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\/04\/25\/the-april-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 April 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 April 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\/04\/25\/the-april-release-of-sql-operations-studio-is-now-available\/","og_locale":"en_US","og_type":"article","og_title":"The April 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 April release of SQL Operations Studio is now available.","og_url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/04\/25\/the-april-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-04-25T18:00:54+00:00","article_modified_time":"2024-01-23T06:51:16+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":"6 min read"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/04\/25\/the-april-release-of-sql-operations-studio-is-now-available\/#article","isPartOf":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/04\/25\/the-april-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 April release of SQL Operations Studio is now available","datePublished":"2018-04-25T18:00:54+00:00","dateModified":"2024-01-23T06:51:16+00:00","mainEntityOfPage":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/04\/25\/the-april-release-of-sql-operations-studio-is-now-available\/"},"wordCount":1394,"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\/04\/25\/the-april-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\/04\/25\/the-april-release-of-sql-operations-studio-is-now-available\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/04\/25\/the-april-release-of-sql-operations-studio-is-now-available\/","url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/04\/25\/the-april-release-of-sql-operations-studio-is-now-available\/","name":"The April 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\/04\/25\/the-april-release-of-sql-operations-studio-is-now-available\/#primaryimage"},"image":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/04\/25\/the-april-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-04-25T18:00:54+00:00","dateModified":"2024-01-23T06:51:16+00:00","breadcrumb":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/04\/25\/the-april-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\/04\/25\/the-april-release-of-sql-operations-studio-is-now-available\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/04\/25\/the-april-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\/04\/25\/the-april-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 April 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\/24171","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\/1457"}],"replies":[{"embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/comments?post=24171"}],"version-history":[{"count":0,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/posts\/24171\/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=24171"}],"wp:term":[{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/post_tag?post=24171"},{"taxonomy":"product","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/product?post=24171"},{"taxonomy":"content-type","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/content-type?post=24171"},{"taxonomy":"topic","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/topic?post=24171"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/coauthors?post=24171"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}