Flipping Sides in SQL Operations Studio

I’ve been starting to use SQL Operations Studio (SOS) a bit more. This is a small, lightweight editor that is based on Visual Studio Code. It’s fairly limited, though it’s still in preview. You can download it and give it a try.

One of the things that I like is a consistent UI when writing code. I often hide the OE in SSMS, but I don’t want code moving left and right when I’m working with it. That can be a little jarring.

When working in SOS, I usually start with a query, and no blades (panes?) open. My workspace looks like this.

2018-07-09 20_02_47-● SQLQuery1 - SQL Operations Studio

If I need to commit to version control, I’ll click that button, but then my code moves. (I’m really not committing this query. It’s just an example.

2018-07-09 20_04_12-SQLQuery1.sql - SQL Operations Studio

The process is just a little distracting to me, especially if I make the pane wider to more easily see the Object Explorer or file list. I didn’t like this in Visual Studio Code when writing PoSh or Python, and I don’t like it here.

Switching Sides

Someone on Twitter posted a couple neat tricks, one of which was moving the panes to the right side. I know some panes in SOS, like the connection one, are always over there, but you can move the main panes.

I’m surprised I didn’t see it, but I really never even thought about this being an option. I was just annoyed.  If I’d looked in the View menu, I’d see “Move side bar right”. If I do that, I get this.

2018-07-09 20_10_49-SQLQuery1.sql - SQL Operations Studio

I could also fine this in the command palette

2018-07-09 20_11_25-SQLQuery1.sql - SQL Operations StudioThe other cool trick doesn’t do much in SOS yet, but it works in Visual Studio Code. I’ll show it there.

If I create a new file, VSCode doesn’t know what I’m doing. About half the time I’m writing Python, but I don’t get any of the intellisense or other features unless I save the file and give it a type.

The other option, is to click the language name in the lower right corner. In the image, I’ve clicked the “PowerShell” and this opens a list of languages. Type “py” and get Python.

2018-07-09 20_13_17-Untitled-1 - Visual Studio Code

Cool tricks. I expect that over time SOS will have more than just the “mssql” is has now. I’d expect MySQL, PL/SQL, and more.


About way0utwest

Editor, SQLServerCentral
This entry was posted in Blog and tagged , . Bookmark the permalink.

2 Responses to Flipping Sides in SQL Operations Studio

  1. Jonathan Cox says:

    Good stuff. I found an excellent write up on specifying a default language type for new files in VS CODE as well. https://sqldbawithabeard.com/2017/04/24/setting-the-default-file-type-for-a-new-file-in-vs-code/


  2. way0utwest says:

    LoL. that’s on my list as well. Or maybe scheduled already.


Comments are closed.