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...
SQL Server 2012 Licensing model
With SQL Server 2012, Microsoft has changed its licensing model along with “consolidating” the different types of editions. Gone is...
Sending an email in unix with attachments
Mailx is an easy way to send email from your unix/linux system. Â With mailx you can get your server to...
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...
Setting up database mail in SQL server
Wouldn’t it be cool if your database server reached out to you when it wants to let you know something...