Andrea Allred (@RoyalSQL) just gave her SQL tips and tricks session at SQL Saturday Salt Lake City, and a great time was had by all! I learned some things I didn’t know – see her upcoming September 19 presentation of this session.
And, I got to give a few tips myself. She was particularly happy with the custom “change connection” shortcut. Here’s that blog:
And a few bonus tips:
- Dock Object Explorer on the right side so you don’t overlap so much code (thanks for the tip, @AndyMallon)
- CTRL-W to select a word
- CTRL-E to run your code
- CTRL-U to change DBs
- CTRL-G line numbers
- IF 1=2 — this is a safety measure
update table set ID = 1; — this is a dangerous unfinished query - Alt-space-N to minimize the whole window (Windows)
- Ctrl-s for save
- Shift-F10 for right click