21–30 of 90 posts
In a docker container, no less.
This is entirely for testing a part of our application that needs to connect to legacy mssql servers. The server is spun up, databases are created programmatically, tests are run, and then the container is destroyed.
As for running this in production, ahahaha no.
Why would I invite that headache when I can just install PostgreSQL instead? https://www.pg-versus-ms.com/ says it all.
The certificate has expired, Chrome gives a nice ugly warning. But thanks for the link, I'm curious.
> If not, why not? First most important question to answer: in what way MS SQL Server would be better than PostgreSQL? Fields to consider: - Easier to install? (apt-get install postgresql-server) - Easier to use? (initiating the Sybase client library used to be terrible) (EDIT: it was installing the client library, not initiating it) - Easier to manage? (Postgres is excellent in this field) - Has important functions…
Yeah, I agree. Each has the odd thing the other doesn't but it is hard to justify the cost of SQL Server over Postgres
I would consider using it because: 1. I work in a backwards enterprise shop where "no one ever got fired for choosing Microsoft" and it would be easier (read as "possible) to get IT here to support it than Postgres. (That said, they do support Mongo internally but won't admit that to software teams) 2. It's much cheaper than Oracle, which is the other "enterprise" database where it's easier to get an install done 3.…
Why would I invite that headache when I can just install PostgreSQL instead? https://www.pg-versus-ms.com/ says it all.
The certificate has expired, Chrome gives a nice ugly warning. But thanks for the link, I'm curious.
Earlier quoted context omitted.
Yeah, I agree. Each has the odd thing the other doesn't but it is hard to justify the cost of SQL Server over Postgres
> but it is hard to justify the cost of SQL Server over Postgres For the benefits of readers who don't know, SQL Server Standard Edition is ~$2k USD per CPU core, and Enterprise Edition is $7k.
Honestly, SQL Server is priced very well - even enterprise edition given the features it provides. The biggest problem I have with it is T-SQL being terrible compared to pl/pgsql and the lack of developer-centric features like arrays, composite types, and a lot of other QoL features postgres has that MSSQL doesn't.
If you're going to deploy SQL Server, being able to do it on a platform that doesn't make me as a sysadmin/DevOps Engineer want to strangle myself with cluster configuration nightmares is a welcome change.
No, almost certainly not. Why would I use MSSQL in the first place, when I could just use PostgreSQL? The main reason I could see to use MSSQL would be "you're in a Windows shop already", and if that isn't the case, I don't see much reason for it.
In my experience, the main reason why most organizations run things like SQL Server or indeed Oracle is because they want to run applications that depend on those particular databases.
Windows Datacenter Edition is not cost effective for us, and that means we only run two Windows instances per host. By moving MSSQL to Linux, we can free up a Windows Server Standard license for other purposes.
You can run as many non-Windows instances on HyperV as your want, but you can only run 2 Windows instances unless you pay to license every physical core on the server a second or third time, even if you are not using them for Windows (for example, if you wanted to run a third Windows instance on a host.) This means we have additional hardware capacity that we use to run Linux instances next to the 2 allowed Windows instances.
Earlier quoted context omitted.
In my experience, the main reason why most organizations run things like SQL Server or indeed Oracle is because they want to run applications that depend on those particular databases.
Sure - but it would be weird for an application to depend on SQL server and not depend on Windows, and if you're going to be running Windows for some of your servers anyway it's easier to use the same platform for all of them.