This article explains how to create a sequence column, also known as a auto-increment column in a MySQL database table.
Learn how to select random rows from a database table in MySQL, Oracle and MS SQL Server. Also learn how to retrieve random documents from a MongoDB collection.
This Oracle DBA cheat sheet is an essential guide for Oracle Database Administrators to perform day-to-day administration tasks
This article explains how to create, configure and delete Oracle databases using the graphical tool Database configuration Assistant (DBCA)
MongoDB Cheat Sheat - A quick reference of Mongo shell commands and usage example needed to perform most of the common tasks in MongoDB.
This article explains how to relocate or rename the datafiles of a Oracle tablespace in a few easy steps
How to terminate user sessions in Oracle without losing data.
How to easily change the name(DBNAME) and unique id(DBID) of an Oracle database using DBNEWID utility.
This article illustrates how to disable remote access for etiher root users or for all users.
How to recover a lost MySQL root password in five easy steps on Windows and Linux platforms.