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

  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 …

  If you define the availability group asynchronous in the SQL Server Always ON architecture, the secondary database is slightly behind. You can find details …

  Sometimes we need to take backups on an AG basis. Finding databases that are included in individual AG and getting their individual backups will …

  Hello Everyone , I am back with next part of Database monitoring . You should read the first article of this series. “DB2-Database Monitoring-1” …