I like SQL Server a lot, I wish I could use it on production over Centos, but the price of the licenses... Oh boy... I can't afford that.
Microsoft announces the next version SQL Server for Windows and Linux
81–90 of 92 posts
Re: Microsoft announces the next version SQL Server for Windows and Linux
#82As 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
Wow Will the Linux build come with SSASS capabilities as well?
It's just the relational engine for now, no SSIS, SSAS, or SSRS. If you want to see more capabilities on Linux, I'd open a Connect item or search for an existing one and share it back here so people can vote.
Re: Microsoft announces the next version SQL Server for Windows and Linux
#83This doesn't seem to be a bona fide port to Linux. The sqlservr binary seems to load some .sfp files in the lib directory of the installation, and those files seem to include a good chunk of a Windows installation. There's registry hives, batch commands, and what look like PE64 executables in there.
IIRC for performance, the SQL team essentially built their own OS layer on top and only used raw APIs or something.
Re: Microsoft announces the next version SQL Server for Windows and Linux
#84Microsoft has created an apt repository for Ubuntu. That's really nice. https://docs.microsoft.com/en-gb/sql/linux/sql-server-linux-...
sudo apt install mssql-server felt really weird. Oddly a much nicer install process than the last time I installed MSSQL server on Windows(which was admittedly a log time ago, and it could be better now).
Just tell yourself it's apt install sybase.
Re: Microsoft announces the next version SQL Server for Windows and Linux
#85Earlier quoted context omitted.
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!
Correct, but for a limited set of query plans. It does mean progress is being made however.
Re: Microsoft announces the next version SQL Server for Windows and Linux
#86This doesn't seem to be a bona fide port to Linux. The sqlservr binary seems to load some .sfp files in the lib directory of the installation, and those files seem to include a good chunk of a Windows installation. There's registry hives, batch commands, and what look like PE64 executables in there.
Who cares? If it works on Linux and works well they can put their favourite Gifs inside for all I care
Re: Microsoft announces the next version SQL Server for Windows and Linux
#87So how do I add a sql server instance in a container with an average of 300 million rows per table and a db of average size of maybe 3 tb and not have io issues? Containers do not seem to scale to enterprise besides nosql type operations of let's commit later.
Re: Microsoft announces the next version SQL Server for Windows and Linux
#88This doesn't seem to be a bona fide port to Linux. The sqlservr binary seems to load some .sfp files in the lib directory of the installation, and those files seem to include a good chunk of a Windows installation. There's registry hives, batch commands, and what look like PE64 executables in there.
MSSQL is basically an OS of its own, and does a lot of things in its sandbox that you'd normally expect OS to provide (like really low-level memory management and I/O, and I think even threading is heavily customized) - and that's on Windows. So it wouldn't be surprising if that is the case on Linux also.
Re: Microsoft announces the next version SQL Server for Windows and Linux
#89I'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?
Licensing fees.
Re: Microsoft announces the next version SQL Server for Windows and Linux
#90Earlier quoted context omitted.
Apparently they ship it together with Windows as library OS: https://twitter.com/TobiasSQL/status/798937457916002304 >The Platform Abstraction Layer (PAL) powering @SQLServer on #Linux evolved from the MSFT Research Drawbridge project
So Microsoft Wine? Part of the way there?
If I understand correctly, this is not even a compatibility layer like Wine. This is literally a part of the Windows kernel and userspace, running entirely inside Linux userspace.