Database Migration Doesn’t have to be a Nightmare

In recent times, database migrations have become a way of life for most database administrators. Whether moving to new hardware or into the world of virtual machines, what once was a rare project is becoming an almost everyday concern for database environments...
Tutorial: Advanced Navigation in Liferay Themes

Tutorial: Advanced Navigation in Liferay Themes

This is part 1 of a series written for UI-dev/FED new to Liferay. This assumes you’re solid with css/html/javascript, and have at least a passing understanding of dynamic languages like PHP or ASP. If you have a Java background, you may want to skip the parts that...

Rolling DB2 tablespace location change using HADR

One of our Virtual-DBA clients has a small DB2 environment with version 9.7 on Linux and HADR connecting a primary and standby system.  When the application team created the database, it was created using Automatic Storage on the /home filesystem.  This will...

SSIS 2012 Reporting Driver Errors

Often times when implementing data integration projects – we come across a need to implement a row/key based lookup and based on the found/not-found condition update or insert a row. I started implementing a simple data flow in SSIS. The idea was simple and has...

Patching Oracle Applications R12

So today we had a Virtual-DBA client ask us to help them patch their Oracle Financials R12 for a bug they were having a problem with. So I thought I would share with you the process we used to patch their server. They had sent me the patch number that Oracle support...