Database management system DBMS architecture design and strategy

  • March 14, 2006 14 Mar'06

    Can Toad for Oracle compete against Oracle's free SQL Developer?

    Oracle's newly released free SQL Developer could spell trouble for Quest Software Inc.'s popular Toad for Oracle software.

  • February 22, 2006 22 Feb'06

    Column: Why open source databases are ripe for acquisition in 2006

    Is the clout of open source databases, expected to grow to a $1 billion market by 2008, going to lead to their demise by acquisition? This columnist ponders the meaning of Oracle's Sleepycat and Innobase acquisitions, and MySQL's anti-acquisition ...

  • February 16, 2006 16 Feb'06

    Analyst sizes up Oracle's post-Siebel BI strategy

    Business applications expert Joshua Greenbaum sizes up Oracle's post-Siebel business intelligence (BI) strategy and explains why he thinks general-purpose BI offerings belong on the endangered species list.

  • February 09, 2006 09 Feb'06

    Is Ingres a viable alternative to Oracle for SAP users?

    Database pros responding to a recent column express serious reservations about one venture capitalist's plan to market open source Ingres to SAP users.

  • February 02, 2006 02 Feb'06

    Can Oracle be unseated as a top SAP database?

    SAP would love to change the fact that the Oracle database is highly used among its customers, explains Joshua Greenbaum, principal analyst at Enterprise Applications Consulting.

  • January 31, 2006 31 Jan'06

    A closer look at the Oracle-Sun deal

    Oracle CEO Larry Ellison and Sun Microsystems Inc. CEO Scott McNealy got together recently at Oracle headquarters for a town hall style meeting during which they announced a "newly reinvigorated" partnership between their two firms. Under the deal, ...

  • January 19, 2006 19 Jan'06

    One year later, Oracle touts progress of Fusion

    Top Oracle executives took to the stage yesterday to detail the progress of Fusion thus far and to lay out a Fusion roadmap for the future.

  • January 12, 2006 12 Jan'06

    Oracle and Sun tie the knot

    Oracle and Sun yesterday renewed their vows of collaboration and detailed their plan to give Microsoft .NET a Java-based run for its money.

  • January 05, 2006 05 Jan'06

    Leading the marketplace with data warehousing

    There are different approaches that need to be taken in evaluating a vendor-led or a consumer marketplace for data warehousing.

  • December 29, 2005 29 Dec'05

    SQL Server consolidation pros and cons

    You may want to consolidate SQL Servers to reap the reduced licensing, hardware and administrative costs, but there are various "gotchas" to consider before making such a move. Contributor Hilary Cotter outlines the pros and cons.

  • December 26, 2005 26 Dec'05

    Working with multiple versions of SQL Server

    A typical SQL Server shop has some combination of newer and older database versions running, posing a challenge to application functionality. This tip discusses the expiration of older version support and how to integrate multiple versions ...

  • December 20, 2005 20 Dec'05

    Checklist: How to test SQL Server security

    You must regularly test SQL Server security if you hope to identify security weaknesses before an intruder does. Contributor Kevin Beaver offers SQL Server security testing methods, tools and a checklist to help you find and fix vulnerabilities.

  • December 15, 2005 15 Dec'05

    Stored procedure: Keep track of SQL Agent jobs

    Enterprise Manager's standard tools aren't much help in examining SQL Agent jobs. To get details about jobs currently running, try this sp_ListJobInformation routine instead.

  • December 15, 2005 15 Dec'05

    Managing backups for a large number of SQL Servers

    In a large SQL Server 2000 installation, you have to contend with many backup and recovery challenges, from monitoring to testing with minimal impact on network bandwidth. Edgewood Solutions' Greg Robidoux offers points to consider when establishing...

  • December 13, 2005 13 Dec'05

    Are single-platform databases in your future?

    As databases become more alike and all of them have the capability to pull data from multiple sources, dare to be different! Moving everything to a single platform can make things less complicated.