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

If a database created as Physical Standby is converted to a Logical Standby database while the Broker configuration is enabled, you may receive an error …

Sometimes, we may not want to reflect the operations performed on the Primary database to the Logical Standby database. It can be ensured that DML …

Sometimes you may need the transfer table from SQL Server to HDFS. In this article we will examine that but first you may want to …

Data backup is very important in any case. If you are storing data somewhere, you should definitely create a backup of the data. These backups …

In the article, the use of triggers in MySQL Systems is explained with examples. What is Trigger? Triggers in MySQL are a special type of …

SQL Server 2019 AlwaysOn Availability Group on Docker Container Part 1 SQL Server started to support Linux with the 2016 version. Along with the 2017 …

MongoDB is an open source and document-based NoSQL database designed to efficiently process large amounts of data. Stores data as Binary JSON documents (BSON). MongoDB …

To delete archive logs automatically on standby you should set LOG_AUTO_DEL_RETENTION_TARGET  parameter. The Foreign Archive Logs in Logical Standby Database is automatically deleted by SQL …

The article contains information about the while loop  in MySQL and its usage. While Loop in MySQL The while loop, which is one of the …

Below are some of the basic hygiene techniques and concepts we should keep in mind to get the maximum performance out of our query . …