Tips

  • Finding full table scans on 9i

    Full table scans are usually not welcome in an OLTP environment. This SQL script will help identify them for you.

  • Oracle myths

    Author Mike Ault outlines some myths that are rampant in the Oracle community.

  • Open source alternatives

    This die-hard Oracle fan is seriously considering open source alternatives such as PostgreSQL and MySQL.

  • Upgrading PeopleSoft, part 3

    The final segment of this three-part series on PeopleSoft upgrades covers application-specific conversions and the go-live process.

  • Why Oracle hashing is so cool

    Our expert columnist Craig Shallahamer opines about why Oracle hashing is such a cool search algorithm.

  • The most important DBA skill

    The most important skill that a DBA must have isn't

  • Defense tactics for SQL injection atta

    The rate of application intrusions continues to rise, and many result from SQL injection attacks. Fortunately, SQL injection holes are relatively simple to defend against.

  • Latches and CPUs

    We have all heard that it doesn't make sense to have more latches then the number of CPUs. While this appears to make perfect sense, it conceals a hidden lie. And here's why...

  • Replication for high availability

    Replication for high availability can be simple and cheap, or it can be elaborate and expensive. It all depends on what you want to replicate -- and your performance goals.

  • Upgrading PeopleSoft, part 2

    The second part of this series on upgrading PeopleSoft delves into data conversion, condensing the time required, and the pain points to watch out for.

  • Update a referenced column with MERGE

    Here's how to update a referenced column in a MERGE statement.

  • Missing rows in HTML table outprint

    An ITKE member had questions about missing rows in his HTML table outprint, and fellow techies jumped in on the conversation and helped out.

  • Delimited data set generator

    This tip allows you make a backup of table data in a delimited format.

  • Upgrading PeopleSoft

    With Project Fusion looming, you need to get up to speed on some of the technology that will be fused into the new apps suite. This tip explains a PeopleSoft upgrade.

  • SQL generation vs. Oracle SPs

    An ITKnowledge Exchange member had a question about which option to choose: SQL generation or stored procedures. Fellow Oracle techies helped Steve.

  • CRM implementation: Check IT List

    AMI Partners consultant Laurie McCabe provides a nine-step guide for successful CRM implementations.

  • Database trends

    Craig Mullins talks about changes in the DBMS that affect your work.

  • It's alive! It's alive!

    Craig Mullins explains why the mainframe is here to stay, despite rumors otherwise.

  • How many DBAs?

    Craig Mullins offers tips for DBA staffing.

  • A database bookshelf

    Craig Mullins recommends his favorite books on DBMS and SQL fundamentals.