Hacker News Board Hacker News, browsed like a classic message board
Live data from Hacker News

How Microsoft brought SQL Server to Linux

techcrunch.com

Post reply on HN
Print view View original

171–180 of 207 posts

Re: How Microsoft brought SQL Server to Linux

#171

Post by mmargerum »

CrLf wrote: post #102

I'm still unsure of the usefulness of SQL Server on Linux. I don't see the point of running SQL Server on Linux (I'd rather choose PostgreSQL or something), nor do I see the point of choosing Linux if I'd already settled for SQL Server. I don't think this (in the end) is anything more than a marketing trick, there to give the illusion of choice. This is not uncommon in ISVs, btw. There are many commercial offerings t…

I don't want or need windows server and certainly don't want to pay for cals for my users. However, I'm very happy with sql server and will pay for that running on Linux . My middleware is go and I can cross compile it to Linux from my mac. I would have no code to rewrite to make it happen

Re: How Microsoft brought SQL Server to Linux

#172

Post by mmargerum »

snuxoll wrote: post #145
gwbas1c wrote: post #126

Earlier quoted context omitted.

I work for a SAAS company that uses MS SQL. I've heard over an over that ops and management loves MS SQL but hates Windows. MS SQL is the product that people are choosing, not Windows. Why should the MS SQL team force people to choose Windows?

As much as I love PostgreSQL, which is a lot, MS SQL still has some exceptional functionality around business intelligence and handles large reporting warehouses with ease. We just purchased three UCS blades for a new SQL Server deployment to consolidate our existing databases and handle the data warehousing project we are starting, here I am wasting days writing ansible modules and roles to set everything up when I…

I have been using sql server since 6.0, the standard edition is a steal for the price. Been running critical systems on it for two decades and it's been an absolute rock since the version 7 rewrite.

Re: How Microsoft brought SQL Server to Linux

#173

Post by manigandham »

Like the article suggested, we use SQL Server and it's running on the only Windows host in our entire stack. This is a great move and we're looking forward to being completely on Linux.

Postgres is a great database but SQL Server has some fantastic features like columnstores, in-memory oltp, graph queries.

Linux has better tooling than Windows and SQL Server has better tooling than all other relational databases, it's a great match.

Re: How Microsoft brought SQL Server to Linux

#174

Post by snuxoll »

mmargerum wrote: post #172
snuxoll wrote: post #145

Earlier quoted context omitted.

As much as I love PostgreSQL, which is a lot, MS SQL still has some exceptional functionality around business intelligence and handles large reporting warehouses with ease. We just purchased three UCS blades for a new SQL Server deployment to consolidate our existing databases and handle the data warehousing project we are starting, here I am wasting days writing ansible modules and roles to set everything up when I…

I have been using sql server since 6.0, the standard edition is a steal for the price. Been running critical systems on it for two decades and it's been an absolute rock since the version 7 rewrite.

To be fair, in comparison to DB2 or Oracle it's not hard to be a steal for the price.

Re: How Microsoft brought SQL Server to Linux

#175

Post by bdcravens »

peter_retief wrote: post #38
bdcravens wrote: post #24

Earlier quoted context omitted.

I assume you're anti-AJAX then? (XMLHttpRequest having originated in IE)

I wouldn't call Microsoft an innovator in the browser either, you miss the point entirely and you should read up on the destruction of Netscape https://en.wikipedia.org/wiki/Netscape

You're presuming I'm unaware of the history. I've been a professional developer since 1998.

Re: How Microsoft brought SQL Server to Linux

#176

Post by y4mi »

hungerstrike wrote: post #148
foodie_ wrote: post #124

Earlier quoted context omitted.

Curious why have postgres and SQL server?

He said that they "originally developed for MS SQL." and then "Later we added in support for Postgres/MySQL." Sounds like they develop a product that can use multiple RDBMS back-ends. Also, I'm guessing that since 90% of the businesses out there use Microsoft products, you would probably want to support their products in such a venture. On a personal note, I find anything that's not SQL Server to be tedious to work w…

honest question, when would you query several tables without joining them somewhere?

you can do that on postgres as well btw, my first idea would be to create a function [1] and just throw the rows together. still can't imagine a usecase for that though, i'd always want to get them separately if they're unrelated.

you're correct on the GUI side however. Everything i've tried is a buggy mess. i've actually mostly given up on that front and just went with pgcli [2]. its pretty good for ad hoc queries. But it doesn't really help if you're trying to write a function. Its just nice for selects with lots of joins or nested selects.

[1] https://www.postgresql.org/docs/9.1/static/sql-createfunctio... [2] https://github.com/dbcli/pgcli

Re: How Microsoft brought SQL Server to Linux

#177

Post by coverband »

mmargerum wrote: post #172
snuxoll wrote: post #145

Earlier quoted context omitted.

As much as I love PostgreSQL, which is a lot, MS SQL still has some exceptional functionality around business intelligence and handles large reporting warehouses with ease. We just purchased three UCS blades for a new SQL Server deployment to consolidate our existing databases and handle the data warehousing project we are starting, here I am wasting days writing ansible modules and roles to set everything up when I…

I have been using sql server since 6.0, the standard edition is a steal for the price. Been running critical systems on it for two decades and it's been an absolute rock since the version 7 rewrite.

Indeed, version 7 came with the best improvements in features, scalability and stability I ever witnessed in a product. A bit later, SQL 2000 also broke new ground with its OLAP functionality.

Re: How Microsoft brought SQL Server to Linux

#178

Post by sctb »

peter_retief wrote: post #43
tiff_seattle wrote: post #8

Earlier quoted context omitted.

I can't tell whether this comment is satire or not.

Your comment is satire

You're not welcome to start flamewars on Hacker News and then stoke them every which way like this. Please comment civilly and substantively or not at all.

https://news.ycombinator.com/newsguidelines.html

Re: How Microsoft brought SQL Server to Linux

#179

Post by CrLf »

mmargerum wrote: post #171
CrLf wrote: post #102

I'm still unsure of the usefulness of SQL Server on Linux. I don't see the point of running SQL Server on Linux (I'd rather choose PostgreSQL or something), nor do I see the point of choosing Linux if I'd already settled for SQL Server. I don't think this (in the end) is anything more than a marketing trick, there to give the illusion of choice. This is not uncommon in ISVs, btw. There are many commercial offerings t…

I don't want or need windows server and certainly don't want to pay for cals for my users. However, I'm very happy with sql server and will pay for that running on Linux . My middleware is go and I can cross compile it to Linux from my mac. I would have no code to rewrite to make it happen

Honest question: won't SQL Server on Linux require CALs as well?

Re: How Microsoft brought SQL Server to Linux

#180

Post by ethbro »

lenkite wrote: post #163
ethbro wrote: post #158

Earlier quoted context omitted.

Then there's also Powershell (as much as it improves on cmd) reminding me of adventure games where I have to remember which of the five synonymous verbs is recognized and does the thing I want.

You don't have to remember anything in powershell as you get parameter completion and command completion by default. Powershell useability beats the standard UNIX shells (bash/zsh) in command discovery and assistance. You even use PSReadLine if you want VI keybindings at the command line.

Am I using it wrong? I realize a large majority of those aren't used frequently, but there are ~250 cmdlets, each of which attempts to have a unique-but-also-generic name.

https://technet.microsoft.com/en-us/library/ff714569.aspx

Let's say I didn't know ForEach-Object existed (trivial example, but generalizes), how do I find out there is a cmdlet that does what I'm looking for?

Post reply on HN