When comparing Microsoft SQL Server Management Studio (SSMS) vs QueryPie, the Slant community recommends QueryPie for most people. In the question“What are the best SQL Clients for Windows?” QueryPie is ranked 3rd while Microsoft SQL Server Management Studio (SSMS) is ranked 9th. The most important reason people chose QueryPie is:
The default color is dark and comfortable for the eyes.
Specs
Ranked in these QuestionsQuestion Ranking
Pros
Pro Can work for other databases if Linked Servers are used
Pro Great for SQL Server
Pro Clean and pretty UI/UX
The default color is dark and comfortable for the eyes.
Pro Multiple Query Tabs!
The multi-tab and multi-SQL-runs are great. It's always good to be able to compare results in one window instead of having to go through and re-run stuff.
Pro Fast Auto-complete
Pro Multiple Databases
They only support 2 at the moment (MySQL and MariaDB) but their social site says they'll be updating with more DBMSes in the near future which is pretty nice because I hate learning new GUIs~
Pro Cross-Platform
Not sure about Linux but it works on Windows and Mac just fine!
Pro Free!
Cons
Con Bloated
SSMS eats up a lot of disk space and memory, but Microsoft seems to have addressed the issue in the newest version, quote "The current size of the bundle is less than half of what SSMS 17.x is (~400 MB). The size will eventually grow a little when the IS components are added back to SSMS, but it should not be as large as it used to be."
https://docs.microsoft.com/en-us/sql/ssms/sql-server-management-studio-changelog-ssms?view=sql-server-2017
Con Doesn't natively support other databases
SSMS is aimed at SQL Server.
Use of Linked Servers will give you some access to query other types of DBs using the tool, but this is a workaround.
Con Requires creating an account
Requiring an account is rare on SQL IDEs...