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

91–100 of 207 posts

Re: How Microsoft brought SQL Server to Linux

#91

Post by pjmlp »

mgkimsal wrote: post #84
NotSammyHagar wrote: post #19

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!

Most of the new stuff was on ADO and ODBC drivers, if I recall correctly.

I only made use of TDS C library, because there were some DML features not yet exposed via ADO and ODBC.

Re: How Microsoft brought SQL Server to Linux

#92

Post by sz4kerto »

thwd wrote: post #80
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.

Argumentum ad populum; people just don't know better. Also, I doubt it's really hundreds of millions (of people, as opposed to installs).

What should they 'know'? If they can use it for their purposes then it is, per definition, usable. It's like saying that 'most cars are unusable for getting around'.

Re: How Microsoft brought SQL Server to Linux

#93

Post by jmkni »

taspeotis wrote: post #89
smartbit wrote: post #61

I would never recommend SQL Server on Linux for Enterprise production. - licensing costs are probably the same. If the cost of an additional Windows Server license is an argument, something else is going on. - recently having dealt with MS Enterprise support on Linux, it was an horrendous experience I can nobody recommend - an Enterprise with need for SQL Server without Windows Server support engineers? - did we see…

I think it's partly a hat-tip to ISVs using .NET. Entity Framework (Core and Desktop) works best with SQL Server, with whole .NET Core is cross-platform thing they let ISVs sell to Linux shops too. The alternative would be to mix EF with PostgreSQL or (horror of horrors) MySQL which is a pain-in-the-ass for testing/QA. ORMs are leaky abstractions! If you're ponying up for a SQL Server license you can afford to pony u…

At our place, we use ServiceStack with OrmLite, which runs well on .net core and plays nicely with MySQL.

You can switch between SQL Server and MySQL by changing just one line of code.

Re: How Microsoft brought SQL Server to Linux

#94

Post by lottin »

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.

It seems to me that Windows users have a different idea of what constitutes a problem, because I always hear that Windows "just works" and yet whenever I have to use Windows I run into all sorts of issues. This isn't an isolated incident, it happens to me all the time.

Re: How Microsoft brought SQL Server to Linux

#95

Post by vidarh »

tommica wrote: post #67
Alexis66 wrote: post #65

Earlier quoted context omitted.

I make up to $90 an hour working from my home. My story is that I quit working at Walmart to work online and ­with ­a ­­little ­effort ­I ­easily ­bring ­in ­around ­$­40h ­to ­$­86h… ­Someone ­was ­good ­to ­me ­by ­sharing ­this ­link ­with me, so now i am hoping i could help someone else out there by sharing this link­... Try it, you wOn't regret it­!... http://www.smartfinancemedia.com/?682

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.

Re: How Microsoft brought SQL Server to Linux

#97

Post by thriftwy »

tiernano wrote: post #75
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…

just curious: you say "new, factory fresh install"... is this factory fresh, as in "OEM" install, or your own install? if its OEM, could it be whatever crap was installed? third party antivirus, etc? i have Win10 installed on a Surface Book, and, other them me installing stuff i shouldent, the machine works well... i did have to uninstall corporate AV (the standard MS one works just as well... and its cheaper than th…

It's OEM. There was some crapware, I have removed most of it, but to no avail.

Re: How Microsoft brought SQL Server to Linux

#98

Post by martinald »

jmkni wrote: post #93
taspeotis wrote: post #89

Earlier quoted context omitted.

I think it's partly a hat-tip to ISVs using .NET. Entity Framework (Core and Desktop) works best with SQL Server, with whole .NET Core is cross-platform thing they let ISVs sell to Linux shops too. The alternative would be to mix EF with PostgreSQL or (horror of horrors) MySQL which is a pain-in-the-ass for testing/QA. ORMs are leaky abstractions! If you're ponying up for a SQL Server license you can afford to pony u…

At our place, we use ServiceStack with OrmLite, which runs well on .net core and plays nicely with MySQL. You can switch between SQL Server and MySQL by changing just one line of code.

Yes, I also love OrmLite. It's so good and I miss it when doing dev in other languages, and as you say works perfectly across different SQL backends (unlike EF which tends to blow up horribly at the worst possible time with some obscure bug).

Re: How Microsoft brought SQL Server to Linux

#99

Post by vidarh »

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.

I bought my son a new laptop earlier this year. It is something like ten times faster than his old Linux laptop (my old hand-me-downs), yet it boots slow and is sluggish with Windows where his old Linux setup was fast. I haven't had it freeze, but I've spent far more time solving problems with his new laptop in the last few months than in the last few years of having him use Linux. If it wasn't for some of the games he likes that aren't available for Linux, I'd have insisted he stick to it.

Maybe they're not common problems, but it's certainly not just him that find it gives a poor experience.

Re: How Microsoft brought SQL Server to Linux

#100

Post by thriftwy »

sz4kerto wrote: post #92
thwd wrote: post #80

Earlier quoted context omitted.

Argumentum ad populum; people just don't know better. Also, I doubt it's really hundreds of millions (of people, as opposed to installs).

What should they 'know'? If they can use it for their purposes then it is, per definition, usable. It's like saying that 'most cars are unusable for getting around'.

As somebody born in the USSR I can easily imagine how cars will be barely usable for getting around, and people who bother with cars will be called 'car enthusiasts' instead of 'people'.

We're there with Windows 10. We were better off with Windows XP and arguably we're much better with Android.

Post reply on HN