Database Tutorials MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux 
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 »dbtut
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 »Deleting Files with a Specified Extension in a Folder Using Maintenance Plan(Maintenance Cleanup Task)
We perform maintenance operations on SQL Server using Maintenance Plan. This article describes how to delete files with a specified extension in a folder. I …
Read More »ALTER TABLE Statement in SQL Server(TSQL)
We can perform the following operations with ALTER TABLE Statement. Add a column to a table Delete a column from a table Change the data …
Read More »