Microsoft SQL Server has steadily gained ground on other database systems and now surpasses the competition in terms of performance, scalability, security, developer productivity, business intelligence (BI), and compatibility with the 2007 Microsoft Office System. It achieves this at a considerably lower cost than does Oracle Database 11g.
Included in This Document
* Executive Summary
* Performance and Scalability
* Business Intelligence
* Integration with the Microsoft Office System
* Windows Server 2008
* Total Cost of Ownership
Link to the white paper.
Security is essential for the protection of your intellectual property and the trust of your customers and partners. SQL Server has proven to be the market leader in database security. Compared to Oracle 11g, it has fewer vulnerabilities, robust security features at no additional cost, and a vastly better update system.
Now that the Windows Server 2008 operating system accounts for more than two-thirds of all new server sales and SQL Server has become one of the most popular database products, independent software vendors (ISVs) increasingly see SQL Server running on Windows as the platform of choice.
An excellent database system is only as useful as the applications that are developed for it. Microsoft provides an integrated development environment that connects seamlessly with client, mid-tier, and data-tier systems. A range of new features makes SQL Server 2008 databases more accessible to developers, reduces development time, and improves performance. Oracle developers must use a wide range of tools to achieve the same goals.
Coursey: Abstract from Whitepaper.
Reference: Pinal Dave (https://blog.sqlauthority.com)
I’m no expert, but I do work in an environment with SQL Server and Oracle. Personally I would pick SQL Server over Oracle for everything I do at work. I love SQL Server… but, like many comparison “White Papers” put out by manufacturers about their own products, this just reeks of being one-sided. I was struck by the conclusion where it says:
“SQL Server 2008 meets or exceeds Oracle 11g in every area that matters to the business”
that is just silly. While I would never choose to use Oracle, I am confident that it offers many features and enhancements that leave SQL Server in the dust that certainly do matter in some businesses. How about their RAC product (or whatever they call it now)? That seems like a somewhat significant feature that Oracle offers that SQL does not?!? It is like MS saying that Virtual Server is even close to VMWare ESX in the enterprise. At the core they are probably on par with the standard features, but what admin who who has ever used VMotion would EVER give it up?
Just for clarity, I have never picked Oracle over SQL, but I must assume that with all that nasty complexity comes some enterprise features that some businesses appreciate! Either that, or the high priced Oracle admins have put their corporations and management under their voodoo spells…
You obviously are unfamiliar with Oracle. That’s the problem with every comparison I’ve read. You see, I’ve worked with both – for years – and Oracle, if done correctly, will provide lower development costs, faster execution, and higher stability – hands down.
The problem is that most developers and dbas are incompetent.
Interest comments from all of you, and everybody makes valid points. I am biased towards Oracle, but I do see the value of SQL Server. SS2000 and SS2005/8 are good for operations where there is no full time DBA. Another point to consider is that many companies are still run by doing ROI’s and for many accountants/management teams the cost of running Oracle over SQL Server is a big factor. Or so they percieve. If the licensing was cheaper for Oracle I think this discussion would be around preferences for a system by the DBA’s.
Also , currently I am working in an environment and we are still running a version of Oracle 7.3.4 plus some SS2000 and soon SS2005. Also another point to note is that previously many applications came written for Oracle only. Now we have a choice of both or apps written for SS only.
Per Rick’s comment “The problem is that most developers and dbas are incompetent.”
If using Oracle results in that level of bitterness, I’d prefer to stick with MS SQL … hands down.