An update on recent service disruptions

Re:An update on recent service disruptions by nodesocket on Wednesday March 23, 2022 @08:38PM (#30785278)

Microsoft SQL actually is pretty good and really performant (with my limited production use).

I would argue it’s more performant than vanilla MySQL and it supports multiple write masters using peer to peer transactional replication an enterprise license feature (https://docs.microsoft.com/en-us/sql/relational-databases/re...)

[ Parent | on HN ]

Re:An update on recent service disruptions by prepend on Wednesday March 23, 2022 @09:45PM (#30785632)

It’s not a horrible database, but it’s just expensive and pretty much never a better choice than Postgres or other OSS dbs.

There are certainly some very niche use cases where you need it, but there’s a reason why tech stacks don’t use sqlserver. I think there are better ways to handle durable transactions and redundancy than using sql enterprise with sql‘s replication.

[ Parent | on HN ]