Had a real fun time showing off a series of tips & tricks yesterday, and we did it all in 15 minutes!
I can’t afford Mike Rowe or Morgan Freeman for voice over talent, so unfortunately this video has my voice.
The things I show in this video, in blog form:
- SQL History Recall
- SQL Code Templates
- Joining multiple tables in a SELECT
- Query Builder
- Code Snippets
- Completion Insight
- SQL Text Expansion
I hope my voice is at least clearer now than it has been in previous recordings. I picked up a cheap new headset/mic from Microsoft of all places, and it seems to work really well.
I noticed that when I type “ssf”, I get the “SELECT * FROM table” in a grey auto-complete bar just below the “ssf” line, and ctrl- space bar doesn’t work. If I get rid of the auto-complete line, then ctrl-space bar works.