Database management system DBMS architecture design and strategy

  • December 08, 2005 08 Dec'05

    Checklist: Prepare SQL Server for peak workloads

    No matter what type of company you work for, chances are you have to prepare for spikes in SQL Server activity throughout the year. (Online retailers are in the midst of one right now.) Learn how to maintain highly available, fast-performing SQL ...

  • December 07, 2005 07 Dec'05

    Cryptography in the database: The last line of defense

    This excerpt from the new book by Kevin Keenan introduces the three types of data cryptography.

  • December 05, 2005 05 Dec'05

    Checklist: How to maintain an effective SQL Server DR strategy

    You may not classify hardware and application failures as disasters, but fail to prepare for such problems and you could have a system meltdown on your hands. This checklist will help you develop the documentation and best practices you must have ...

  • November 29, 2005 29 Nov'05

    Seven rules for well-behaved primary keys

    Seven quick rules for designing correct primary keys in Oracle databases.

  • November 28, 2005 28 Nov'05

    SQL Server 2005: To be or not to be an early adopter

    Early adopters tend to pay the price for kinks not yet worked out of new technology products. But SQL Server 2005 is not entirely new and may not need to be treated as such, says Edgewood Solutions' Greg Robidoux. He explains the benefits and risks ...

  • November 23, 2005 23 Nov'05

    SAP acquires retail software vendor

    SAP plans to acquire Khimetrics Inc., a retail software vendor with expertise in profitability forecasts and pricing strategies.

  • November 22, 2005 22 Nov'05

    SQL Server Management Studio: Don't miss these client tool enhancements

    For many long-time SQL Server 2000 DBAs, firing up Query Analyzer or Enterprise Manager is like coming home after a long day. But SQL Server MVP Adam Machanic says it's time to step out of your comfort zone -- or you'll be envying everyone who's ...

  • November 22, 2005 22 Nov'05

    How to back up and restore Analysis Services databases

    Backing up a Microsoft Analysis Services (MSAS) database looks simpler than it truly is. Contributor Baya Pavliashvili explains how to back up and restore MSAS 2000 databases and identifies enhancements in MSAS 2005.

  • 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

    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.