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!

Leave a Reply

Post Navigation