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

If you are reading this article, you should read my articles “What is Primary Key And Foreign Key” and “What is Unique Constraint” at first. …

We will change user profile in Oracle in this article. Its very easy and simple step. Profiles allow us to manage users according to certain …

Difference Between Primary Key and Foreign Key You can be find what is Primary Key and Foreign Key and what are differences between Primary Key …

With Crontab Jobs you can run your bash scripts regularly on the linux operating system. In some cases you may want to check if your …

We will talk about SQL Server Statistics in this article. What is Statistics in SQL Server? When you execute a query on SQL Server, it …

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 …