In this article, we will see how to fix block corruption when there is a block corruption on a data file. If Block Corruption is …

This article contains information about SQL Server indexes and performance effetc of indexes. What is Index in SQL Server? Indexes allow us to access data …

What is Vacuum in PostgreSQL? When a delete operation is performed in Postgres, the deleted data is not deleted directly from the disk. The visibility …

I will tell how to install PostgreSQL Replication by using archive_command parameter on centos in this article. But usually I prefer to install postgresql replication …

To better understand this article, I would first recommend reading the “Index Concept and Performance Effect on SQL Server” and “Statistics Concept and Performance Effect …

What is Vlf(Virtual Log File)? Vlf (Virtual Log File) is a virtual file, as the name implies. The Transaction Log file with the ldf extension in …

You can receive “device is busy” error when you want to unmount a mount point in Linux operating system. For unmount operation, you may want …

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 …

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 …

Can I Delete SQL Server Transaction Log File? We can not delete primary transaction log file, but we can delete secondary log files in SQL …