Microsoft finally has launched most awaited tool – SQL Operation Studio (aka OpsStudio)!!!
SQL Operation studio is a lightweight open source multi-os and multi-RDBMS tool. It provides a modern & intuitive database management experience on their platform of choice to DBAs, Developers, and Sysadmins. It also simplifies configuration, management and monitoring and troubleshooting for SQL database everywhere. OpsStudio is fully extensible through open source.
You can download the tool from the link: https://docs.microsoft.com/en-us/sql/sql-operations-studio/download. Once you install it successfully, you will get the window like below image. Let’s understand the parts of the tool;
- Activity Bar: It has set of navigation buttons that provide quick access to Server Groups, File Explores, Search and Source Control view.
- Side Bar: When you click on the Activity Bar buttons, it displays extra details of Server Group, Search, Files and Source control.
- Tab Editors & Dashboards: Tab Editors is the area where you can edit files, and the Dashboard provides context-specific task lunch points and shows general health status reports.
- Panel: It provides an integrated terminal like cmdlet, PowerShell, Bash.
- Server Group Actions: It provides you three options – New Connection | New Server Group | Show Active Connection. You can think it as object explorer with the notion of registered servers.
- New Connection Layout: When you click on the New Connection button, you will get the New Connection Layout. Here, you can
- Connect to new server,
- Can create New Server Group or can add new server to the existing Server Group
- Can see Connection Recent history.. much more information
What all the things you can do with tools?
As Microsoft is aiming to offer customers a tool that can be used on any platform of their choice for their scenarios. It means this tool may be offering more features then what we have in SSMS as of now. If we look at the very high-level features of the tool, you will find;
- Connect to DB
- Smart T-SQL code snippets
- T-SQL Editor
- Intellisense
- View & Export results
- View & Edit Data
- Backup/Restore
- DB Config & Maintenance
- Generate T-SQL Scripts
- PowerShell
- Cmdlets
- Bash Script
- Inbuilt Reports
- Monitoring ( Live, Historical, Static Snapshots)
- Performance Troubleshooting
- Performance Tuning
The list goes on and on…..
To learn more about the OpsStudio tool, kindly follow the link https://docs.microsoft.com/en-us/sql/sql-operations-studio/what-is
Hope, enjoyed learning of the new OpsStudio tool.
