4 ms·

MS is not changing their tack because there is a vibrant big business community with budgets that depend on MS SQL and it fills the need. Which Open Source DB

by cl8ton 13y ago

MS is not changing their tack because there is a vibrant big business community with budgets that depend on MS SQL and it fills the need. Which Open Source DB does everything that MS Enterprise SQL does and why aren’t you using that instead?

BrentOzar 13y ago
> Which Open Source DB does everything that MS Enterprise SQL does and why aren’t you using that instead? I used to think the replacement wouldn't have to do everyone MSSQL does - after all, nobody uses all of the features. But getting a core subset often isn't enough either - for example, Windows Azure SQL Database supports a core subset of features and datatypes, but I still constantly hear people say it's not enough to migrate their apps.
- xradionut 13y ago
  We were skeptical of Azure before NSA revelations, but now; "Hell No!". Besides that, Microsoft has pretty well pissed off all but the most entrenched developers.
  - recursive 13y ago
    It seems to me that the group of "most entrenched developers" is still pretty big. In real life, it's the most common kind I see.
- jaynate 13y ago
  If you think lock in on SQL server is bad wait til you're locked in on azure.
elchief 13y ago
Postgres is not there yet, but getting closer. (Proper) materialized views coming in 9.4.
rbanffy 13y ago
> Which Open Source DB does everything that MS Enterprise SQL does They shouldn't fear a competitor that does everything they do. They should fear a bunch competitors each doing a set of features a given customer needs. SQL Server is Microsoft's best software product, but why would I even bother with it since both MySQL and PostgreSQL do everything I need from an RDBMS, for a tiny fraction of the TCO and with comparable if not better performance and much better platform support? And why would I even consider it when non-relational datastores are a much better fit for most of my data? It makes sense if you are into Windows, but makes no sense whatsoever if you are not.
Farox 13y ago
That's the thing. It gets the job done and if you need a dev to develop a certain feature that MS SQL has you recouped your licence costs right there. This does suck for small/mid sized businesses though. :/

by cl8ton 13y ago

BrentOzar 13y ago

> Which Open Source DB does everything that MS Enterprise SQL does and why aren’t you using that instead? I used to think the replacement wouldn't have to do everyone MSSQL does - after all, nobody uses all of the features. But getting a core subset often isn't enough either - for example, Windows Azure SQL Database supports a core subset of features and datatypes, but I still constantly hear people say it's not enough to migrate their apps.

xradionut 13y ago
We were skeptical of Azure before NSA revelations, but now; "Hell No!". Besides that, Microsoft has pretty well pissed off all but the most entrenched developers.
- recursive 13y ago
  It seems to me that the group of "most entrenched developers" is still pretty big. In real life, it's the most common kind I see.
jaynate 13y ago
If you think lock in on SQL server is bad wait til you're locked in on azure.

elchief 13y ago

Postgres is not there yet, but getting closer. (Proper) materialized views coming in 9.4.

rbanffy 13y ago

> Which Open Source DB does everything that MS Enterprise SQL does They shouldn't fear a competitor that does everything they do. They should fear a bunch competitors each doing a set of features a given customer needs. SQL Server is Microsoft's best software product, but why would I even bother with it since both MySQL and PostgreSQL do everything I need from an RDBMS, for a tiny fraction of the TCO and with comparable if not better performance and much better platform support? And why would I even consider it when non-relational datastores are a much better fit for most of my data? It makes sense if you are into Windows, but makes no sense whatsoever if you are not.

Farox 13y ago

That's the thing. It gets the job done and if you need a dev to develop a certain feature that MS SQL has you recouped your licence costs right there. This does suck for small/mid sized businesses though. :/