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

We can connect to database servers in Oracle Cloud environment or other linux servers using ssh private key. After creating a server or database deployment, …

We connect to all servers that we create in Oracle Cloud environment with ssh public and private key. When creating our database server or normal …

Creating a new instance using Oracle Database Cloud Service on Oracle Cloud is called database deployment. It is possible to simply create a database and …

Before SQL Server 2014, we were able to create an index in two ways by right-clicking on SSMS and clicking new index, or using the …

If the Oracle database is in archive log mode, the redo logs are copied as archive files. Archive files will be transferred to the directory …

In Mysql servers, the following methods can be used to find where the error log file is. Find where the Error Log is with SELECT …

In MySQL NDB Cluster databases, when the data memory is full, “The table is full” error occurs in all operations in the tables. To resolve …

You can use the below functions to convert the timestamp to date and date to timestamp. timestamp to date -> from_unixtime() date to timestamp -> …

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. …