SQL Operations Studio (preview) is a free tool that runs on Windows, macOS, and Linux, for managing SQL Server, Azure SQL Database, and Azure SQL Data Warehouse; wherever they’re running.
SQL Operations Studio (preview) is built on top of Visual Studio Code and offers a lightweight, keyboard focused modern code workflow experience when working with SQL.
It has the following capabilities:
- Transact-SQL (T-SQL) code editor with IntelliSense
- Smart T-SQL code snippets
- Customizable Server and Database Dashboards
- Connection management (server groups)
- Integrated Terminal
You can download your (preview) version here: https://docs.microsoft.com/en-us/sql/sql-operations-studio/download
After you install and run it, you will see the following screen:
Then, when you connect it to a SQL Server instance it shows the following:
And… you can find it on GitHub here:
https://github.com/Microsoft/sqlopsstudio
There are a lot of really cool features in SQL Operations Studio, like for example creating Insight widgets…
Insight widgets take the Transact-SQL (T-SQL) queries you use to monitor servers & databases and turns them into insightful visualizations.
Learn more about it here: https://docs.microsoft.com/en-us/sql/sql-operations-studio/what-is
How amazing is this!