When comparing Microsoft SQL Server Management Studio (SSMS) vs FlySpeed SQL Query, the Slant community recommends Microsoft SQL Server Management Studio (SSMS) for most people. In the question“What are the best MySQL client applications for Windows?” Microsoft SQL Server Management Studio (SSMS) is ranked 10th while FlySpeed SQL Query is ranked 14th.
Specs
Ranked in these QuestionsQuestion Ranking
Pros
Pro Can work for other databases if Linked Servers are used
Pro Great for SQL Server
Pro Portable version available
The portable version is offered at $49/year or $129/lifetime.
Pro Free version
There is a free version of FlySpeed SQL Query for non-commercial purposes.
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 Commercial use requires a license
If you plan on using FlySpeed for commercial purposes, you have to purchase the product at $39-49/year or $99-$129/lifetime.