Popups… I hate them! I hate them in my web browser, and I hate them in apps.
I’ll confess, sometimes not knowing what you can customize and just working with the default settings can be a great thing. If you never customize then your experience is always the same out of the box.
I used to play video games and hated the WASD movement keys. One day I customized it to ESDF which gave me more keys at the pinky to use. Since then I cannot play a game that requires keyboard movement without first changing all of my keys… (Gamer problems right?)
A few years ago I attended a presentation about SSMS tips & tricks by Jes Borland at the PASS Summit. I used some of her tips, and found others. Now I cannot function until I get everything set up properly, so be careful going down this rabbit hole!
1) I HATE the connection window that pops up when I open SSMS.
My first problem with this is I never type the server name correctly. My second problem with this is that I can’t move the SSMS window until I either close the popup or connect to an instance. My main problem is I hate popups, period. So the first thing I do is get rid of the popups.
In the drop down you have the following options:
- Open Object Explorer (Default Behavior) – after you connect through the popup you’ll get the explorer tree.
- Open new query window – after you connect through the popup a new query window will open, but not the object explorer tree.
- Open Object Explorer and Query Window – 1 & 2 combined! But you still get the popup.
- Open Object Explorer and Activity Monitor – 1 + a pretty performance chart that may or may not be helpful.
- Open an Empty Environment! – The reason for this post. In a later post I’ll cover why this is preferred to me.
After making any of these changes you have to restart SSMS for it to take effect. In 1-4 you’ll continue to receive that initial popup to choose your connection. With number 5 SSMS will just open, popup free.
More tips will be forthcoming as I have time to capture them. Later I’ll detail how to export these changes to your environment to make setup easier later if you change PCs, but it may be worth a quick google to export your default settings in case you don’t like a change!