Writing a SQL Operations Studio Extension in 15 minutes

The extension: SSMS Keymaps

Creating a new extension project

npm install -g yo generator-sqlops
yo sqlops

Adding a keyboard shortcut

"contributes": {  "keybindings": [    {      "key": "shift+cmd+e",      "command": "runQueryKeyboardAction"    },    {      "key": "ctrl+cmd+e",      "command": "workbench.view.explorer"    },    {      "key": "alt+f1",      "command": "workbench.action.query.shortcut1"    },    {      "key": "shift+alt+enter",      "command": "workbench.action.toggleFullScreen"    },    {      "key": "f8",      "command": "workbench.view.connections"    },    {      "key": "ctrl+m",      "command": "runCurrentQueryWithActualPlanKeyboardAction"    }  ]}

Packaging the extension

npm install -g vsce
"repository": {    "type": "git",    "url": "https://github.com/kevcunnane/ssmskeymap.git"},"bugs": {    "url": "https://github.com/kevcunnane/ssmskeymap/issues"},

Publishing your extension to a marketplace

Next Steps — contributing to SQL Operations Studio

--

--

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store