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:
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!