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

  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-678114b9d896f130495611/] 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 …

  In the era of digitization, information availability online has witnessed an exponential surge. The internet is brimming with textual content—be it emails, web pages, …