4 ms·
Microsoft is a different beast. They ship things based on the principal of least surprise. There are incredible features in newer versions of SQL Server that ar
by debacle 10y ago
Microsoft is a different beast. They ship things based on the principal of least surprise. There are incredible features in newer versions of SQL Server that aren't turned on by default when upgrading, even though no one would want to not have them on.
- dx034 10y agoTo be fair, SQL Server is probably the best product they've ever built. IMO, the only good reason to use Oracle was that it runs on Linux. With SQL Server on Linux, I'm sure they'll gain more market share over the next years. As much as I like using open source alternatives like Postgres, SQL Server for me is by far the best database system, from standpoints of performance, features and tools.
- orf 10y agoCan you give some examples?
- debacle 10y agoRead isolation is probably the biggest stand-out in terms of "Wow this is way faster why would anyone* not use this?" * Almost anyone, there are definitely potential pitfalls.