Hacker News Reader

Comment by severino | Hacker News Reader

I doubt any of those 100.000.000.000 commercial products that need MSSQL would run on Linux either.

In fact, even SQL Server Management Studio is a Windows-only application.

Actually a lot of them do it's not hard to find some ticketing system or a call center management system that is written in JAVA or PHP and only works with mssql or oracle dbms.

The app stack is usually more platform agnostic than you think. Even if it's asp.net you most likely going to be able to run it or easily port it to .net core.

Basically having cross platform .net is pointless without having cross platform everything else especially MSSQL.

I was surprised how easy it was to get a couple asp.net apps running under docker dotnet-onbuild base containers... I think having SQL Server under linux/docker is a really nice option. Just being able to use it with ci/cd environments in linux is a pretty big thing.

I've moved more away from the MS environments the past few years now, but have missed some of the things that MSSQL makes very easy, and by comparison PostgreSQL makes relatively hard. Of course you're paying for it. Having the option to run under Linux is really nice though imho.

> but have missed some of the things that MSSQL makes very easy, and by comparison PostgreSQL makes relatively hard.

Could you give some examples?

Namely in the box replication and failover (like checkbox interaction via the GUI) compared to a hard to configure, or expensive to license add-on.

IIRC geo indexing was easier in mssql, although much more configurable in pgsql.

Not on pg, but linq to entities for .net is really nice, and the pg adapter (iirc) wasn't nearly as good. The node adapters for each are about equal though.

Out of the box performance on mssql, and query performance in general was better last time I compared (admittedly about 2 years ago).

They don't have to. Let's say an enterprise wants to go start moving its backend to the cloud. Now there is a very significant price difference between windows instances and Linux instances. The client commercial product can still run on Windows and the database in Linux

For that matter, it's been surprisingly easy to get ASP.Net apps to run with mono or .net core in some cases. ymmv of course, and the performance will vary, but it's an option.

Not Windows-only anymore. Microsoft is releasing various tools such as SSMS for Linux too.

No, currently, it is windows only. Maybe, someday, we can say it's not windows-only anymore. But not today.

Even then... you don't need the DB and SSMS to be on the same box.

The installs are on separate ISO's now if I'm not mistaken...

I believe so yes, it's still not a terribly pleasant experience but WAY better than it was.

I'm wondering if MS will go the electron route for SSMS, considering how well it's worked out for VS Code.

VS Code now has an extension for querying against MSSQL that's cross platform.

https://marketplace.visualstudio.com/items?itemName=ms-mssql...

Still missing several things that SSMS has, but it's a nice start!

Very nice, I was actually meaning it would be a nice to see a full-blown application similarly... just the same, nice to see the extension in VS Code. Consistently impressed with the application, but would like the original multi-doc behavior back over tabs.

There are also alternatives to SSMS that run on Linux, like JetBrains DataGrip.

DataGrip is great, but it's got a long way to go before it's comparable to SSMS.

what is it missing ?

SQL Agent support is a pretty glaring omission, to be fair they don't support pgAgent either so I regularly end up needing to fire up SSMS or pgAdmin to configure maintenance and summarization jobs.

Reply on news.ycombinator.com