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

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 …

We are able to create Scalar User-Defined Function in SQL Server 2016 for Memory Optimized tables. For In Memory OLTP and Memory Optimized Tables, I …

It is possible to export a table containing BLOB data without data in the blob column. Starting with 11g r2, REMAP_DATA can be used with …