Cartesian Products usually don’t provide useful information and often result in mistakes that can hurt your database developer career. Learn to spot Cartesian Joins and banish them from your SELECT queries forever.
Read More

In the world of Business Intelligence, the day has arrived. Oracle recently announced the release of Oracle Business Intelligence 11g, and the goods are now available. Steve Callan provides a history, tracing the software back to its origins, and comparing 10g with the 11g version.
Read More

The SELECT statement is without question the most complex amongst MySQL’s data manipulation statements. This article covers the syntax of the SELECT statement, exploring its many optional clauses.
Read More

Interviewing for a PL/SQL developer position ultimately will turn towards talking about database structures and objects. This article goes beyond the basic table and index questions that you might expect and offers a tip or two designed to impress the interviewer.
Read More

Interviewing for a PL/SQL developer position ultimately will turn towards talking about database structures and objects. This article goes beyond the basic table and index questions that you might expect and offers a tip or two designed to impress the interviewer.
Read More

Increasingly, enterprises are looking at cloud services such as Amazon Web Services for their deployments. Datacenter virtualization is much more sophisticated than its desktop counterpart is, providing a whole suite of tools that allow you to control every aspect of your deployments. Join Sean Hull as he explores the MySQL – Amazon EC2 solution.
Read More

Oracle Warehouse Builder (OWB) has seen many changes lately. Keeping up with new features in the Oracle RDBMS can be challenging enough, but when you add changes to products, you may have your work cut out for you. This article explores some updates in OWB for Oracle11gR2 (plus some of the changes between 10g and 11g).
Read More

Oracle Warehouse Builder (OWB) has seen many changes lately. Keeping up with new features in the Oracle RDBMS can be challenging enough, but when you add changes to products, you may have your work cut out for you. This article explores some updates in OWB for Oracle11gR2 (plus some of the changes between 10g and 11g).
Read More

Knowing and working with master-master replication and keeping a true hot standby is very important, especially when your business requires a fast failover with the least amount of downtime. This article focuses on the wonderful world of multi-master replication. Knowing how to setup and implement multi-master replication is the next step to faster, automated failover.
Read More

Constantly watching CPU utilization is critical to a database administrator’s understanding of their database system. The sar utility, while seemingly small and insignificant can and should be used to help initially determine if any high-level CPU resource usage is out of balance, potentially pointing to database processing that requires tuning.
Read More