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

  There are thousands of queries submitted per minute and it is too much data. But, To avoid the performance impact on the database due …

  In this article, I will show you how to change users’ password expire policy. By default, all created users in Oracle Database will be expired …

  You may receive an error as follows when you try to install a different extension package that is not in Postgresql’s repo. To solve …

  Sometimes you may want to execute a script in more than one instance. It is a solution to connect to each instance individually, but …

  Step 1: Create SP sp_help_revlogin on master database of Source / Primary instance The following script create two stored-procedures. You will use the first one …

  Sometimes you may need to restart one of the Always On servers. In such a case, you will need to failover the Availability Group …

  Sometimes you may need to restart one of the servers you use Always ON. Suppose you have 2 servers and that you have 10 …

  One of the features facilitating the management of PostgreSQL is that it hosts its basic document. We can easily learn a brief description of …

First we go to https://yum.postgresql.org and into PostgreSQL where we will download the repo. Since we will install PostgreSQL 10 in our example, we will …

  I’m going to talk about a problem I tested in 11gr2 versions. Each user with a select permission in a table can update that …