[crawrey]

DataGrip is great.

My previous workplace used to be locked into the Microsoft ecosystem and the core legacy product was backed onto a Microsoft SQL Server DB.

Over the years we pushed the business to move away from the MS/Windows ecosystem. When this happened, like many others, I looked for a UNIX compatible DB client that supported SQL Server.

First, I tried SQuirreL[1] and it was horrible. I just had to uninstall it and keep looking. I settled on DBeaver for a while as it has some nice features and it did most of the things I needed it to, but it was not particularly polished.

Eventually the business decided to pay for Jetbrain's All Products package which includes DataGrip and from my experience you could say: Eclipse is to IntelliJ IDEA what DBeaver is to DataGrip.

The other product I was looking closely at was Navicat for SQL Server[2], which looks pretty damn good and those who use it seem to swear by it. However, I am not a DBA and for that reason I can't justify the USD$699 personal licence price tag of Navicat.

DataGrip is not perfect, but it's pretty damn close and I think its price tag is well justified.

1. http://squirrel-sql.sourceforge.net/

2. https://www.navicat.com/en/store/navicat-for-sqlserver/

[worble]

I've never personally used it, but I'm fairly sure you can use Azure Data Studio[0] for plain MSSQL databases, despite Azure being in the name. I'd be in interested in what people think of it, since I've never seen anyone talk about this in the wild.

[0]https://github.com/Microsoft/azuredatastudio

[sixdimensional]

I paid for and use Navicat and it has always been stable, fast and good. A little pricey as you say, but good.

[h1d]

Have you tried TablePlus? (Not the author but just want to know the experience if you have.)

[crawrey]

I haven't! But I was reading about it on this day as well and it looks well received, so I definitely want to give it a shot when I need to regularly use a DB tool again.