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.
I'm slightly confused by the combination of "introduced in Internet Explorer 5.5" and "offers a powerful new way" being written in an article posted on August 28, 2017
FTA: cough OK, obviously it’s 2017 and Internet Explorer 5.5 isn’t relevant anymore. But if you’re a Web developer, this should have given you some pause for thought. The modern Web Components pillars: Templates, Custom Elements, Shadow DOM, and Imports, were all features originally in IE5, released in 1999.
haha, it really was too, no hint of sarcasm! Young'uns these days probably can't believe what a saviour Microsoft from the clusterfudge that Navigator represented back then.
"Which of the five options for GIF recording do you recommend" is still a valid question though, no? Why not save everyone the time of trying all five themselves?
I've never heard it referred to as revision control - I always hear "version control" or even "source control". Any difference? Is that a common phrase?
