Live data from Hacker News

How Microsoft brought SQL Server to Linux

techcrunch.com

201–207 of 207 posts

Re: How Microsoft brought SQL Server to Linux

#201
post #135

Earlier quoted context omitted.

Good point. Let me switch to Ubuntu, which definitely doesn't have any privacy invasions in its desktop environment....

They don't, since a long time ago. And for the short time they did, they documented exactly what was sent, to who, and how to turn it off (and you were able to verify that by looking at the source, recompiling yourself, etc.) Please explain how to do any of those things on Windows - either the new 10, or the retrofitted-telemetry 7 which one has to retrofit with telemetry if they want security updates.

> and you were able to verify that by looking at the source

How much of Ubuntu has undergone a security audit by people who are looking for actively maliciously obfuscated code?

In a codebase the size of Ubuntu (and all its packages), "you can look at the source" is a mindgame, nothing more.

Also, you can look at Windows' source code. In addition to the numerous programs Microsoft has for licensing the code to universities, researchers (including security auditors!), well-known community members, etc. the source code has been leaked multiple times.

Re: How Microsoft brought SQL Server to Linux

#202
post #161

Earlier quoted context omitted.

> 's pretty well known that as part of the new iterative release cycle they're slowly moving things Linux DEs were blasted for things like that, but now they're suddenly OK for a multi-billion-dollar company's flagship product? > you're running off a spinning drive I also happen to walk on the ground and climb up the stairs, being aware of alternatives. That's what I've got in a shop and it has MS Windows logo glued…

>Linux DEs were blasted for things like that, but now they're suddenly OK for a multi-billion-dollar company's flagship product? Yes actually. It's what users asked for, and I rather appreciate it. Linux DEs were BLASTED for breaking things. MS isn't breaking anything as they make the slow transition to the new panels. If you want to use the old control panel, everything is right there where it always was. If you wan…

> MS isn't breaking anything

Whoooa! I've now tried to find when you can change the hotkey for changing keyboard layout. It turns out, you can't find it now. New control panel has nothing and drops you into the old one immediately, which has nothing too.

It was working under Windows XP. Obviously you can't find how to configure anything in Windows these days without extensive googling.

Re: How Microsoft brought SQL Server to Linux

#203
post #201

Earlier quoted context omitted.

They don't, since a long time ago. And for the short time they did, they documented exactly what was sent, to who, and how to turn it off (and you were able to verify that by looking at the source, recompiling yourself, etc.) Please explain how to do any of those things on Windows - either the new 10, or the retrofitted-telemetry 7 which one has to retrofit with telemetry if they want security updates.

> and you were able to verify that by looking at the source How much of Ubuntu has undergone a security audit by people who are looking for actively maliciously obfuscated code? In a codebase the size of Ubuntu (and all its packages), "you can look at the source" is a mindgame, nothing more. Also, you can look at Windows' source code. In addition to the numerous programs Microsoft has for licensing the code to univer…

> How much of Ubuntu has undergone a security audit by people who are looking for actively maliciously obfuscated code?

You've just moved the goal posts from "we can look at what it's doing" to "we assume they tried to hide what it is doing" - which we know that e.g. Microsoft did bundling telemetry into Win7 security updates, but that Canonical never did. Nice.

I don't know how much has been gone through by people looking for underhanded code, but ... quite a few looking at the basic code. And if you expect underhanded code, I think you should just not trust the vendor.

> In a codebase the size of Ubuntu (and all its packages), "you can look at the source" is a mindgame, nothing more.

Actually, quite a few people diff ubuntu against debian to see the changes, and Ubuntu's original, independent code is not that huge - in fact, the community took over Unity, so there are a lot of people looking at it.

> Also, you can look at Windows' source code. In addition to the numerous programs Microsoft has for licensing the code to universities, researchers (including security auditors!), well-known community members, etc. the source code has been leaked multiple times.

Now, that's a complete joke.

Unlike ubuntu (which I have, in the very distant past 8.04 or 6.06 days rebuilt the base of, and which others regularly do), you have absolutely zero way to verify that the 400MB executable you installed does not include, in addition to the source you have, backdoors, telemetry etc.

