Wednesday, March 17, 2010

The real difference between SQL Server and Oracle

For years now there's been a constant war between Microsoft supporters and Oracle supporters. Oracle has these features, SQL Server has these features, etc. But that's not really where the real importance lies. Sure, functionality is a part of it because your database should be able to do what you need it to do. However, do you want to know what the real difference between the two companies is and why Microsoft
For years now there's been a constant war between Microsoft supporters and Oracle supporters. Oracle has these features, SQL Server has these features, etc. But that's not really where the real importance lies. Sure, functionality is a part of it because your database should be able to do what you need it to do. However, do you want to know what the real difference between the two companies is and why Microsoft has made such a strong impact in the industry?

The answer is simple: information. Microsoft has built such a strong community and its members are committed to helping each other. There are so many forums out there you just don't have time to go to them all. And one of the most amazing things I've found is that the MSDN forums are actually sharked by Microsoft's own PSS and dev teams. You just can't get any better than that. You've got both the guys on the support team, and the guys who actually write the code helping you with your problem. You've got MVPs out there writing new and exciting books like crazy. They're really giving up all the secrets on how SQL works, and what you can do with it.

Oracle is still living in the old days where everything is a good ole boys club. This is the world of Linux and Unix where they started, and it's a dinosaur, man. You just can't afford to do business like that anymore. You have to open up your community and start programs to encourage your best people to help and teach.

If you take any 10 DBAs from each side and ask them to look up a solution to a problem on their platform, the SQL guys will find the answer much faster than the Oracle guys will. And that's just a fact. If you're looking on specifics on how Oracle works internally, it's almost impossible to ferret out the info, but with SQL, there are so many open resources it's just a matter of a few minutes to an answer.

Microsoft also has a Connect Web site where users can enter in bugs and feature requests, and these requests go straight to the dev team. Your voice gets heard.

So the real difference between these two platforms is community. Microsoft has gone to great lengths to build a community and really support it. And Oracle is still doing business the old way. It's almost like Oracle's still proud that they're holding on to the good ole boys club. They're proud of how complicated everything has to be in Oracle. Knowledge is for the few and the special. And this attitude is pervasive in third-party vendors as well. Look at all the vendors out there making video training. I haven't seen any for Oracle, but SQL has tons. OK, I've seen a couple for Oracle, but they're all that old style CBT from the 1990s. But there aren't any high-level Oracle people out there making video training that's affordable for the end user.
And the stuff Oracle posts on its site is incomplete at best. It's just not enough. And it's not like nobody's using Oracle. So the user base is there. Then why isn't the training there too?

I think the third-party training vendors don't have the training available for Oracle because of the lack of community. It's that same attitude propagated by the mothership and the whole Unix world that keeps information from being available. And it's frustrating because being someone who would like to learn more about Oracle I could use some of those resources.

The problem is though that I've sought them out before and they're just too hard to find. And I don't have time to run comprehensive searches for everything under the sun just to figure out one little aspect of Oracle. I'd rather go through a modern tutorial by an Oracle expert that actually explains how some of this stuff works. Show me good examples, explain to me what they mean, etc.

You know ... pretend that there are some people out there who haven't been doing this for 20 years. Because people are going to use what's available to them and what will get them up and running the fastest.

And right now, with all the factors involved, Microsoft is a better overall platform than Oracle because it doesn't matter what your platform can do if nobody knows how to make it work.

Reference:http://www.infoworld.com/d/data-management/real-difference-between-sql-server-and-oracle-755
Retrieval Date:03/17/10

No comments:

Post a Comment