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

The main purpose of this article is how to install MongoDB on Ubuntu Server(single node). Follow the steps below for the installation one by one. Step1: Install Mongodb Packages on …

In the article, the use of partition in MySQL is explained with various examples. What is Partition in MySQL? We can translate the partition word used in MySQL and advanced …

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 as follows. ORA-16674: standby database …

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 operations performed in Primary are …

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 know more about Sqoop. What …

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 are your life buoy that …

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 MySQL Stored Procedures. The most …

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 and 2019 versions, it started …

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 provides ACID support in 4.0 …

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 Apply after the time specified …