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

  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, …

  From the Security tab, right-click on Logins and click on new login. In the window that opens, we give a name to Login from …

  Below is the simple script for monitoring mysql error logs. You can set the cron jobs as per your need(eg. daily,hourly) [crayon-674f4522ac325759843972/] Hope this …

  Teradata 15.0 has come up with many new exciting features and enhanced capabilities  . Teradata Query Grid is one of them. Teradata database now able …

  Logical replication was introduced in PostgreSQL 10 and it is different from streaming replication in many ways as described below:  Logical replication works at …