What is Microsoft SQL Operations Studio?

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!