ADS Servers and switching profiles and dashboards(4/31)

Day 4 Blog post, a bit of a long one but a really cool feature I discovered, the ability to switch profiles, one for development one for presentation or even have multiple different profiles for different dashboards!

Anyway, first things first ADS allows you to set up groups of servers in the servers panel. This is stored in a JSON file located in the location below. This stores all the server connections, all the server groups, short cut keys set and many other configuration items.

C:\Users\username\AppData\Roaming\azuredatastudio\User\settings.json

Also you can stack server grouping.

{
“name”: “ROOT”,
“id”: “C777F06B-202E-4480-B475-FA416134D458”
},
{
“name”: “All Servers”,
“id”: “d6636a63-4ac6-4c69-90ea-9d01e5bafe55”,
“parentId”: “C777F06B-202E-4480-B475-FA416154D458”,
“color”: “#85AE72”,
“description”: “Place holder for all Servers”
},

servers

You can edit these through the GUI,  but you only get a choice of stock colours below

Server groups 2

However, you can set a custom colour or color by just googling the colour value you get a colour picker (and it’s spelled right as well!) #85AE72 then choose whatever colour or color you like and copy and paste back in.

 

Colour picker

Colours not for the faint-hearted!

colour picker

{
“options”: {
“connectionName”: “”,
“server”: “MartinsSQLServer”,
“database”: “”,
“authenticationType”: “Integrated”,
“user”: “”,
“password”: “”,
“applicationName”: “azdata”,
“groupId”: “C777F06B-202E-4480-B475-FA276154D458”,
“databaseDisplayName”: “”
},
“groupId”: “5b302d4e-fbdc-45f6-996b-3e94e938b61a”,
“providerName”: “MSSQL”,
“savePassword”: true,
“id”: “b276eef1-3627-4729-a528-16c402e19df3”
},

You can move, sort , order your servers based on groupID, find the groupID you want to move a server to and update. It would be a really nice feature to sort by server name or even a search facility, someone had requested such a feature on the Github page so fingers crossed.

The groups are sorted from top to bottom, so going down the setting.json file each group server grouping does not need to be next to each other, but it will order the individual group sequentially as it finds the next matching groupID.

If setting the user and password for SQL authentication only the username is stored and re-connection after closing ADS will need the password to be re-entered, unless the save password box is ticked or Savepassword is set to true, the password, however, is stored elsewhere not in plain text in the JSON file.

Really, Really cool feature

Other settings are also kept in this file, any shortcut keys you set, any dashboards you configure. I’m wondering if I can have multiple versions of this file and switch around dashboards and the like.

So it turns out you can.. this is way cool, so I created a batch file that renames the files initially and switches them around, then I thought of a better idea. I created multiple folders in the same location as the settings.json file called Development and Presentation and copied the different settings.json file into them.  Created a batch file called presentation.bat and development.bat with the following line

copy .\development\settings.json

Now I can have different profiles, if I have different themes they instantly change, I can now have specific dashboards without clustering the panel. This is fantastic.

and it keeps on evolving

It gets better and better.  If I save to my SQLPresentation folders as a Powershell script ( need to update full file paths) I can just open a terminal and type dev and tab or pr and tab and instantly change my setting, I can switch on Demo mode extension as well!

I also added two update development and update presentation as well so I can maintain changes. and being a Data person I took a backup of the files just in case I accidentally

so steps to recreate.

  1. create folders as for the profiles you want, development and presentation

switching_folders

2) Create a set of Powershell scripts as below these are as follows:-

development.ps1

copy-item C:\Users\marti\AppData\Roaming\azuredatastudio\User\development\settings.json C:\Users\marti\AppData\Roaming\azuredatastudio\User\settings.json
Update development.ps1
copy-item C:\Users\marti\AppData\Roaming\azuredatastudio\User\settings.json C:\Users\marti\AppData\Roaming\azuredatastudio\User\development\settings.json
copy-item C:\Users\marti\AppData\Roaming\azuredatastudio\User\Development C:\Users\marti\AppData\Roaming\azuredatastudio\User\backup -Force

switching

3) Update ADS to your development environment, however, you like it.

4)   Type ctrl+J and in terminal window type update and tab it will auto-complete and this copied the files to backup development folder

5) repeat step 3 for the presentation theme

6) not just type presentation.ps1 or development and it switches between the profiles

development

or

presentation

7) You can expand on this by having multiple dashboard themes, for example, performance tuning, indexing, etc. rather than cluster your server/database pains just switch between them

Some other settings and a bit of fun!.

“window.zoomLevel”: 1,

Basically says what does on the tin, same as Ctrl+ (plus) or Ctrl+ (minus) to Zoom in and out. The best bit is if you change the value in the file it instantly changes the zoom as soon as it’s saved. Now I’m not suggesting you connect to the file on a colleague’s machine download but…

This entry was posted in Azure Data Studio, Bit of fun, Configuration, SQLSaturday and tagged , . Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s