Slashdot Mirror
Microsoft Brings SQL Server To Linux (betanews.com)
Mark Wilson writes: The new Microsoft has place an increased importance on the cloud, and with other companies following suit, reliance on server solutions has increased. Today the company announces that it is bringing SQL Server to Linux. Both cloud and on-premises versions will be available, and the news has been welcomed by the likes of Red Hat and Canonical. Although the Linux port of SQL Server is not due to make an appearance until the middle of next year, a private preview version is being available to testers starting today. While the full launch of SQL Server for Linux is not due until the middle of 2017, SQL Server 2016 is expected to launch later this year.
April 1st isn't for another month silly.
April 1st isn't for another month.
That explosion and mushroom cloud was Steve Ballmer's head exploding.
they are not bringing sql to linux because linux already has sql and had it before microidiot bought the thing.
Just what Linux needed!
...as temperatures reportedly fall all over hell.
Loading...
It looks like Microsoft is well on their way towards embracing Linux. Of course, what worries me is what comes AFTER embracing and extending. You old-time Slashdotters know what I'm talking about, right?
Finding God in a Dog
Great Cornholio often said
ARE YOU THREATENING ME!?!? I need TP for my bunghole.
On mobile Microsoft has pretty much given up and support Android and iOS as well or better than Windows Mobile now now on the Server side we've already seen .Net moving fast to Linux and now the third biggest lock in application on Windows Server(AD and Exchange being bigger) is coming to Linux. With AD and Exchange being pushed more towards hosted services in the cloud, Windows' future doesn't look too bright there.
And not open-source.
Perfect. Maybe systemd can use it for logging, like a modern operating system.
an ill wind that blows no good
How long before we see a version of "Microsoft Linux"?
You laugh now, but I can see them glomming onto Linux, especially as more businesses and desktop move over to Linux.
And yes, of course it will have subtle incompatibilities that grow more and more pronounced over time. That's what it's all about with Microsoft.
"MS Linux- Because We Care" or maybe, MS Linux- The Most Stable OS We've Ever Produced!*
-
* and by "produced", we mean "stolen"
Just cruising through this digital world at 33 1/3 rpm...
I don't see how SqlServer can compete against Postgresql. The only thing SqlServer had going for it was integration with .Net framework.
As SQL Server started out as a Unix product (named DataServer from Sybase) this isn't really that shocking.
Plus, you know, it being 2016 (as opposed to 1995) and the business world has moved on... unlike a lot of readers by the look of it.
everything old is new again
Microsoft Brings their SQL Server To Linux even though Linux doesn't need it and nobody asked for it
no really.. It's a trap!
...when hell thawed a little
They are more than happy to let you spin up a linux instance on Azure. Having their stack work across them all seems like a reasonable thing to do.
Imagine a beowulf cluster of these!
just ask the devs for Fable for Linux
-- Tigger warning: This post may contain tiggers! --
It will probably perform a helluva lot better on Linux. Even more interesting is Microsoft's shifting stance on open source.
bahahaha!
Sadly, BIZX has not place any importance on editing their stories for basic grammar.
they're playing the EEE fiddle!
how's that Novell pact working? .NET (and WINE) and Corel Linux working?
how's that Moonlight plugin working?
how's that work with
https://en.wikipedia.org/wiki/...
Microsoft: Where rootkit scanners like this go to die.
It's no wonder projects like this die, TPTB don't want you to know of their secret rootkits. It was a good program while it lasted, but it's been dead since 11/1/06.
Thanks, Microsoft! I mean, fuck you.
If Microsoft wanted to extinguish Linux, they wouldn't even have to do a damn thing these days.
The Linux community is doing a superb job of extinguishing Linux all on its own.
Regardless of what you think about it, systemd has caused massive disruption within the Linux ecosystem.
The Debian project, which for a long time was the premiere Linux distribution, has been torn apart by its decision to use systemd.
Lots of other Linux users have had systemd cause them serious problems, including computers that would no longer boot properly.
Many of these Linux users have chosen to move to FreeBSD, OpenBSD, OS X, and even Windows in some cases.
And that's all on top of the problems that GNOME 3, NetworkManager, and PulseAudio have caused.
Then there's the failure of the Wayland project to create a modern replacement for X.
Each one of these failures has hurt Linux's viability, and there's no end in sight!
Existing users are being driven away, and there are no new users replacing them.
Make sure to give some feedback!
“He’s not deformed, he’s just drunk!”
I believe, a long time ago, Sybase was a sql database engine. And MS had an agreement to share code with Sybase https://en.wikipedia.org/wiki/.... MS SQL and Sybase were one code base, And Sybase got its roots on unix.
I've always said English was my second language. Had Romeo and Juliet been written in C, I might have understood it.
Sounds like a joke? No I'm serious.
I don't need yet another database in Linux. PostgreSQL is fine, thank you. Even MySQL/MariaDB are OK.
What I miss is a GUI interface to these databases, which would allow me to quickly build GUI applications for users. MS Access can show PostgreSQL data to users in quickly designed forms and reports. And these can have some (horrible) VBA code to make a few things faster and easier for the users. Without Access, I have to make HTML interfaces, which works fine for simple reports, but gets really clumsy and slow for complex interactive forms.
(Yes, I know about PGadmin. It's great for me, and I use it regularly. But it's not for designing custom user interfaces to databases)
Get back to me on this when .NET runs on linux, why don't they announce things when they get them working...
We'll port systemd to Windows!
Have gnu, will travel.
Here's one data point - based on from experience migrating a pretty big system from [a major proprietary database mentioned in the article] to Postgres, I think the two biggest advantages Postgres has are:
GIST and GIN indexes (and soon BRIN indexes), and
Writeable CTEs.
We migrated a very busy, pretty large (24 CPU core, 256GB RAM, 20TB disk space) system from [a major proprietary database mentioned in the article] to Postgres about a year ago. These graphs measuring CPU and disk activity provide a nice visualization of the improvement:
http://imgur.com/a/bp2ky
Note that with [a major proprietary database mentioned in the article], all 24 CPU cores in the system were over 40% utilized (and growing) 24x7 most days a year. After a pretty naive port (November to May in the graph) the CPU load fell to an average of about 10%, and the disk array's queue length fell from painful to near zero. After adding some Postgres-specific code, we got it down to an average of near 5% (shown in the most recent month in the graph).
CPU differences seem to have been mostly related to the availability of GIN indexes in Postgres, which can be much more efficient on certain types of data (like the OpenStreetMap road network).
Disk I/O improvements seems to be mostly related to Postgres's far more compact storage of XML data. Seems SQL Server stores XML data using 2-bytes-per-character for the data itself; and on top of that adds extremely large indexes. In contrast, the "toast" feature in Postgres means the XML data takes an average of less than one byte per character for the data and its "functional index" feature allowed for far more compact indexes. One of our XML-heavy databases went from over 600GB in SQL Server down to 140GB in Postgres, with more efficient indexes.
For a few months we tried to stay database-agnostic so it'd be easy to port back if we needed to -- but after a while we started adding Postgres specific changes. The benefits of those Postgres specific changes can be seen near the end of those graphs. An enormous improvement occurred when we changed the inserts and updates to use the Writable CTE features following recommendations someone outlined here
.
In the end, Postgres looks to me like it's saving us like 5X in hardware costs as we continue to grow.
Edit: I'm told this proprietary database vendor dislikes users publishing benchmark results comparing their software to F/OSS databases. I'd argue that this is more of an anecdote than a benchmark; but just in case I edited the comment to remove the vendor and product name from the parts that talk about performance.
Disclaimer: As mentioned in a comment below, we tried to tune each the systems to the best of our team's abilities, but aren't really experts in tuning either database system. No doubt each system's results could be improved by people who were deeply available with each databases internals (which I argue is much easier to find for Postgres, since its mailing lists have thousands of people familiar with the internal code).
Whenever I read "The new Microsoft", I instantly expect an apologist piece to follow. And, with this post, I was not disappointed.
Sorry Microsoft. You're the same skanky trollop, just wearing a different wig.
sig: sauer
I think M$FT realized that they couldn't scale their cloud architecture on windows so they started porting Azure services to run on Linux. May as well release their linux versions..
they would not be putting out olive branches like that without hiding a club behind their back to be used for some reason or another. 30+ years of that makes one sceptical and looking for the hammer. Besides, I remember how they finally agreed to a JDBC driver for their Sequel Server and it too was stated as having a one year and more release date.
So, don't hold your breath or think there is a new Microsoft. They are going to be clubbing someone real soon now.
So at one point, MS SQL was a fork of the Sybase code which ran on multiple architectures and OSes....including Linux. I wonder how much work they had to do restore all of the ifdefs that were probably scattered throughout the codebase?
I ran Sybase for quite some time on Linux and it was pretty killer. It will be interesting to see how it performs.
Not only is SQL Server coming to Linux, but it's already being integrated into systemd!
Yes... You too can have a worthless nag sitting right there in your Unity sidebar. It also comes with file indexing and telemetry so they can make sure they can find every file and keypress on your Linux PC. This ad sponsered by NSA, MPAA, & RIAA.
Comment removed based on user account deletion
Microsoft moving releasing a desktop *nix is about as likely as Apple doing so. And running it on Intel chips. ;) It could certainly happen.
* Fyi for anyone who didn't happen to know, OS X is certified UNIX (tm).
... a little bit. I guess MS has reversed its stance that Linux is "a cancer" and generally bad.
Most ACs are not even worth the keystrokes to insult them. Be generically insulted by this and ignored otherwise.
UNIX 'certification' is a figment of the UNIX trademark wars and essentially a corporate racket. A strict UNIX certification would be worthless as only the FOSS variants would qualify and where is the money in that?
You might say Linux is not UNIX and be at least semantically correct, but to imply BSD is not UNIX is a farce. And yet BSD isn't certified and neither are it's various children. This means the certification is completely useless to anybody evaluating UNIX and UNIX-like systems.
Awesome story. I'd wondered about Postgres and heavy-duty jobs; turns out it's as impressive as touted.
I worked 25 years in an Oracle shop, from Oracle 6.1 to Oracle 12c; assumed everything else, certainly FLOSS stuff, had to be toy products by comparison.
Then I tried PostGIS because I was working with the new free GIS program, QGIS, and PostGIS isn't just a free RDBMS, it's a geodatabase. Soon, I found it was handling gigabytes of map data in an eyeblink - on a laptop. The more reading I did on it, the more of those "enterprise level" features for handling massive data sizes and user numbers I saw. I've wondered why I don't hear more about it.
We had some interaction with EnterpriseDB, who not only sell service, but have their own add-on software that makes shifting to Postgres from Oracle pretty easy for most. I just don't see how we aren't going to hear about more conversions soon.
And, yeah, like the world has been waiting for that.
I'm genuinely surprised that Software is still around. With Firebird, Postgres, MySQL, a freely available DB2 & Oracle running on Linux since something like 15 years ago MS is beyond late - just as it was with fossing .Net. ...
Seriously, the last time I ever heard of MS SQL Server was back in 2002 or something - and that was in the context of discussing with which DB we were going to replace it.
We suffer more in our imagination than in reality. - Seneca
disastrous Windows "Anal Plug" 10 release... It seems related to me
In case anyone's wondering how parent managed to "edit" his Slashdot post: this is a verbatim copy from a Reddit post.
Ah, arrogance and stupidity, all in the same package. How efficient of you. -- Londo Mollari
After they push users to Linux Desktops, now they want to facilitate users to migrate from SQL Server by porting it to linux (and making the Windows Server S.O. license not needed anymore :P)
So it's an SQL Injection attack, on Linux?
Yes - I should have mentioned that.
Why do so many Linux users expect all their software to be free (as in beer)? If you build software for Linux, everyone seems to want you to give it to them for nothing. Then they wonder why there are not enough drivers, applications, and other stuff being written for Linux. They complain that bugs are not being fixed and that documentation is lame. Not enough talented programmers seem to want to spend their weekends doing boring stuff for nothing...imagine that! The old adage "you get what you pay for" comes to mind.
> A strict UNIX certification would be worthless as only the FOSS variants would qualify and where is the money in that?
The opposite is true. POSIX aka Single Unix is pretty strict, which is why most Linux distributions don't quite meet the criteria. Most of the systems which are registered as complying with the Single UNIX Specification (aka POSIX) are NOT FOSS.
> And yet BSD isn't certified and neither are it's various children.
False. Mac OS X v10.5 Leopard is mostly BSD, and registered. Sun/Oracle Solaris is another of BSD's "various children" which is registered.
Did you intend to say that FOSS code is NOT certified?
Inspur K-UX is a Red Hat based Linux distribution which is configured to be certified UNIX.
And the World keeps going. And that's it.
Oh, by the way. Welcome to Linux to all the MSSQL DBAs. I would have said "refugees", but it has become a dirty word here in Europe those days...
I don't get it. Why would they do that? It's self-foot-shooting in the short run, and desperation in the long run. Its my understanding that better alternatives exist, for free.
Sadly, a Libertarian cannot force his views on another, and freedom cannot spread as does the cancer known as religion.
That's a not so sure woo hoo. Why? Because it's a database for Linux that's not owned by Oracle.
Maybe Microsoft is putting it out there for acquisition? Has to be another motive for it, right?
That all might well be true and I do share your sentiments about the technical superior "product", but hardware is cheap and trained and actually capable personnel is expensive.
I'd go with higher TCO and moderate expenses for talent than near zero TCO and exceedingly hard to find and hellish expensive talent.
AC
Maybe we can then get some performance out of this pig. MSSQL Server on on Windows Server is the biggest performance bottleneck in enterprise apps, plus MSSQL is ridiculously difficult to maintain.