Azure Data Studio provides a lot of Extensibility options and its Extension Model is actually my favorite feature of this tool. There is no need of huge software installs and in the process getting tools/functionalities which you don’t require. The base install of Azure Data Studio is very small & lightweight. With Azure Data Studio you can customize your environment with the tooling you need. Extensions provide an easy way to add more functionality to the installation.
Azure Data Studio
I am glad that the Connection Dialog improvement has been now incorporated in the February Public Preview of SQL Operations Studio. The database name is now dynamically populated based on the selected server.
SQL Ops Studio now has a built in notification system to alert users when there are updates for new releases. Whenever you start SQL Ops Studio, it automatically checks for updates and pops up a toast notification to the user on the gear icon on the bottom left informing that an update is required.
The initial January release insiders build of SQL Ops Studio focuses on bug fixes and minor feature improvements. One thing which caught my attention was the ‘SQL Editor Tab Color’ to differentiate between query tabs inside the IDE.
In the January Release, there is a new tab called as ‘Saved Connections’ – which displays the list of saved server connections you have. This is a nice add-on to the Connection window and will give incentive to the user to be organized inside the SQLOps Studio interface by leveraging the ‘Server Group’ feature.
Microsoft SQL Operations Studio is forked from Visual Studio Code, and hence is extremely light weight, customizable and easy to use. The amount of customization you can do are endless, and once you start playing with this tool you will realize its true potential. In this article, I will focus on a feature which has been one of the topmost request in the Connect site for SSMS – the Dark Theme.
Today Microsoft announced the Public Preview of their free lightweight cross platform tool called as ‘SQL Operations Studio’. It runs on Windows, macOS and Linux for SQL Server, Azure SQL Database and Azure SQL Data Warehouse. There was already a lot of excitement about this tool in the community after it was announced during the PASS Summit by Rohan Kumar.
One of the biggest highlights of SQL Server 2017 is its cross platform support – you can run your workloads on not only Windows, but also Linux and Docker containers. This enhances the need of a cross platform tool which can ideally replace SSMS in near future, if not at least assist Developers/DBAs who would require to work on multiple platforms and provide more in-built capabilities.