This blog post was authored by Alan Yu, Program Manager, Microsoft SQL Server.
We are excited to announce the January release of SQL Operations Studio is now available.
Download SQL Operations Studio and review the release notes to get started. 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 Github.
SQL Operations Studio was announced for public preview on November 15, 2017 at Connect(), and this January release is the second major update since the announcement. If you missed the December release announcement, you can learn more on the SQL Server blog.
The January release includes several major repo updates and feature releases, including:
- 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.
For a complete list of updates, please refer to the release notes.
A highly requested feature for SQL Operations Studio is to remember unsaved changes when the program is exited, similar to VSCode and other editors. We are excited to announce that HotExit has been enabled as demonstrated in the GIF above. SQLQuery2 represents an unsaved query, and the user can quit SQL Operations Studio and simply reload it again to retain the unsaved query.
This feature is not enabled by default. To enable HotExit by default, go to Settings with Ctrl + , and copy “files.hotExit”: “onExit” into your settings.
Saved connections available in Connection Dialog
The Connection Dialog now contains a “Saved Connections” tab next to “Recent Connections”. This contains a list of saved server connections from the server’s “Object Explorer” viewlet, as well as the Server Group.
SQL editor tab color to match Server Group color
SQL query editor and dashboard windows will have the same color as the Server Group used to open the window. This feature is not enabled by default. To enable Tab Colors by default, go to Settings with Ctrl + , and copy “sql.tabColorMode”: “fill” into your settings.