Microsoft did something right

27 February, 2005 (12:10) | SQL Server

For the past 3 months I’ve been working on a project that uses Oracle 8i. It made me appreciate what MS has done right with SQL Server. Beginning with a free limited version of the bits that developers can use, all the way up to the Enterprise product that comes in at what , half the price of Oracle? Not to mention plain old functionality. In Oracle 8i you can’t alter a column the same way as you can in SQL Server. You actually have to drop the table (including constraints ) and rebuild the table. As my buddy Dan pointed out : “Why doesnt Oracle provide a mechanism via their UI to do just that?”. He is right. Strikes me as some pretty lame programming on the part of Oracle. Is there anything good in 8i? Why yes - it supported functions even back then. Something that SQL Server took a while to get to.

In any case, I could be prejudiced, here but on balance I believe SQL Server based dev teams are more productive because MS specifically made it easy for us to deal with the db. So there you have it. MS did something right!

Write a comment