Live data from Hacker News

How Microsoft brought SQL Server to Linux

techcrunch.com

31–40 of 207 posts

Re: How Microsoft brought SQL Server to Linux

#31

Does anyone know whether Analysis Services and Integration Services are also going to be available on Linux? What about Windows Authentication mechanism - is it going to be available, if yes then how would a Linux box join AD domain?

> how would a Linux box join AD domain? By using Red Hat's sssd which handles it pretty much seamlessly. You get fully working Kerberos with that which should work with SQL server probably.

You get mostly working Kerberos. It's not quite that reliable.

Re: How Microsoft brought SQL Server to Linux

#32

Years ago I was part of a project that became a startup. We got a Bizspark license and originally developed for MS SQL. Later we added in support for Postgres/MySQL. Running unit tests against Postgres/MySQL was pretty easy on my Linux box, but for MS SQL I'd have to start a VM and provision SQL Server 2012 (at the time). I jumped on the Linux version as soon as I heard about it. I never got an invite to the preview,…

I'm making $86 an hour working from home. I was shocked when my neighbour told me she was averaging $95 but I see how it works now. I feel so much freedom now that I'm my own boss. This is what I do, ====http://www.smartfinancemedia.com/?682

Re: How Microsoft brought SQL Server to Linux

#33

This seems to me as some kind of defeat and that makes me sad. It's sad for me to look how great companies grew old I think Microsoft is now afraid that people (developers that were hired by enterprises) are willing to move to *nix so much so that they will force enterprises to gave up on MS stack. This way they could lose SQL Server customer and Windows customer at the same time - having SQL Server version for Linux…

You've made some big leaps if you think this is sad.

Re: How Microsoft brought SQL Server to Linux

#34

This seems to me as some kind of defeat and that makes me sad. It's sad for me to look how great companies grew old I think Microsoft is now afraid that people (developers that were hired by enterprises) are willing to move to *nix so much so that they will force enterprises to gave up on MS stack. This way they could lose SQL Server customer and Windows customer at the same time - having SQL Server version for Linux…

It is not sad, it is Microsoft playing the right moves to stay relevant, instead of joining Sun, DEC, Wang and many others that were once upon something great.

Look at SGI and Cray, they also had to re-invent themselves around their own distributions of GNU/Linux and tailored made hardware, instead of keep selling their own UNIX variants.

If I have to develop on UNIX-like OSes, but can still enjoy all the nice Microsoft tooling I have grew to love, then great.

Love or hate it, FOSS around UNIX has commoditized the OSes.

Who knows if now we will ever move away from a UNIX monoculture on the enterprise, specially with the increasing Linux / OS X love from Microsoft side.

Re: How Microsoft brought SQL Server to Linux

#35
post #25
post #2

SQL Server source code originated on UNIX, ported to OS/2 then Windows. See the Sybase history https://en.wikipedia.org/wiki/Sybase

Sybase had a version running on Linux back in 2003. Used it for a big analytics project. It blew away SQL Server in term of reliabilty. No need for regular restarts.

SQL Server requires regular restarts?

I find this hard to believe.

Re: How Microsoft brought SQL Server to Linux

#36

This seems to me as some kind of defeat and that makes me sad. It's sad for me to look how great companies grew old I think Microsoft is now afraid that people (developers that were hired by enterprises) are willing to move to *nix so much so that they will force enterprises to gave up on MS stack. This way they could lose SQL Server customer and Windows customer at the same time - having SQL Server version for Linux…

> This seems to me as some kind of defeat and that makes me sad. It's sad for me to look how great companies grew old

Your sadness is misplaced.

Presumably you like resilience, yes? How does one achieve resiliency? At least in part via redundancy. A homogeneous environment, which an environment which relies on one vendor is, is non-redundant. All you've got then is a single point of lock-in, that can never be a good idea. You can be held hostage to the whims of the vendor. As soon as Linux became a viable choice to Windows and old Unix people left in their droves, and for this very reason.

To my mind, Microsoft is now acting like a more mature rational hungry company. I thought I'd never see the day. And frankly, if they hadn't started changing they'd be on the road to complete irrelevance.

> This way they could lose SQL Server customer and Windows customer at the same time

False. See https://news.ycombinator.com/item?id=14845783 Staying with SQL Server because Linux version was provided.

> I believe this wouldn't have happened 10 years ago, and moreover, it would have sounded just unbelievable.

Agreed. But that was not a good thing, that was very bad. For Microsoft, and their customers. Now that may have been something to lament.

Re: How Microsoft brought SQL Server to Linux

#37

I really don't see the point of having another data server running on Linux, as it is developers are spoilt for choice. I am not a fan of anything Microsoft and don't like to see it raise its head on open source products like RaspberryPi and now its attack on open source software. I want to get away from this greedy monolithic destroyer of innovation not embrace it into the open source fold

You also don't plan to touch Haskell, OCaml, async/await patterns, RX, given that they all have influence from Microsoft Research?

Re: How Microsoft brought SQL Server to Linux

#38

I really don't see the point of having another data server running on Linux, as it is developers are spoilt for choice. I am not a fan of anything Microsoft and don't like to see it raise its head on open source products like RaspberryPi and now its attack on open source software. I want to get away from this greedy monolithic destroyer of innovation not embrace it into the open source fold

I assume you're anti-AJAX then? (XMLHttpRequest having originated in IE)

I wouldn't call Microsoft an innovator in the browser either, you miss the point entirely and you should read up on the destruction of Netscape https://en.wikipedia.org/wiki/Netscape

Re: How Microsoft brought SQL Server to Linux

#39
post #4

Earlier quoted context omitted.

A rewrite, or a "rewrite"? I've seen plenty of press articles about something MS "rewrote" from the ground up, including windows itself, and they are never true. Unless they actually started from a blank source repository then it was not a rewrite.

i was there, from 1995 on. It was a real rewrite. sybase's optimizer was the biggest piece of shit ever. losing predicates, functions that called each other multiple times to rewrite the tree. We didn't have docs on the page formats, we have to reverse engineer it. The only piece not completely rewritten in the first release in 7.0 shipping in 1998 was the tree/algebraizer that was the input to the query processor. i…

[deleted]

Re: How Microsoft brought SQL Server to Linux

#40
post #25
post #2

SQL Server source code originated on UNIX, ported to OS/2 then Windows. See the Sybase history https://en.wikipedia.org/wiki/Sybase

Sybase had a version running on Linux back in 2003. Used it for a big analytics project. It blew away SQL Server in term of reliabilty. No need for regular restarts.

If you need regular restarts of SQL Server then there's something really quite wrong with your setup.
Post reply on HN