3 ms·
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 supp
by nodesocket 5y ago
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/replication/transactional/peer-to-peer-transactional-replication?redirectedfrom=MSDN&view=sql-server-ver15 https://docs.microsoft.com/en-us/sql/relational-databases/re...)
- prepend 5y agoIt’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.