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

With SQL Server 2016, we are now able to use parallelism in the query using INSERT INTO… SELECT with WITH (TABLOCK). In order for the …

The AUD$ and FGA_LOG$ tables used for audit recordings are in the SYSTEM tablespace by default. SYSTEM tablespace is a tablespace with manual segment space …

What is Live Query Statistics Live Query Statistics is a feature that we can use with SQL Server 2016 Management Studio. But we can use …

When you want to disable the diagsnap feature that introduced with Oracle 12c Grid Infrastructure, ologgerd causes an error like “LoggerD –> Error connecting with …

What is a temporal table in SQL Server? We can store the history of inserts, updates and deletes by using temporal tables. Previously, we could …

In opatch operations, if the corresponding home is not included in the ORACLE_HOME parameter, all opatch related commands cause 134 errors. To avoid this error, …

We can use these statements together with the Foreing Key constraints. First of all, it is necessary to understand in detail what Foreign Key is. …

SecureFiles LOB storage is one of two storage types used with Oracle databases; the other type is BasicFiles LOB storage. Some advanced features, including compression …

These are the tasks for which DBAs required in a database industry. Defining the database architecture Creating data models Integrating new data sources Tuning business …

Oracle Autonomous Database is the world’s only data management system to automatically patch, upgrade, and tune itself. It handles routine database maintenance tasks while the system …