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

  Finding the total size of all your databases may be a bit difficult when your number of instances and your database count increases. Sometimes …

In this article I will continue to explain Oracle Automatic Storage Management. Before reading this article, I suggest you read the previous article. “Oracle Automatic …

In this article, I will explain the Automatic Storage Management (ASM) and ASM disk operations that come with the 10g version to the Oracle Database. …

Hello there, User management is very important in our database systems. We prefer DBAs to create or use more windows authentication instead of sql authentication. …

Hello there, A query operation is performed on SQL Server. If the cursor is on the line, the data in that line is processed. DML …

  You can find the name of the SQL Server Instance that you are connected to with the @@ SERVICENAME Function. If the instance you …

  You can run commands on all the compute nodes or cell nodes from a single server on Exadata. We can use the dcli utility …

If you ran a validation report on the windows, a warning might appear. “The RegisterAllProvidersIP property for network name ‘Name: ‘ is set to 1. …

  If there is a primary key foreign key relationship between two tables, you cannot delete the primary key without deleting the foreign key. When …

  When you try to delete the Primary table in tables that have a Primary Key Foreign Key relationship, you receive the error as follows. …