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

111–120 of 207 posts

Re: How Microsoft brought SQL Server to Linux

#111

Post by 43224gg252 »

thriftwy wrote: post #71
chx wrote: post #66

Microsoft is playing a fantastic Linux game with putting Linux userspace on the Windows desktop where drivers and UI are far better than the Linux drivers and UI and putting SQL Server on Linux server where the Linux kernel is much stronger. They know their strengths and weaknesses and not afraid to play to them. Here's my writeup on setting up Windows 10 as a long, long time Linux user https://github.com/chx/chx.git…

Too bad that Windows 10 barely usable on itself. Every application looks different (yes they used to blame Linux/X11 on that one). It has two control panels (or three maybe), two web browsers shipped with it. Takes more than a minute to boot on a new and pretty formidable laptop. This is the fresh factory install. Can freeze the desktop while apparently doing something under the hood (installing updates? scanning mal…

Agreed. No "hacker" would ever use or recommend Windows. It's awful for development, and even microsoft agrees, which is why they created a Linux sub-system.

Why would a so called "hacker" choose to use an OS that's slow, has horrible update policies, horrible privacy standards, injects ads into the main programs and start menu, requires anti-virus, etc?

Also, the idea that Windows has good drivers and Linux doesn't is asinine. My current dell came pre-loaded with windows 10 and failed to wake from sleep without me opening and closing the lid, then when it woke up, wifi would not come on and the only thing that fixed it was a reboot. Then when I used the touch screen things were going fine until I tried to select text and got an instant BSOD. Also I learned not to accidentally touch the screen and then try to type immediately afterward, or it would lock up the whole OS.

Linux just worked. Literally. Even the touch screen. I get 15 minutes less battery life but it's worth it.

Re: How Microsoft brought SQL Server to Linux

#112

Post by marsrover »

d4nt wrote: post #110
CrLf wrote: post #102

I'm still unsure of the usefulness of SQL Server on Linux. I don't see the point of running SQL Server on Linux (I'd rather choose PostgreSQL or something), nor do I see the point of choosing Linux if I'd already settled for SQL Server. I don't think this (in the end) is anything more than a marketing trick, there to give the illusion of choice. This is not uncommon in ISVs, btw. There are many commercial offerings t…

I think for .net developers, this makes more sense. You have an existing .net app, built to talk to MS SQL Server, if the latest version of .net can run on Linux, but your DB can't then you're faced with either managing two OS flavours, or just ignoring the Linux compatibility. Ignoring Linux compatibility would have knock on effects because Linux is now the platform for so many other tool, e.g. Docker. Regardless of…

This is the situation I'm in with a toy app I built. It is running .NET Core, talking to SQLServer, and running on Windows Server 2016. I want to migrate the entire application to my Debian box and without SQLServer on Linux, this would be much more painful.

Re: How Microsoft brought SQL Server to Linux

#113

Post by 43224gg252 »

pjmlp wrote: post #90
ekianjo wrote: post #73

Earlier quoted context omitted.

Thats if you dont mind the hugely privacy invasive win10 environment to begin with.

It is way less than what Google does on my Android devices. Now Google Maps even asks me to upload pictures of places where I happen to be.

So because Google is worse that makes it okay for MS?

I disagree. If you're a programmer who cares about privacy use Linux.

Re: How Microsoft brought SQL Server to Linux

#114

Post by grovegames »

CrLf wrote: post #102

I'm still unsure of the usefulness of SQL Server on Linux. I don't see the point of running SQL Server on Linux (I'd rather choose PostgreSQL or something), nor do I see the point of choosing Linux if I'd already settled for SQL Server. I don't think this (in the end) is anything more than a marketing trick, there to give the illusion of choice. This is not uncommon in ISVs, btw. There are many commercial offerings t…

I have 20 years of experience with SQL Server, and zero experience with PostgreSQL. You aren't the target market, but I certainly am.

Re: How Microsoft brought SQL Server to Linux

#115

Post by pjmlp »

43224gg252 wrote: post #113
pjmlp wrote: post #90

Earlier quoted context omitted.

It is way less than what Google does on my Android devices. Now Google Maps even asks me to upload pictures of places where I happen to be.

So because Google is worse that makes it okay for MS? I disagree. If you're a programmer who cares about privacy use Linux.

I already do on my phone, doesn't help.

https://source.android.com/source/

Re: How Microsoft brought SQL Server to Linux

#116

Post by dijit »

cjsuk wrote: post #88
noinsight wrote: post #63

Earlier quoted context omitted.

What issues have you run into? I haven't encountered any problems. Admittedly I mostly use it for logging into servers with AD accounts (it will autocreate homedirs too!) and access controls via AD groups. You can permit SSH/sudo access through AD group memberships. SSH works with Kerberos SSO.

Mainly periodic random unexplainable KDC_ERR_C_PRINCIPAL_UNKNOWN which appears to be the Kerberos equivalent of "fuck you!"

Check your ntp; this happens when kerberos loses trust with the principle.

Happens on Windows too but they mitigate it by _forcing_ you to use NTP against the AD servers.

Re: How Microsoft brought SQL Server to Linux

#117

Post by dspillett »

CrLf wrote: post #102

I'm still unsure of the usefulness of SQL Server on Linux. I don't see the point of running SQL Server on Linux (I'd rather choose PostgreSQL or something), nor do I see the point of choosing Linux if I'd already settled for SQL Server. I don't think this (in the end) is anything more than a marketing trick, there to give the illusion of choice. This is not uncommon in ISVs, btw. There are many commercial offerings t…

I think a large part of it is supporting cross-platform developers who might be mainly Linux based internally, so someone writing apps in node primarily on Linux (for example) can more easily test against MS SQL Server (as well as postgres/mariadb/...) and add it to the "supported" list without that being quite as much hassle as it might otherwise be. SQL Server working on Linux potentially increases its catchment area for devs and projects noticeably. I see that as a much more likely use case than SQL Server on Linux in production.

Now that practically all the features are available in the standard edition (depending on your support and scale-up/scale-out requirements) it could end up used in production for licensing cost reasons particularly if the availability/DR/scaling features work well (where previously if you needed Enterprise edition the cost of windows was a drop in the ocean - Standard isn't exactly pocket money cheap but still...).

Another PoV could just be that these days interpolarity matters much more to MS than it used to, as their key product focus is moving further away from the OS & individual services and more onto the platform with Azure - they don't care what DB engine you run on which OS, as long as you do so on their platform - hence moves to support postgres & mysql in the database-as-a-service-upon-platform-as-a-service manner that they already offer for SQL Server. Of course they'd prefer that you used Windows and SQL Server but not wanting to (or depending on the project, not being able to) use one needn't get in the way of using the other, not should not using one (or either) get I the way of using Azure.

Re: How Microsoft brought SQL Server to Linux

#118

Post by heartbreak »

vidarh wrote: post #95
tommica wrote: post #67

Earlier quoted context omitted.

Hmm, I think HN needs a way to report either spam messages or users - this guy was created 6 mins ago, has two comments, both spam

As others have pointed out, there is, but I have "showdead" on, and there's been a huge uptick in deliberate spam lately. They do get blocked very quickly, so hopefully they get tired of it, but it's a big change from how showdead would mostly show cranks, bad jokes, and the (very occasional) overzealous moderation.

I figured HN would have solved this wave of spam by now.

Re: How Microsoft brought SQL Server to Linux

#119

Post by ethbro »

rjbwork wrote: post #82
sz4kerto wrote: post #77

Earlier quoted context omitted.

> Too bad that Windows 10 barely usable on itself. I am always surprised to hear these statements. Hundreds of millions of people use W10, so it must be usable to some extent. I think it's also quite rare that the system stops for 5 minutes -- actually I've never seen that happening.

>I am always surprised to hear these statements. No kidding. I use it every day nearly all day and I can count the number of times I've had the OS itself get in my way on 1 hand.

> I can count the number of times I've had the OS itself get in my way on 1 hand

I could overflow both hands just counting two Explorer things: (1) trying to figure out where MS put a setting/option if it's not on Ribbon & (2) trying to use any advanced search operators.

Re: How Microsoft brought SQL Server to Linux

#120

Post by yjftsjthsd-h »

aykutcan wrote: post #83
thriftwy wrote: post #71

Earlier quoted context omitted.

Too bad that Windows 10 barely usable on itself. Every application looks different (yes they used to blame Linux/X11 on that one). It has two control panels (or three maybe), two web browsers shipped with it. Takes more than a minute to boot on a new and pretty formidable laptop. This is the fresh factory install. Can freeze the desktop while apparently doing something under the hood (installing updates? scanning mal…

Windows 10 is usable in every aspect. Boot speed is pretty good and doesnt freeze like that. Check your hardware if that is a fresh factory install. You are doing something wrong. They are not common problems. They are yours.

> Check your hardware if that is a fresh factory install. You are doing something wrong.

And here I thought it was Linux users that were supposed to say "you're holding it wrong" and "just make sure you get supported hardware"

Post reply on HN