Database Tutorials MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux 
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 »Moving SVN Repository to Another Oracle Enterprise Linux Server
In this article, I will mention about moving a subversion repository from one server to another. Actually, it is a backup and restore job by …
Read More »SVN Server Installation on Oracle Enterprise Linux 6.4
In this article, I will mention about SubVersioN (SVN) installation on Oracle Linux Server. SVN is a type of version control system. Basically it allows …
Read More »