Database Tutorials MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux

  The problem was that the UNDO table space had several data files in recover mode. SOLUTION : Problematic files are recovered from backup and …

  We mentioned the Contained Database in our article titled “How To Move Logins To Another Instance (sp_help_revlogin)“. A Contained Database is a type of …

  Below is a simple script which backup Mysql users & grants into separate sql file. So,if you are taking particular database backup then this …

  This little guide is medium in scope, it is not exhaustive. It just gives you an idea to focus 1 Choose the right storage …

  This document covers steps involved in refreshing an Oracle database schema where source and target both are AWS RDS databases   Prerequisites: RDS Instances …

  If you do not use a contained database, you must also move your logins when you move the database to another instance. You can …

Rack Awareness: Rack awareness is having the knowledge of Cluster topology or more specifically how the different data nodes are distributed across the racks of …

  Below is the simple script for monitoring & auditing mysql general logs.This can be set as per the need(eg. daily,horly).It will help in capturing …

  Setting up a connection for Excel to the Teradata database was a little bit of a challenge. In this example, the Operating System was Windows …

  This error is taken when the archive log target directory is filled in databases that are in archive log mode. SOLUTION: As a solution, …