Re:Is The Microsoft Stack Really More Expensive?
by bad_user on Tuesday September 08, 2009 @01:47AM
(#810356)
Do you have bad experiences with MSSQL (or any other popular RDBMS) in an enterprisey environment ?
The only RDBMS I worked with that was too limited for the enterprise ... is MySql. But that's because when you have a "Big Ball of Mud" it is easier to patch many things in the data-store and MySql has bad support for stored procedures / triggers / views and I also wouldn't trust it to store a data warehouse. But Postgresql was more than suitable for such a scenario.
MSSQL is also more than adequate for any task you might have.
I've seen this argument many times before ... that Oracle is more reliable. But with Oracle unless you have a DBA with years of experience to administer it, you're pretty much screwed. And a RDBMS that requires so much tweaking and maintenance just to keep it working doesn't seem so reliable to me.
True story ... while working at Adobe I participated in meetings about the future of Oracle at the company. Long story short: the company holds much of its data on 2 big Oracle servers and the problem with the setup is that it doesn't scale horizontally. And many newer projects are using Mysql, because it has a good-enough replication system and it also has a hidden gem (mysql proxy).
It seems to me (at least as an outside observer ... I'm not a professional DBA) that these are just effects of marketing campaigns.
The only RDBMS I worked with that was too limited for the enterprise ... is MySql. But that's because when you have a "Big Ball of Mud" it is easier to patch many things in the data-store and MySql has bad support for stored procedures / triggers / views and I also wouldn't trust it to store a data warehouse. But Postgresql was more than suitable for such a scenario.
MSSQL is also more than adequate for any task you might have.
I've seen this argument many times before ... that Oracle is more reliable. But with Oracle unless you have a DBA with years of experience to administer it, you're pretty much screwed. And a RDBMS that requires so much tweaking and maintenance just to keep it working doesn't seem so reliable to me.
True story ... while working at Adobe I participated in meetings about the future of Oracle at the company. Long story short: the company holds much of its data on 2 big Oracle servers and the problem with the setup is that it doesn't scale horizontally. And many newer projects are using Mysql, because it has a good-enough replication system and it also has a hidden gem (mysql proxy).
It seems to me (at least as an outside observer ... I'm not a professional DBA) that these are just effects of marketing campaigns.