We are excited to announce the June 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 June release is the seventh major update since the announcement. If you missed it, the May release announcement can be viewed here.
The June public preview release is focused on improving our Extensibility experience with the release of new extensions as well as addressing top GitHub issues.
Highlights for this build include the following.
- SQL Server Profiler for SQL Operations Studio Preview extension initial release
- Azure SQL Data Warehouse extension
- Edit Data Filtering and Sorting
- SQL Server Agent for SQL Operations Studio Preview extension enhancements for Jobs and Job History views
- Build your own SQL Ops Studio extension
- Visual Studio Code Refresh
- Fix GitHub Issues
For complete updates, refer to the Release Notes.
SQL Server Profiler for SQL Operations Studio Preview
The SQL Server Profiler for SQL Operations Studio Preview extension is now available in the Extension Manager. This is the initial preview release for a new lightweight XEvent-based profiler. The SQL Server Profiler extension makes it simple to quickly trace server activity for troubleshooting and monitoring.
If you want to try out the SQL Server Profiler extension, follow these instructions:
- Install the extension from the Extensions Manager.
- After you reload SQL Operations Studio, press Ctrl+Shift+P or open the Command Palette from the Gear icon on the bottom left.
- Type ‘Profiler’ and press Enter on ‘Profiler: New Profiler’
- Press start to see your Extended Events (view gif below)
We’ll continue to enhance this extension over the next couple releases. This is still a preview version and we would love to hear initial feedback from the community.
Shortly after this blog publishes, an issue will be opened in GitHub issues where we will share our design process for each screen for SQL Server Profiler. We welcome community input there as we work on improving SQL Server Profiler in SQL Operations Studio.
Azure SQL Data Warehouse Extension
Last month, the Azure SQL Data Warehouse team blogged on creating a customizable management experience with SQL Operations Studio. Instead of asking new users to manually add JSON snippets in Settings, we reached out to the DW team to see if they would be interested in building an extension to improve acquisition for users. After working with us on building a custom insight extension, the team is excited to announce the preview release of the Azure SQL Data Warehouse Extension! You can now seamlessly install the extension from the SQL Operations Studio Extensions Manager surfacing a pre-built dashboard for your data warehouse.
Once you install the extension, you simply make a connection to your SQL DW instance, view the server dashboard, and you can see the extension as a tab.
Insight widgets are generated by using T-SQL scripts embedded within SQL Operations Studio. All monitoring scripts are uploaded to the following GitHub repo: SQL Data Warehouse samples.
We are looking to improve this extension and would love to hear your feedback to improve this extension. Please feel free to contribute or provide feedback.
Edit data filtering and sorting
Edit data on a table opens the top 200 rows by default. To modify the query, click on the “Show SQL Pane” toolbar button to open the query pane. The query can be modified in the SQL editor pane to filter or sort the resultset. Check out the gif below to see this feature in action.
Build your own extension
In the last couple releases, you may have noticed how our Extensions Manager has grown with extensions created by Azure SQL Data Warehouse, Redgate, and community members. We want to continue to work with the community and our partners to create SQL Operations Studio extensions.
If you want to get started, you can learn to build a sample insight extension through our Extension Guide we created for Microsoft Build.
You can further learn how the SSMS keymap extension was created by following Kevin Cunnane’s blogs:
- Writing a SQL Operations Studio extension in 15 minutes
- Publishing an extension for SQL Operations Studio
Both the Extension Guide and Kevin’s blog posts use the generator-sqlops yeoman generator to help make it even easier to make an extension.
If any of these extensions in this generator interest you, feel free to try it out! If you are interested in hosting your extension in our Extensions Manager or would like help building an extension, feel free to reach out to the team on GitHub or email email@example.com.
Our team also brought in Wizard and Dialog extensibility support, so feel free to reach out to us if you want to learn more and add wizards and dialogs to your extension. You can learn more here.
Want to learn more about our roadmap for extensions? Learn from our Microsoft build session if you missed it!
Visual Studio Code refresh
Since SQL Operations Studio forks from Visual Studio Code, our team periodically includes “refreshes” based on latest VS Code monthly releases. This usually brings nice features for the editor and configuration. The latest refresh picks up VS Code v1.23, which includes the March and April 2018 release.
- Easier way to open large files
- Syntax highlighting optimization
- Highlighted indent guides
- Column Selection using middle mouse button
For more information, check the VS Code release notes.
Fix GitHub issues
Here is a summary of issues addressed:
- #1204 Feature request: Please make the results grid auto-fit column width to data, and/or remember manual changes if the same query is re-run
- #1398 Should show add message and add account button when linked account is empty
- #1399 Linked account tab is broken when the view is collapsed
- #1374 SQL Tools Service crashes when opening .sql file from disk
- #1372 Missing SQL keyword “BETWEEN”
- #1395 ‘MATCH’ keyword crashes SQL Tools Service
- #1496 “New Profiler” context menu option in Object Explorer does nothing.
- #1495 Query editor “Explain” query plan is broken