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

The MySQL root password allows the root user full access to the MySQL database. If you do not remember the root password of the mysql …

Mysql database should be backed up daily or periodically. It is possible to back up regularly with a script that we will create in the …

Once MongoDB is installed, by default, authentication is not enabled, users can login without specifying user name / password. Authorization is extremely important for security …

In my previous articles, I talked about MongoDB Community Edition installation and MongoDB Sharded Cluster components in general. You can access these posts below: “How …

As you know security is one of the key points during database administration. In MongoDB sharded clusters security between components of the cluster is provided …

MongoDb Sharding is a method used to distribute data to multiple machines. Sharding improves data access performance. if you want to install Sharded Cluster you …

This article describes how to install MongoDB Community Edition on CentOS Linux. The same installation applies to RedHat Linux versions. Versions: Operating System: CentOS Linux …

I will tell about changes in replication and replication installation in PostgreSQL 12 in this article. This article assumes that you are familiar with PostgreSQL …

What is Diagsnap in Oracle 12c Diagsnap is a new feature introduced in 12.1.0.2 GI, which manages the diagsnap resource, which collects additional operating system …

You can list applied patches in Oracle by query except for “opatch”. You can use DBA_REGISTRY_HISTORY for databases 11g and earlier, and DBA_REGISTRY_SQLPATCH for databases …