News

Microsoft Rolls Out Second Update to SQL Operations Studio

The latest improvements to Microsoft's SQL Operations Studio (MSOS) are now available, marking the data management tool's second update since its public preview debut at November's PASS Summit.

MSOS is a lightweight, cross-platform offering that combines functionality found in tools like the Visual Studio Code editor and SQL Server Management Studio (SSMS). It's aimed at helping data developers and operations pros work with SQL Server, Azure SQL Database and Azure SQL Data Warehouse on Windows, Linux and Mac machines.

According to its GitHub site, MSOS includes the following features:

  • Cross-platform database management for Windows, macOS and Linux with simple XCopy deployment
  • SQL Server Connection Management with Connection Dialog, Server Groups, Azure Integration and Registered Servers
  • Object Explorer supporting schema browsing and contextual command execution
  • T-SQL Query Editor with advanced coding features such as autosuggestions, error diagnostics, tooltips, formatting and peek definition
  • Query Results Viewer with advanced data grid supporting large result sets, export to JSON\CSV\Excel, query plan and charting
  • Management Dashboard supporting customizable widgets with drill-through actionable insights
  • Visual Data Editor that enables direct row insertion, update and deletion into tables
  • Backup and Restore dialogs that enable advanced customization and remote filesystem browsing; configured tasks can be executed or scripted
  • Task History window to view current task execution status, completion results with error messages and task T-SQL scripting
  • Scripting support to generate CREATE, SELECT, ALTER and DROP statements for database objects
  • Workspaces with full Git integration and Find In Files support to managing T-SQL script libraries
  • Modern, lightweight shell with theming, user settings, full-screen support, integrated terminal and numerous other features
[Click on image for larger view.] Microsoft SQL Operations Studio. (Source: Microsoft)

New features and updates coming with the new January update, meanwhile, include:

  • Enable the HotExit feature to automatically reopen unsaved files.
  • Add the ability to access saved connections from Connection Dialog.
  • Set the SQL editor tab color to match the Server Group color.
  • Fix the broken Run Current Query command.
  • Fix the broken pinned Windows Start Menu icon.

"A highly requested feature for SQL Operations Studio is to remember unsaved changes when the program is exited, similar to VSCode and other editors," the SQL Server team said in a blog post last week about that first new feature listed above. "We are excited to announce that HotExit has been enabled," the post said, referencing an animated GIF that shows how a user can quit MSOS and simply reload it again to retain the unsaved query.

More about that feature and other information is available in the release notes.

About the Author

David Ramel is the editor of Visual Studio Magazine.

Featured

  • Microsoft Highlights Emerging Kubernetes Scalability and Governance Efforts

    Microsoft this week highlighted some emerging efforts to improve both the scalability and governance of the open source Kubernetes container orchestration service.

  • Microsoft Ending Azure Container Service Support in 2020

    Microsoft gave notice earlier this month that it will be ending its Azure Container Service on Jan. 31, 2020.

  • Microsoft Releases Surface Diagnostic Toolkit for Business

    Microsoft released a new tool, Surface Diagnostic Toolkit for Business, earlier this month, providing a means for IT pros to find and troubleshoot problems on Microsoft Surface devices.

  • How To Enable Guest Access for Office 365

    While it's possible to give outside users access to certain content in your organization's Office 365 environment, the process of setting them up requires a few extra steps.

comments powered by Disqus
Most   Popular

Office 365 Watch

Sign up for our newsletter.

Terms and Privacy Policy consent

I agree to this site's Privacy Policy.