Dec 182018
 

Azure Data StudioAzure Data Studio (formerly Microsoft SQL Operations Studio) is Microsoft’s new “cross-platform, lightweight tool for modern database development and operations.” It is not a replacement for SQL Server Management Studio (not yet anyway), but I can see it becoming one over time. It is under constant development and improvement, and if you tried it back when it was first released and didn’t like it, I urge you to give it another spin. I find myself using it more and more because I really like the feel of it.

One thing about Azure Data Studio I’m not too keen about, though, is that many of the keyboard shortcuts are different. One keyboard shortcut that’s particularly helpful to me is using Ctrl + E to execute queries. I realize that F5 is the most common key to execute a query, however on most laptop keyboards you now need to hold an additional key to make the function keys behave like function keys. For this reason, Ctrl + E is a wonderful and quick alternative, but it doesn’t work in Azure Data Studio. Or didn’t, until now.

Fortunately, Azure Data Studio is designed to be expanded upon with extensions from both Microsoft and the community. In the case of keyboard shortcuts, a particularly helpful one is called SSMS Keymap, which ports many popular SSMS keyboard shortcuts into Azure Data Studio. With this extension,  Ctrl + E is once again an option, and I no longer have to click “Execute” with a mouse, or fumble to find my laptop’s F5 equivalent.

If this sounds appealing, try installing the SSMS Keymap extension yourself. Here’s how:

At the toolbar on the left, click the “Extensions” icon, or type Ctrl + Shift + X. This will open the Extensions view.

In the Extensions search box, start typing “SSMS Keymap”. The SSMS Keymap extension should appear in the results.

 

Clicking on the SSMS Keymap result will bring up a screen with more information about the extension. Clicking the green “Install” button will redirect you to the SSMS Keymap GitHub page, where the actual .vsix installer file can be downloaded. Download it.

At the top of the Extensions view is an ellipsis. Click it, and then choose Install from VSIX. Select the .vsix file you downloaded.

Azure Data Studio will prompt you to restart.

Congratulations, you did it! Now you can enjoy the SSMS keyboard shortcuts you love in Azure Data Studio!

 

 Leave a Reply

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code class="" title="" data-url=""> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong> <pre class="" title="" data-url=""> <span class="" title="" data-url="">

(required)

(required)