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

If there is a session that uses the temp tablespace you are trying to drop, the drop operation starts waiting. The drop operation is completed when all sessions using temp …

What is dbcc clondatabase in SQL Server DBCC ClonDatabase announced with SQL Server 2014 SP2. We are able to create a copy of the database without data to analyze query …

“enq: SS – contention” wait event may occur in problems with temp tablespace usage in Oracle RAC databases. At the same time, SMON may be preventing the use of temp …

We have been able to use Control Server Permission since SQL Server 2005. You can use this permission as an alternative to sysadmin. But it does not mean both are …

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, the following steps can be …

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 servers, it will ask us …

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 database server on Oracle Cloud …

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 tsql script. But we couldn’t …

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 or disk group specified by …

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 We can find where the …