PHP & Postgres
I have been using PHP for a while now.  When people say PHP, its usually associated with   MySQL...
Retrieving data as XML using stored procedure
On a previous post I showed how to insert parent-child data from an XML document using stored procedure. Well here...
What if you encounter Error number: 20598 with SQL Server replication ?
Today on one of the sql server I encountered an interesting scenario, one of the dbas accidentally deleted data from subscriber...
Stored Procedure to insert data to parent and child using XML
Couple of days back I wrote an article that showed how to quickly insert a child table with a  parent...
Inserting child table with parent table having generated column
I am sure we all have come across situations were we have to populate a child table with a value...
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...