Eric M Russell (11/9/2011)
IceDread (11/8/2011)
The only advantage ms sql server has over oracle is it's price. Some would perhaps make an argument for the user interface as well. If ms sql server were to become closer in price to oracle, there is no reason at all to stay with ms sql server since it's inferior in every way.The usability of SQL Server compared to Oracle is deeper than just the GUI tools. It has to do with the underlying architecture. SQL Server is much easier to configure, secure, maintain, learn, and develope on. Even if the licensing cost of SQL Server and Oracle were identical, SQL Server would still be a more cost effective platform for developing and supporting database applications.
Are there some parts in specific you think about when you say that it's easier to learn ms sql server?
I view Oracle as a better database in general because it's more effective and has, to my knowledge, fewer bugs. In oracle you can also do load balancing, I have not found a way to load balance an sp in sql server. However, sql server is as you mention proven to be more secure.