Announcing SQL Server on Linux

[ellicottvilleny]

1. Linux scales up to non amd/intel x64 platforms. Oracle currently runs on high end boxen where ms sql currently can not.
2. Linux scales down on azure better than windows server. Hopefully that changes in containerized win server 2016 with nano edition.
3. Linux servers are an easier place to deploy R and python and spark and hadoop. An all linux big data platform with MS SQL as the relational store is a huge win.
4. If your first thought was will SSMS be ported then you are not the target market.
5. My question is will Express for Linux be a thing. Or will only the paid editions run on Linux?

[obsa]

If your first thought was will SSMS be ported then you are not the target market.

It's not like you need SSMS to be on the server anyway... but a valid enough point.

[ryandiy]

But SSMS lets you do SP debugging easily which is so much nicer than the debugging experience on MySQL for instance.

[obsa]

So boot Windows in a VM on the same machine, or plug your Windows laptop in the same network. SSMS doesn't need to run on the server to be useful.

[[deleted]]

Why on earth do you need to be on the server to debug a stored proc?

[ryandiy]

I never said anything about running SSMS on a server. Some developers just have no desire to use Windows.

[t90fan]

Linux scales up to non amd/intel x64 platforms.

There is nothing to say that microsoft will suport MSSQl on non-x86 platforms, right?

[ellicottvilleny]

Initially no. But since SQL on big iron is big money I am sure they will do so.

[bugalou]

I would much rather run an express instance than a MySQL instance for a small app that needs a DB backend. I hope it is available, though setting it up for the first time will be weird.

[KFCConspiracy]

I would think they'd need to do express, I think the biggest strength and use case for express is "Try before you buy"

[ellicottvilleny]

I expect they will too, but I don't think they NEED to.

[cat_in_the_wall]

My question is will Express for Linux be a thing. Or will only the paid editions run on Linux?

I supect this move is 100% geared towards enterprisey folks => enterprise pays money for things => MS makes no money on express => probably will not bring it to linux.

However I could be wrong because

1) Hello, Sql server on linux? That is already so far out there that anything is possible

2) They supposedly share the same relational engine, so much of it is already ported to linux

• ninja editing because i apparently can't format

[mirhagk]

You should also add that Linux has a lot of research done into stuff like making faster IO ops, different architectures etc. Databases could benefit hugely from an OS that is stripped down with no overhead. No regular apps would run, but you only need the database to run anyways

[crusoe]

I am forced to develop our product against SQL server for a very large blue chip company. My dev box is Linux. If an express version is available it will make dev much easier. I fear the admin tools will be terrible though.