Tag Archives: JSON

How to edit a connection in Azure Data Studio

Did you ever want to rename an existing connection in Azure Data Studio? Unfortunately as of today (April 2020), there is no way to modify an existing connection group or data source connection using the GUI. 

Luckily for us, Azure Data Studio (ADS) is a very powerful and flexible tool that allows us to modify many settings without the need for a GUI. All these changes can be made simple updating the settings.json file. Honestly, though, you don’t need to be an expert in JSON to make modifications to this file. I will do my best to explain to you how to take care of these changes easily and quickly.

Continue reading

Creating Wait stats widget on Azure Data Studio for macOS

A couple of weeks ago, Microsoft released a new multi-platform tool called Azure Data Studio, this tool is the final version of SQL Operations Studio. If you are familiar to SQLOps, you probably recall that this tool 100% open source, and because of that you can customize the JSON code to do certain things the way it works best for you.

In my personal opinion, this is of the best features of Azure Data Studio are widgets. It gives the option to DBA’s or Database developers to create their own custom widgets to access SQL Server data using simple charts. The old out of the box SSMS Instance reports are good in some way, when you require to check something really quick but the lack of customization and the time they take to load doesn’t make them a really good troubleshooting tool … at least for me. I know how they work and even know how to build a custom report but I think the interface is not that responsive in my personal opinion, when dealing with an issue we need something really really fast.

Continue reading