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

Before reading this article, I would recommend you to reading article titled “Introduction to PostgreSQL and PostgreSQL Architecture“. What is MVCC? MVCC is the method used to ensure data consistency …

I am writing this article in order to be a guide for beginners. This article will be an introduction to PostreSQL. Before I get started to this article, I want …

Can we delete Transaction Log File? We can not delete primary transaction log file, but we can delete secondary log files. Sometimes we can create a second log file on …

You may want to change an Oracle user’s password for a number of reasons. Sometimes this process may be needed for the user to forget the password and sometimes for …

Oracle databases need to be added to oracle cloud control as a target in order to be able to monitor and manage them through Oracle Cloud Control. I will explain …

In this article, we will see how to grant super admin privilege to a users to track and manage all Cluster Resources on Oracle Cloud Control. Choose User on Oracle …

Why we want to add second log file? It is a process that we usually perform when there is no free space in the disk where the log file exists. …

I wanted to write this article because it has been mentioned in the topic “How To Shrink SQL Server Transaction Log” and there are some drawbacks in shrinking the data …

Before reading this article, you might want to read the article “How To Create a FileSystem on ZFS (Mount Point)” to create a mount point on ZFS. If you already have …

In Postgres you could be managing many databases on a Cluster. In some cases you may need to query the size all of these databases. You can query the size …