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

In this article, I will explain you to how to update your statistics with the UPDATE STATISTICS command by table or database basis. I recommend …

To check connected users in MySQL database and what operations are performed, we can use mysql cli or we can obtain same information through queries. …

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 …