SQL Server 2005 more complex

Jared posted on the oracle-l mailing list a link to eWeek’s review of SQL Server 2005. It is an interesting review and shows that SQL Server management is starting to be more complicated. I grabbed the following Oracle related points from the review:

  • SQL Server 2005 doesn’t have Oracle Database 10g’s management capabilities and scalable architecture, but Microsoft has made considerable strides in automating SQL Server’s management tasks and improving performance tuning and uptime.

  • Oracle still sets the standard, but SQL Server 2005 surpasses SQL Server 2000’s midtier limitations.

  • By making management more complex, Microsoft has discarded the one significant advantage it had over Oracle Database 10g and IBM’s DB2—ease of administration.

  • In a nod to the difficulty of replacing entrenched database servers and Oracle’s prevalence in enterprise applications, Microsoft allows administrators to use SQL Server 2005 and the Business Development Intelligence Studio as a front end for building OLAP (online analytical processing) cubes and prepackaged analysis applications of Oracle databases.

  • As Oracle did with Oracle Database 10g, Microsoft has added a tuning engine to SQL Server that optimizes performance founded on a knowledge base of best-practice tuning parameters.

  • Oracle still has the edge in database optimization, but SQL Server has been improved significantly in this area and bears careful consideration in competitive evaluations.

Possibly related:

Tagged , | Post a Comment