This post is authored by Alan Yu, Program Manager, SQL Server.
We are excited to announce the February release of SQL Operations Studio is now available.
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 15th at Connect(), and this February release is the third major update since the announcement. If you missed it, the January release announcement is available here.
The February release includes several major repo updates and feature releases, including:
- Added Auto-Update Installation feature
- Added Connection Dialog ‘Database’ Drop-down
- Added functionality for new query tabs keeping active connection
- Fixed bugs in SQL Editor and auto-completion
For complete updates, refer to the Release Notes.
We want to use the February Insiders builds to test the auto-update feature. The 0.26.2 build will be released as an auto-update to 0.26.1 (assuming there are no issues that require publishing a new build to successfully support auto-update).
To discover updates faster, we have added auto-update functionality to ensure you have the latest version of SQL Operations Studio. A notification will pop up on the gear icon on the bottom left as shown in the image above. In addition, you can also check for updates by clicking Help on the toolbar.
Connection Dialog Database Drop-down
The Connection Dialog Database field is now a dynamically populated drop-down list that will contain a list of databases populated from the specified server.
New query tabs keeping active connection
A top voted feature by our users was for new query tabs to keep their active connection. In the February release, users can now click on a server name and press Ctrl + N, which will create a new query tab and retain the active connection instead of having to manually set the connection. This can be seen in the gif below.