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

We can use the SQL INTERSECT Operator between two SQL Statement. This operator returns the intersection of the first SQL Statement and the second SQL …

We can query all the information about the cellnodes on Exadata from any database. It is possible to query information from v$cell_config. With this view, …

  When there is an error in the database, the first place to look at is SQL Server Error Log. Sometimes there is no problem …

We can use the SQL EXCEPT Operator between two SQL Statement. It allows us to return records that exist in the first SQL Statement, but …

Hello there, In-Memory concept, which was first introduced into our lives with SQL 2014, was made more useful and compatible with SQL 2017. In this …

  Cluster database configuration can be Policy-Managed or Administrator-Managed. A Policy-Managed database has managed instances on the basis of server pools for the effective use …

  In order to restore the backup of a database encrypted with TDE (Transparent Data Encryption) to another instance, we need to transfer the certificate …

TDE is used to encrypt the database. With TDE, Data and Log files are encrypted at the page level in real time and there is …

  In this article, we will examine the loops and conditions we use in TSQL. Conditions in TSQL: IF Statement in SQL Server: If the …

Certain conditions are checked with the WHEN Statement when using the CASE Statement, and certain results are returned if the condition is met. We can …