Hacker News Board Hacker News, browsed like a classic message board
Live data from Hacker News

How Microsoft brought SQL Server to Linux

techcrunch.com

Post reply on HN
Print view View original

21–30 of 207 posts

Re: How Microsoft brought SQL Server to Linux

#21

Post by [deleted] »

frik wrote: post #5
flukus wrote: 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.

Don't down vote him. More often than not those are just normal refactoring with PR attempts to get rid of old license info. See IE7, it got rid of Mosaic license info yet even IE11 and early Edge contains web render code and mouse behaviors that can be traced back to Mosaic web browser, where it forked off. The same is with game engines, Valve's Source engine 2 started as a fork of ID's Quake 1 engine and it's still…

[deleted]

Re: How Microsoft brought SQL Server to Linux

#22

Post by flukus »

pjmlp wrote: post #17
flukus wrote: 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.

A rewrite is a rewrite, even if it isn't 100% new code, check a dictionary.

I checked a few (https://en.wiktionary.org/wiki/rewrite) they all seem to indicate that it's writing something again. Some included revise as a synonym, but the parent said "complete rewrite" which would exclude that. Otherwise where is the cut off line? Can I rewrite 1% and call something a rewrite?

I never knew the definition of rewrite would be so controversial.

Re: How Microsoft brought SQL Server to Linux

#23

Post by noinsight »

polskibus wrote: post #9

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.

Re: How Microsoft brought SQL Server to Linux

#24

Post by bdcravens »

peter_retief wrote: post #7

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)

Re: How Microsoft brought SQL Server to Linux

#25

Post by spikels »

esterly wrote: 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.

Re: How Microsoft brought SQL Server to Linux

#26

Post by synotna »

flukus wrote: post #22
pjmlp wrote: post #17

Earlier quoted context omitted.

A rewrite is a rewrite, even if it isn't 100% new code, check a dictionary.

I checked a few ( https://en.wiktionary.org/wiki/rewrite ) they all seem to indicate that it's writing something again. Some included revise as a synonym, but the parent said "complete rewrite" which would exclude that. Otherwise where is the cut off line? Can I rewrite 1% and call something a rewrite? I never knew the definition of rewrite would be so controversial.

Write something down, cross it out, (re)write the same thing again

What you wrote is the same but will be a little different

Re: How Microsoft brought SQL Server to Linux

#27

Post by djsumdog »

pjmlp wrote: post #16
frik wrote: post #5

Earlier quoted context omitted.

Don't down vote him. More often than not those are just normal refactoring with PR attempts to get rid of old license info. See IE7, it got rid of Mosaic license info yet even IE11 and early Edge contains web render code and mouse behaviors that can be traced back to Mosaic web browser, where it forked off. The same is with game engines, Valve's Source engine 2 started as a fork of ID's Quake 1 engine and it's still…

Unless I stop understanding English, all those examples are still a rewrite, writing something anew, doesn't mean throwing 100% of the old stuff away.

And these can also be explained by unit tests .. you keep the old unit tests and rewrite everything so those tests pass. Sometimes that means getting some of the same weird quirks or gotchas, but hopefully refactored so they are all in one place and clearly documented.

Re: How Microsoft brought SQL Server to Linux

#28

Post by eapotapov »

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 will keep SQL Server customer.

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

This reminds me not only of things that could change very fast. It reminds that even when things go well with your business there's always someone thing that could "disrupt" your market, like a new dimension. And that thing won't be invisible. It will grow nearby and you will see such company and just won't assume that it represents any danger.

Re: How Microsoft brought SQL Server to Linux

#29

Post by djsumdog »

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, but once the Docker container was released, I fully integrated it into our tests:

https://github.com/BigSense/BigSenseTester/blob/master/docke...

I can now pull up all three DBs in containers (mysql/pgsql/mssql) and three instances of BigSense and run tests over all three in a deterministic manner.

I had started working on automating a Windows Server with automatic SQL installation in Vagrant, but that was starting to look really complicated. If it wasn't for MS porting their database to Linux, we probably would have dropped it from the project.

Re: How Microsoft brought SQL Server to Linux

#30

Post by cpeterso »

rdiddly wrote: post #11

Unexplained photo of Portland's Steel Bridge. Is it a reference to OSCON?

The article says Microsoft ported SQL Server to Linux using a 2011 Microsoft Research project called "Drawbridge":

https://www.microsoft.com/en-us/research/project/drawbridge/

Post reply on HN