SSMS: Sql Server Management Studio notes

satya - 1/4/2020, 12:05:27 PM

Installation notes on SQL Server and SSMS

Installation notes on SQL Server and SSMS

satya - 1/4/2020, 12:09:41 PM

Some key shortcuts

1. Ctrl-O :Open a file. Useful to open .sql files where they can be edited in an intellisense manner. This command is context aware and opens a new file browser in a location that is similar to the file you are in or last visited.

2. Ctrl-space while in an opened file tries to give you options.

3. ctrl-shift-r: caches meta data so that ctrl-space is more accurate.

4. I, for now, write code first in vscode and keep the files in a repo managed by vscode. I then open those files using ctrl-o in ssms. Perhaps there is a better way to debug these in vscode itself or open a project in ssms or visual studio. Exercise for some other time.

satya - 3/22/2020, 5:38:58 PM

Ctrl-N:Open a new query editor on the current connection

Ctrl-N:Open a new query editor on the current connection

satya - 3/22/2020, 6:41:18 PM

Ctrl-O: open a file on the local file system

Ctrl-O: open a file on the local file system

satya - 3/22/2020, 6:41:45 PM

Ctrl-Shift-R - Refresh the IDE to see what is added most current

Ctrl-Shift-R - Refresh the IDE to see what is added most current