I wonder what SSMS can do that this can't? SSMS is not cross platform as far as I know, whereas this is. Would be nice if they elaborated on the differences and pros/cons.
Ssms has menus and GUIs and such for all the non database SQL Server items like SSIS, SSAS (full cube browser), SQL agent, CLR, plus creating more advanced objects like Credentials and application roles and scenarios like suggesting indexes and performing DB maintenance.
This is purely a database development tool, at least in its current form.
On my first cursory glance: no table designer, no execute stored procedure GUI
There's a lot of little things I wish SSMS had/did (like inline text search for sproc/table) and was hoping this would have it. The execution plan screen (explain in this IDE) is a lot cleaner, though.
I use a combination of SQL Hunting Dog http://sql-hunting-dog.com/ (quick search all object names) and a SQL script from the (free) SSMSBoost plugin that looks at most object definitions but not table columns unfortunately. I've used Red Gate's SQL Search in the past but it's always been slow and buggy over the VPN.
If you're looking for a better execution plan utility, check out SQL Sentry's Plan Explorer. It's free.
In the object explorer just some text input that would filter accordingly. Some of our databases have a TON of tables/sprocs and it would be a nice convenience.
SQL Hunting Dog looks exactly like what I've been wanting, thanks for the recommendation!
I use DBeaver for cross platform support of SQL Servr at work. Obvious missing things like Query Plan support and all the newer goodies. For basic query design and ad hoc work it's great.
This is purely a database development tool, at least in its current form.