Database management system DBMS architecture design and strategy

  • 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

    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 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 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.

  • 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...