Customizing SQL Operations Studio

Recently I wrote a post on SQL Operations Studio. I’ve been using it pretty heavily for the past week and I’ve got to say, the honeymoon phase is not over yet. I still think it is an awesome SQL editor and it has been my go-to IDE for writing queries and stored procedures.

I still occasionally have to open SSMS as I am working on a project which involves configuring SQL Server AlwaysOn Availability Groups but, that’s ok. I knew going into it that this was not going to be a full-on replacement for SSMS.

After using SQL Ops Studio more regularly, I realized there were a couple customizations that were must haves for me. By default SSMS has two keyboard shortcuts for executing a query, F5 and Ctrl+E. I found that I would use the latter much more frequently as it would not require me to lift my left hand from the keyboard. I would also frequently use Ctrl+R to show and hide the results pane. Unfortunately, SQL Ops Studio does not have these shortcuts by default but, like Visual Studio Code, this is easily remedied.

Remember SQL Operations Studio is built off of the same shell as Visual Studio Code. For this post, that means two key things. First, both are built with Electron which makes them cross platform. To highlight this, I will be focusing the remainder of the post on my Mac. Second, most of the core functionality that is available with Visual Studio Code is also available in SQL Operations Studio. Of course, this includes customizing keyboard shortcuts.

You can access the Keyboard Shortcuts by pressing Cmd+K, Cmd+S. Or if you are like me, you will get there by using Command Palette (Cmd+Shift+P).

Screen Shot 2018-08-30 at 9.02.46 PM

Specific commands can be found by typing into the search bar. Once the command is found you can click the pencil on the left to override the keyboard shortcut.

Screen Shot 2018-08-30 at 9.03.48 PM

Looking at your keyboard shortcuts file (keybindings.json), you can see all of the commands that you have overridden. When you override a default shortcut, an entry in the keybindings.json file will be added to bind your shortcut and also remove the default one. If you would like to add a new shortcut and keep the default one, you can manually customize the json file.

In my case, there are three commands I have customized.

Screen Shot 2018-08-30 at 9.05.10 PM.png

Now I can enjoy the fresh new SQL Operations Studio IDE while continuing to use all the same keyboard shortcuts that I am used to! Lastly be sure to check out the latest August update here.