A basic Vagrantfile that will get this going in Ubuntu
Microsoft announces the next version SQL Server for Windows and Linux
71–80 of 92 posts
Re: Microsoft announces the next version SQL Server for Windows and Linux
#72Microsoft should have his own Linux version, supported by the company. It will be inevitable.
The only point of offering it would be to support running desktop applications on it, like Word and Excel, no? And that's such a stretch that all the versions of Wine still haven't solved the problem, even after 20 years.
At this point, if Apple really wanted to scrape another percentage of desktop users away from Microsoft, THEY could release an unsupported, white-box version of the BSD-based macOS for generic PC hardware, which would run all normal macOS binaries, like Word and Excel. It would go a long way to shoring up the gap in their lagging "pro" line...
Re: Microsoft announces the next version SQL Server for Windows and Linux
#73As someone who has been working with them on pushing this live for the last 6 months I can tell you, we're all very excited to finally push this public preview
The linux tools seem to rely on a custom version of unixODBC. There is a binary rpm on the microsoft repo, but no source rpm. This seems to be contrary to the unixODBC license.
Re: Microsoft announces the next version SQL Server for Windows and Linux
#74Apart from reducing OS bingo (no need to deploy Windows to run SQL Server alongside whatever non-Windows OS you use to run your apps on), what is the selling point?
I assume it runs on x86 processors. If I do everything wrong and end up needing a ridiculously powerful machine I can check IBM's POWER-based boxes or Oracle's SPARC machines that run MySQL or PostgreSQL (or Mongo or anything else) and scale vertically well beyond the largest Xeon boxes. But those won't run SQL Server. Being that the case, why not Windows?
Re: Microsoft announces the next version SQL Server for Windows and Linux
#75This is great news and I am looking forward to be able to use MSSQL from within linux and macOS. Hopefully the client support is going to be cross platform too. The one thing in the article that puzzled me is: Thanks to its support for Docker containers, even macOS users will be able to run it. Indeed, Microsoft is betting on containers as one of the main distribution mechanisms for the preview Wasn't there a golden…
> Wasn't there a golden rule to not store persistent data in a container? You shouldn't store persistent data in the container. However, you can mount external storage and read/write to it from inside the container. The most simple example of this is mapping a path from the host. EDIT: In fact, the MS documentation gives an example of exactly this. https://docs.microsoft.com/en-us/sql/linux/sql-server-linux-... > sud…
interesting, thanks!
Re: Microsoft announces the next version SQL Server for Windows and Linux
#76Earlier quoted context omitted.
NT is decent. It's a lot of the stuff that runs atop of it which is garbage and WINE is nowhere near stable enough to be a viable replacement.
Like I said, with Microsoft's help Wine could be awesome. NT might be decent but it's not great. Why waste resources on it when they could be put to more lucrative use?
Any evidence here?
NT does a lot of things right.
I also know that I do not look forward to a world with only one dominant desktop/server OS kernel. We need competition here and Microsoft adopting Linux would ruin that.
Re: Microsoft announces the next version SQL Server for Windows and Linux
#77I've not looked at MS-SQL in a long time. My business ships software using PostgreSQL. Does anyone have, in their opinion, compelling reasons why one should consider MS-SQL on Linux for either a new project or potential migrating too? Consider too, PostgreSQL runs under Windows as a service too. What does MS-SQL have that PostgreSQL does not?
If they ported query parallelism across CPU cores as base MSSQL on Windows has, that would be a significant differentiator for those in the DWH / analytics space. Its also likely this is a attempt to keep customers on the MSSQL platform who otherwise don't have a need for a commercial OS, and may be willing to keep paying for MSSQL while cutting their OS expenses.
Postgres added query parallelism in 9.6!
Re: Microsoft announces the next version SQL Server for Windows and Linux
#78Earlier quoted context omitted.
NT is decent. It's a lot of the stuff that runs atop of it which is garbage and WINE is nowhere near stable enough to be a viable replacement.
Like I said, with Microsoft's help Wine could be awesome. NT might be decent but it's not great. Why waste resources on it when they could be put to more lucrative use?
Because NT, as in modern NT, is pretty damn sophisticated. Switching to Linux really wouldn't be a step up for Microsoft.
As I said before, it's the crap that's been bolted on that really makes Windows feel like a dinosaur. It's the decades - literally decades - of backwards comparability, the lack of a proper package management system and the free reign that developers gets that makes Windows a mess. It's the multiple shells that try to coexist or the feature bloat of pass releases or even Microsofts past tendency to reinvent the desktop every few years rather than introduce incremental improvements. This is all issues independent of the kernel, syscalls etc - i.e. All issues Microsoft would have to address regardless of which core they chose to run. So switching to Linux wouldn't help them. If anything it would just make things worse because they would forgo the stable graphics ABIs in NT for the uncertainty that is Linuxes display server wars. They'd forgo their stable Win32 APIs and other libraries for WINE. They'd have to reinvent DirectX - who's support in WINE is several generations behind - and have to battle with the appalling state of Linuxes graphics card drivers. And that's just scratching the surface of the problems they'd face.
I do love Linux and find Windows to be a hateful platform, but pragmatically Windows switching away from NT would be the dumbest thing Microsoft could do. NT simply isn't an issue.
Re: Microsoft announces the next version SQL Server for Windows and Linux
#79Apart from reducing OS bingo (no need to deploy Windows to run SQL Server alongside whatever non-Windows OS you use to run your apps on), what is the selling point? I assume it runs on x86 processors. If I do everything wrong and end up needing a ridiculously powerful machine I can check IBM's POWER-based boxes or Oracle's SPARC machines that run MySQL or PostgreSQL (or Mongo or anything else) and scale vertically we…
Windows licenses cost. Also if you are running your other stuff completely on Linux, having to setup Windows boxes just for the SQL Server can be bit inconvenient. I see this as a companion to the multiplatform .NET. Now you can run a Microsoft shop without running Windows.
Re: Microsoft announces the next version SQL Server for Windows and Linux
#80Microsoft should have his own Linux version, supported by the company. It will be inevitable.
The only point of offering it would be to support running desktop applications on it, like Word and Excel, no? And that's such a stretch that all the versions of Wine still haven't solved the problem, even after 20 years. At this point, if Apple really wanted to scrape another percentage of desktop users away from Microsoft, THEY could release an unsupported, white-box version of the BSD-based macOS for generic PC ha…
> all the versions of Wine still haven't solved the problem, even after 20 years.
Wine isn't Microsoft, and doesn't have access to Windows internal code. If Microsoft decided to write a Windows compatibility layer for non-Windows OSes, it wouldn't have to reverse-engineer. That is an immense difference in terms of amount of effort.