Database Tutorials MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux 
Sometimes, we can receive the below error. SSPI handshake failed with error code 0x8009030c, state 14 while establishing a connection with integrated security; the …
Read More »How To List RMAN Jobs
It is often time consuming job to gather detailed information about the backups of Oracle databases with RMAN. You need to collect information from …
Read More »How To Solve Errors in DPM Backup(Failed Backups in DPM)
DPM (Data Protection Manager) is Microsoft’s software for backup. Before reading this article, I recommend you to read other articles related to DPM on …
Read More »UNION and UNION ALL Operators in SQL Server(TSQL)
With UNION and UNION ALL Opertors, we can merge multiple sql statement’s result in a single result set. When we merge two SQL statements …
Read More »How To Calculate Actual Size of All Tables in a Schema in Oracle
When calculating the size of a table in an Oracle database, it is incorrect to just look at the data size. It is necessary …
Read More »Testing SQL Server Database Connection
Sometimes the application owners can come to you because the application cannot connect to the database. In this case, a DBA must first test …
Read More »How To Find Database Query From the Linux PID
In Oracle databases running on Linux, you can access the relevant session information from each user processes. In most cases, it is necessary to …
Read More »SQL Server Data Types(TSQL)
It is a very critical step to correctly determine SQL Server Data Types when designing tables to prevent unnecessary growth of the database. The space …
Read More »Declare Variables in SQL Server(TSQL)
In this article I will describe how to declare variables in TSQL. We can declare variables in a few different ways. • Declare a …
Read More »Exadata cellnode RS-7445 [Serv CELLSRV hang detected] [It will be restarted]
On Exadata cellnodes, the RS-7445 error can be received due to the inability to send heartbeat under overload. This error appears in versions 11.2.2.4.0 …
Read More »