Live data from Hacker News

Microsoft announces the next version SQL Server for Windows and Linux

techcrunch.com

21–30 of 92 posts

Re: Microsoft announces the next version SQL Server for Windows and Linux

#21
post #6

Earlier quoted context omitted.

https://www.microsoft.com/en-us/sql-server/sql-server-vnext-... https://hub.docker.com/r/microsoft/mssql-server-linux/

Thanks! I wanted to checkout the Dockerfile for the container but by the looks of it, it was not published?

the dockerfile on dockerhub is only visible if its an automated build, done by the docker build service.

if you want the image to be auditable just write your own, its a really short and well documented installation that previous poster linked to.

Re: Microsoft announces the next version SQL Server for Windows and Linux

#23

Hopefully Microsoft will also provide a proper multi platform node.js client as well as ODBC support. I may aware of tedious, but it's missing a lot of features and I prefer officially supported code.

Hi mmargerum - We have a Microsoft engineer contributing to the tedious project now. Let us know what you want to see in our new gitter room: https://gitter.im/mssqldev/Lobby

Re: Microsoft announces the next version SQL Server for Windows and Linux

#24

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.

We did announce today that there is a new extension for Visual Studio Code which is cross-platform: macOS, Linux, Windows. Check it out: https://marketplace.visualstudio.com/items?itemName=ms-mssql...

Get VS Code here: http://code.visualstudio.com/

There are native command line tools as well: https://docs.microsoft.com/en-us/sql/linux/sql-server-linux-...

More to come!

Re: Microsoft announces the next version SQL Server for Windows and Linux

#26

Hopefully Microsoft will also provide a proper multi platform node.js client as well as ODBC support. I may aware of tedious, but it's missing a lot of features and I prefer officially supported code.

I'm okay with waiting on features. What I really want in tedious is a significantly faster parser.

Re: Microsoft announces the next version SQL Server for Windows and Linux

#27
post #16

Earlier 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).

SQL Server 2016 on Windows 10 was fairly one click install when I did it a week or so ago. It was infinitely better than my experience with SQL Server 2012, which was a struggle at the best of times.

Re: Microsoft announces the next version SQL Server for Windows and Linux

#28
post #3

I 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.

That was probably both true, and slightly misleading. I remember a talk on Drizzle (a MySQL fork looking to clean up and streamline the system after Oracle's buy) years ago where they touted similar numbers in code reduction by dropping support for all non POSIX or edge case OS's other than Linux, FreeBSD, and OS X (and that last one might have been added later). That is, they ripped out the HP-UX, AIX, Solaris and Windows specific code (and possibly more). Sybase looked to support a similarly diverse group of operating systems[1], so there were probably a lot of gains to be had even if they didn't remove all POSIX support.

1: http://infocenter.sybase.com/help/index.jsp?topic=/com.sybas...

Re: Microsoft announces the next version SQL Server for Windows and Linux

#29

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.

We did announce today that there is a new extension for Visual Studio Code which is cross-platform: macOS, Linux, Windows. Check it out: https://marketplace.visualstudio.com/items?itemName=ms-mssql... Get VS Code here: http://code.visualstudio.com/ There are native command line tools as well: https://docs.microsoft.com/en-us/sql/linux/sql-server-linux-... More to come!

very cool, I missed that. Not quite the same as studio but great nonetheless!

Re: Microsoft announces the next version SQL Server for Windows and Linux

#30
post #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 sur…

I'm not sure what it means. Do you have no restrictions on developer tools only or do they remove the 10GB database size restriction for SQL Server Express, the free version.
Post reply on HN