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 …
Read More »dbtut
Querying information about Exadata cellnode
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, …
Read More »How To Monitor Application Error with Extended Events
When there is an error in the database, the first place to look at is SQL Server Error Log. Sometimes there is no problem …
Read More »EXCEPT Operator in SQL Server(TSQL)
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 …
Read More »How to Convert Administrator-Managed Database to Policy-Managed Database in Oracle
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 …
Read More »The certificate, asymmetric key, or private key file is not valid or does not exist; or you do not have permissions for it
In order to restore the backup of a database encrypted with TDE (Transparent Data Encryption) to another instance, we need to transfer the certificate …
Read More »TDE(Transparent Data Encryption) On SQL Server
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 …
Read More »SQL Server Loops and Conditions(TSQL)
In this article, we will examine the loops and conditions we use in TSQL. Conditions in TSQL: IF Statement in SQL Server: If the …
Read More »CASE Statement in SQL Server(TSQL)
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 …
Read More »While Loop in SQL Server(TSQL)
By creating a loop, we can perform certain operations as long as this loop continues. We can use While Loop as follows. As long as …
Read More »