SQL OPS Studio Review

What is SQL OPS Studio and why do we need it?

So What is SQL OPS Studio ? It is s a free, cross-platform tool that can be used to manage SQL Server, Azure SQL Database, and Azure SQL Data Warehouse. It is very light weight and is very fast. When I first heard about OPS Studio the first thing that came to mind was why we need another SQL Server GUI tool since SQL Server comes with SQL Management Studio and there are dozens of SQL Server GUI tools on the market. You can download this from Microsoft.

The main reason is that SQL Management Studio only runs on Windows. If you have SQL Server installed on Linux, you are out of luck. SQL OPS Studio runs on Windows, Linux and MAC OS. SQL OPS Studio is much faster and allows you to the the same things and SQL Management Studio and More.

To connect to a SQL Database simply enter the server name or IP address, select the authentication type and an optional database and click connect. Once connected, you can run queries and perform SQL Server administration tasks.

One really nice feature is the once your query executes, you can click on one of the icons on the right and save the results as CSV, JSON or an Excel file. You can also Create and manage databases, browse database objects, edit data directly in a cell and manage database connections. The Database Dashboard is a very nice interface that allows you to perform database tasks on your currently selected database.

The database dashboard is nicely laid out and performs database administration tasks much quicker than SQL Management Studio. SQL OPS Studio also has many customized settings options. There are also extensions you can download that produce very nice database informational charts.

SQL OPS Studio also has an Integrated Terminal that allows you to use your favorite command-line tools (for example, Bash, PowerShell, sqlcmd, bcp, and ssh) in the Integrated Terminal window right within the SQL Operations Studio (preview) user interface.

The Explain tool gives you a graphical presentation of your query

Microsoft SQL OPS Studio isn't the greatest tool I have used but it's very good and requires less overhead than SQL Management Studio. It's very fast, easy to use and works on Windows, Linux and MAC OS. You can also use built-in or custom widgets to provide graphical representations, analyze slow queries and a lot more.

If you haven't tried this yet, I highly recommend it.