Database management system DBMS architecture design and strategy

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

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