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

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 …

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 loops used in programming languages, …

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

We will install SQL Server 2019 on Ubuntu 18.04 in this article. Our Server Resource Information: CPU : 4 RAM : 16 Disk : 80 gb Installation Steps: Step 1: …

Logical Standby Database does not support replication of all data types, tables, commands and PL / SQL Packages. Therefore, before converting a Physical Standby database to Logical Standby, a series …

The article contains information about CASE WHEN Statement in MySQL as an alternative to the if condition. With the CASE statement used in MySQL as an alternative to the if …

If you have more than one server you manage and if you connect to multiple servers with ssh and run single command on multiple linux servers, this article is for …

If you are using Linux and want to securely connect to servers without using a username password, you can create a ssh key and connect to remote server by copying …

In this article, we will see how to create a user in Centos and how to grant root privileges to a user in Centos. How to Create Users in Centos …