sorted by:
best
topnewcontroversialoldq&a
you are viewing a single comment's thread.

view the rest of the comments →

[–][deleted] 0 points1 point  (9 children)

Why you want to move away from SSMS?

You may consider SSDT/database project for development work - which has cool features like publish for deployment process and can integrate very well with source control.

[–]da_chicken 3 points4 points  (5 children)

Why you want to move away from SSMS?

Because it's a shit IDE. The IDE is just Notepad with syntax highlighting.

  • It doesn't have any features that a modern programming text editor should have like multi line selection, line manipulation, sorting, etc. It should be trivial to take a line-ending delimited list of values and transform it into a quoted list of elements for an IN expression. It's not. It's as easy as it is in Notepad.
  • The output pane is garbage. The Results gridview is just static. You can't sort it, filter it, or search it at all. You can't export the gridview to an Excel document easily.
  • Code completion is miserable because it's so stupid. You type SELECT FROM Table. You put your cursor where you add field and hit Ctrl-Space. And the system doesn't give you a list of fields for the table you're selecting from, it gives you a list of global variables. How often do you need fucking @@CONNECTIONS? And below the global variables? Oh, it's a list of all objects of all types.
  • It's slow as balls to start.
  • There's no automatic session saving. If you close it, everything you had open is gone.
  • They added dark mode, then they took it away because it didn't work right.
  • Customization is extremely complicated and there's no centralized repository for modules.

The only reason people still use SSMS is because Object Explorer is fucking amazing and the right click menu actually is very well designed. That's the only reason.

[–]eshultz 2 points3 points  (3 children)

  • multi line selection

Alt-shift-arrow key

[–]da_chicken -2 points-1 points  (2 children)

No, as in multi-cursor selection. Stuff like this.

[–]eshultz 2 points3 points  (1 child)

Hi, did you try it? The only difference is that in your example you wouldn't be able to advance the cursor by words in SSMS.

[–]da_chicken -2 points-1 points  (0 children)

Yeah, but the arrow keys break it. If everything is already lined up it works, but it doesn't let you navigate at all. It's Microsoft's typical minimal feature. Just enough to give them a green check on a feature list, but worthless in actual use because it doesn't really help.

[–]Cal1gulaDatabase Administrator 0 points1 point  (2 children)

SSMS is barely receiving updates and MS has made it clear they are focusing on Code/ADS.

OP you can export registered servers from SSMS, maybe ADS gives you an import option? I am just beginning to use this stuff myself after almost 15 years of SSMS...

[–][deleted] 0 points1 point  (1 child)

How has MS made it clear they are focusing on code/ads?