no announcement of support for mssqlstudio on other platforms yet though right? still, this is excellent - I love my postgres but having mssql on linux is a great option.
Microsoft announces the next version SQL Server for Windows and Linux
11–20 of 92 posts
Re: Microsoft announces the next version SQL Server for Windows and Linux
#12I can still remember an old conference when Microsoft bragged that running windows-only allowed them to remove 20-30% of the Sybase code base as they didn't need the cross-platform cruft. It would be interesting to see how they code for cross platform portability now.
Probably some variation of https://github.com/dotnet/coreclr/tree/master/src/pal . I know it's also used for something else relating to VS but I forget what.
Re: Microsoft announces the next version SQL Server for Windows and Linux
#13I can still remember an old conference when Microsoft bragged that running windows-only allowed them to remove 20-30% of the Sybase code base as they didn't need the cross-platform cruft. It would be interesting to see how they code for cross platform portability now.
Probably some variation of https://github.com/dotnet/coreclr/tree/master/src/pal . I know it's also used for something else relating to VS but I forget what.
I'm pretty certain its still written in C++ not dotnet.
Re: Microsoft announces the next version SQL Server for Windows and Linux
#14Is it released under a free/libre license?
Re: Microsoft announces the next version SQL Server for Windows and Linux
#15> all SQL Server users — including those using free edition — will now get access to the developer features that were previously restricted to the Enterprise edition.
This aspect is interesting. What I haven't done since all of these open source and cross-platform moves by Microsoft is go back and figure out how tech costs scale with user growth (starting from 0). It used to be no contest (initially), but I'm not sure anymore.
Re: Microsoft announces the next version SQL Server for Windows and Linux
#16Microsoft 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).
Installing SQL Server on Windows still sucks, though with your CM tool of choice it's less painful (still takes a flipping century to install, however).
Re: Microsoft announces the next version SQL Server for Windows and Linux
#17I can still remember an old conference when Microsoft bragged that running windows-only allowed them to remove 20-30% of the Sybase code base as they didn't need the cross-platform cruft. It would be interesting to see how they code for cross platform portability now.
IIRC, they have since adopted an OS/FS shim to be able to make porting like this generally easier... that said, there are certainly a lot of edge case features that need to be tested... I'd be surprised if there wasn't an effort to bring an electron based Management Studio for cross-platform usage. Which would be pretty damned cool...
The `tedious` package in node, makes it a drop dead simple db to use cross platform... Compared to say the beast that is Oracle, I haven't used db2 from node so can't compare there.
Re: Microsoft announces the next version SQL Server for Windows and Linux
#18Is it released under a free/libre license?
It's commercial, privately licensed software... that said, the out of the box defaults for MSSQL perform better than most databases, with features far easier to configure. I've been hoping for this for a long while... much better for most use cases than Oracle.
Re: Microsoft announces the next version SQL Server for Windows and Linux
#19Earlier quoted context omitted.
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).
Installing SQL Server on Windows still sucks, though with your CM tool of choice it's less painful (still takes a flipping century to install, however).
I had it installed and running in a couple of minutes. The wait is what I remember being the worst on Windows. apt was quick and painless though.
Re: Microsoft announces the next version SQL Server for Windows and Linux
#20Since https://www.microsoft.com/en-us/evalcenter/evaluate-sql-serv... is still focused on downloading ISO and cab files for Windows:
- Direct link to RHEL instructions: https://docs.microsoft.com/en-us/sql/linux/sql-server-linux-...
- Ubuntu: https://docs.microsoft.com/en-us/sql/linux/sql-server-linux-...
- Docker: https://docs.microsoft.com/en-us/sql/linux/sql-server-linux-...