When I was in Uni, I talked to one of the guys who get access to the source. It was view-only, can't rebuild, some critical parts missing. Maybe these days it is buildable, but I'd be surprised. And even if it is, you're not allowed to use it (except for auditing purposes), which goes back to the previous point - you have little idea what you're actually running.

> the source code has been leaked multiple times.

That's another joke. First, no professional would review _that_ because of legal ramifications.

I have a simple proof that you are completely, utterly, wrong in your assertions, and I would love for you to refute it.

If it's so easy to see what Microsoft is doing, how come there wasn't a single source for what Win10 actually sends home, for what the Win7/8.1 telemetry sends home, that was based on facts? In fact, the only semi-reliable (but not audited, or 3rd party confirmed!) source of what Win10 sends is from Microsoft, released over a year after Win10 was out. And it's frightening enough as it is.

I call bullshit on your claims. You're welcome to like Microsoft better than Ubuntu, but please stick to the facts.

Re: How Microsoft brought SQL Server to Linux

#204

Earlier quoted context omitted.

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…

It would seem a lot of the protocol was kept though, no? IIRC there wasn't much diff between the mssql 6.5 protocol and mssql 7 protocol. I had been working with the freetds project in 1999/2000 and spent way too much time learning about some of that, although... it was 17 years ago and details are fading!

I think it was backwards compat at the least but i didn't work on that area.

Re: How Microsoft brought SQL Server to Linux

#205
post #199

Earlier quoted context omitted.

> Why then do Windows 10 laptops get sold with HDDs? Excellent question. These machines should do better with Win7 but Microsoft doesn't want to sell it. Microsoft sells windows 10 and Microsoft sells laptops with Windows 10 on an SSD. I doubt (but do correct me if I'm wrong) Microsoft sells any computers with Windows 10 on a mechanical drive. Various manufacturers sell underpowered computers with Win10 on it, but th…

So in other words we need to buy substantially more expensive computers to get a usable experience with Windows vs. Linux. On top of the Windows license. You'll note that with respect to my sons laptop, Linux ran just fine on his much older, slower laptop. Says it all, really.

> So in other words we need to buy substantially more expensive computers to get a usable experience with Windows vs. Linux.

Well, "Linux" is much broader than a specific version of windows (Windows 10). But yes, for most kinds of linux setup (distro, window managers etc) I'd say the bare OS definitely needs less resources on Linux than on Windows.

I do find that apart from the storage issues, Win10 actually runs about as lean (on cpu and mem) as Win7. The problem with consumer hardware such as cheap or midrange laptops is usually that it's infested with crapware from the start, something I also blame microsoft for, not manufacturers.

The OEM agreeements microsoft do with laptop manufacturers should explicitly ban them from installing any crapware such as antivirus trial versions, poorly written hardware apps and similar. I realize the $400 price of a cheap laptop sometimes includes a big rebate due to the software bundles - but ms ought to put a stop to it. Has to be damaging to their brand.

Re: How Microsoft brought SQL Server to Linux

#206
post #180

Earlier quoted context omitted.

You don't have to remember anything in powershell as you get parameter completion and command completion by default. Powershell useability beats the standard UNIX shells (bash/zsh) in command discovery and assistance. You even use PSReadLine if you want VI keybindings at the command line.

Am I using it wrong? I realize a large majority of those aren't used frequently, but there are ~250 cmdlets, each of which attempts to have a unique-but-also-generic name. https://technet.microsoft.com/en-us/library/ff714569.aspx Let's say I didn't know ForEach-Object existed (trivial example, but generalizes), how do I find out there is a cmdlet that does what I'm looking for?

`Get-Command` lists all the cmdlets in the current sesion. You can also alternatively hit `help -category cmdlet` which lists all cmdlets with their short alias and long name. You can do `man -category cmdlet` if you wish to page through. The first thing in powershell you should do is `help help` :).

Re: How Microsoft brought SQL Server to Linux

#207
post #14

Earlier quoted context omitted.

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.

Ah, thank you for clarifying :)
Post reply on HN