Author: Paul Moen

Handling the Support Pager

A short story depicting the life of an on call DBA

Read More >

MySQL Recipes: Promoting a Slave to Master or Changing Masters

In MySQL–land, failovers for redundancy, disaster recovery, or load balancing are performed by master databases and slave databases, the most popular method using binlog replication. There are a couple more methods of replication which aren’t covered here. Also see the MySQL Replication FAQ. The methods are the same, but the formatting of the procedure(s) are less than ideal.

Read More >

Oracle block corruptions, DBV vs RMAN

Over-the-Top Tales from the Trenches: Bringing order to the chaos of every day DBA life.

Read More >

Recipes for Creating a Managed Standby with RMAN

Over-the-Top Tales from the Trenches: Bringing order to the chaos of every-day DBA life.

Read More >

The Mysterious World of Shmmax and Shmall

Over the Top Tales from the Trenches: Bringing order to the chaos of every day DBA life.

Read More >

SQLserver 2005 Query Efficiency

With the new dynamic performance views available in SQLserver 2005 you can run queries which allow you to determine these poor performers without much extra work. It is not statspack or Automatic Workload Repository (AWR) or V$ACTIVE_SESSION_HISTORY (more importantly) but it is a good start to determining what sql and what sessions are consuming the most resources in SQLserver 2005 instance.

Read More >

Useful SQLserver 2005 blogs

I have been scanning some blogs by different teams involved with SQLserver 2005. There is a bit of cross linking happening so some articles are repeated on one or more blogs. Here is a short list:

Read More >
Page 2 of 212