Learn how you too can stamp out common database errors and learn a lot about relational databases along the way. ‘Ambiguous Groups’ is extracted from ‘SQL Antipatterns’, published by the Pragmatic Bookshelf.
Read More

Learn how you too can stamp out common database errors and learn a lot about relational databases along the way. ‘Ambiguous Groups’ is extracted from ‘SQL Antipatterns’, published by the Pragmatic Bookshelf.
Read More

Database change control is always difficult even under the best scenarios. Using Oracle’s DBMS_METADATA_DIFF becomes a great weapon for DBAs to regain control.
Read More

Multi-master replication for MySQL is easy to setup, is similar to master-slave replication and provides a host of features and options not available with the regular master-slave setup. Add to that the MMM database management tool, and you have a flexible, highly available MySQL cluster on which to host your application.
Read More

Tuning the performance of Oracle Database 11gR2 is still just as much of an art as it is a science. Jim Czuprynski focuses on the detection and analysis of performance bottlenecks within the database’s underlying input/output (I/O) subsystem.
Read More

A database administrator needs to plan for both planned and unplanned failovers, based on business requirements and service level agreements with customers. This article runs through the very basic starting points of a MySQL failover strategy then walks through a two-node, planned, manual failover.
Read More

As MySQL has evolved and added sophisticated and newer features, there are some areas that remain a bit rough around the edges. Maatkit offers a whole slew of tools for doing backup and restore, finding tables, monitoring your database server and many other database administration tasks you may not have even thought of.
Read More

This article illustrates how to upgrade an Oracle Database 11gR1 quickly and efficiently to Oracle Database 11gR2 and place its database files within ASM-managed storage, including a brief demonstration of how ACFS snapshots can be used to recover quickly from human error when crucial components of an Oracle home are damaged or destroyed.
Read More

The Data Manipulation Language (DML) includes the major commands, INSERT, UPDATE, DELETE, and SELECT…INTO. Today’s article focuses specifically on the uber-useful INSERT, UPDATE, DELETE, and SELECT statements.
Read More

Oracle’s latest purchase will provide additional protection from internal and external threats to enterprises’ Oracle and non-Oracle databases.
Read More