Live data from Hacker News

How Microsoft brought SQL Server to Linux

techcrunch.com

11–20 of 207 posts

Re: How Microsoft brought SQL Server to Linux

#12
post #4
post #3

Earlier quoted context omitted.

SQL Server 7.0 was a complete rewrite (you will notice that the Sybase copyright notices disappeared around then).

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 suppose there may have been some old code in there to maintain backwards compatibility with e.g. the T-SQL parser, but it was C before and C++ after the "rewrite"...

Re: How Microsoft brought SQL Server to Linux

#13

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?

No idea about the Services, but AD is covered in https://docs.microsoft.com/en-us/sql/linux/sql-server-linux-...

Re: How Microsoft brought SQL Server to Linux

#14

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?

I thought because Kerberos was OS agnostic you could already have Linux interacting with Windows AD?

Re: How Microsoft brought SQL Server to Linux

#15

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?

Whst is and is not included: https://docs.microsoft.com/en-us/sql/linux/sql-server-linux-...

Re: How Microsoft brought SQL Server to Linux

#16
post #5
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…

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.

Re: How Microsoft brought SQL Server to Linux

#17
post #4
post #3

Earlier quoted context omitted.

SQL Server 7.0 was a complete rewrite (you will notice that the Sybase copyright notices disappeared around then).

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.

Re: How Microsoft brought SQL Server to Linux

#18
post #14

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?

I thought because Kerberos was OS agnostic you could already have Linux interacting with Windows AD?

Microsoft has two extensions to Kerberos, impersonation and delegation. To use WA in a multi-tier set up (app, dB) you need those. I'm not sure if those extensions are available on Linux.

Re: How Microsoft brought SQL Server to Linux

#19
post #4
post #3

Earlier quoted context omitted.

SQL Server 7.0 was a complete rewrite (you will notice that the Sybase copyright notices disappeared around then).

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. it was so messy and horrible even our team of champions couldn't do it in the first release.

Re: How Microsoft brought SQL Server to Linux

#20
post #5
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…

it was far from a simple refactoring. we wrote almost every piece of it new and from scratch.
Post reply on HN