PHP & Postgres
I have been using PHP for a while now.  When people say PHP, its usually associated with   MySQL...
Gotcha when restoring database with restrictive access !
Starting from DB2 V9.1, IBM added a parameter on the CREATE DATABASE command called RESTRICTIVE. Â When this parameter is...
Stored Proc for SQL Server and DB2 UDB
We often grant permissions against table for users. Some use the GUI, some just script it out. I wrote a...
Loading db2 tables from another database
Data movement is a common task that app dev and dbas perform often. DB2 has multiple options to mass add...
Database System Views – A quick comparison
One of the best friends of Database Administrators , irrespective of race(read engine) and religion (read edition) Â are the System...
A glance at DB2 Audit
The buzz word for IT security is now audit. Â They want to audit activities in database for various compliance reason....