Database management system DBMS architecture design and strategy

  • November 22, 2005 22 Nov'05

    How to store database backup media

    As a DBA, you may not personally be responsible for long-term storage of backup files, but you must always be ready to replace data quickly in the event of a SQL Server failure. Edgewood Solutions' Greg Robidoux offers some important best practices ...

  • November 15, 2005 15 Nov'05

    SQL Server 2005 may call for a smarter DBA

    SQL Server 2005 embodies Microsoft's ambitions toward the larger enterprise database management market. Sybase, Oracle and IBM have traditionally required more highly trained -- and higher priced -- administrators. Will SQL Server now need them, too?

  • November 15, 2005 15 Nov'05

    Not upgrading? Keep SQL Server 2000 secure

    Chances are you're not planning to upgrade to SQL Server 2005 for at least another six months, leaving you without its improved data protection features. Contributor Kevin Beaver outlines 10 tried-and-true ways to keep SQL Server 2000 locked down in...

  • November 10, 2005 10 Nov'05

    Free download expands features for SQL Server 2005

    The November SQL Server 2005 feature pack from Microsoft provides interoperability, analysis and backward-compatibility tools.

  • November 07, 2005 07 Nov'05

    SQL Server launch: Milestone or stepping stone?

    SQL Server 2005 is ready to go, but applications that make the most of its new features may take some time to reach the market.

  • November 07, 2005 07 Nov'05

    Microsoft SQL Server 2005: The next generation

    Microsoft CEO Steve Ballmer called the launch of SQL Server 2005, Visual Studio 2005 and BizTalk 2006 the start of the next generation of "broad applications platform."

  • November 03, 2005 03 Nov'05

    SleepyCat CEO: Oracle deal an attempt to disrupt MySQL

    The CEO of SleepyCat Software believes Oracle Corp.'s purchase of Finnish firm Innobase is a testament to the power of open source.

  • November 03, 2005 03 Nov'05

    Step 6: Don't expose interfaces that create dynamic SQL to the end user

    This guide tells you how to enforce and ensure SQL Server data integrity on many fronts at once.

  • November 03, 2005 03 Nov'05

    Step 1: Back up, optimize and enable safety features

    Step 1 of our data integrity guides explains how to develop your data integrity strategy.

  • November 03, 2005 03 Nov'05

    Step 3: Consider using implicit transactions

    This guide tells you how to enforce and ensure SQL Server data integrity on many fronts at once.

  • November 02, 2005 02 Nov'05

    Column: Oracle vs. SAP: The Siebel Factor

    The sudden uptick in big deals reported by Siebel made Oracle look good, but it's unlikely a Siebel acquisition will alter the competition between SAP and Oracle.

  • November 01, 2005 01 Nov'05

    Hiding SQL Server

    If you're running SQL Server in an environment where you don't want computers to access it, you must hide the instance from network discovery. Contributor Serdar Yegulalp outlines two ways to hide your SQL Servers.

  • November 01, 2005 01 Nov'05

    The trouble with Oracle's password security

    Two researchers have exposed serious flaws in the database giant's password-hashing algorithm. The vulnerabilities could be exploited for brute-force and dictionary attacks.

  • October 31, 2005 31 Oct'05

    SQL Server 2005: 10 steps to justify and plan your upgrade

    Your decision to upgrade to SQL Server 2005 may come down to upgrade cost and time versus business improvement and competitive advantage. Get help justifying your upgrade here.

  • October 26, 2005 26 Oct'05

    GridApp offers DBAs a little Clarity

    New software from GridApp Systems promises to make it easier for DBAs to manage multiple database platforms.