Sometimes you may need to restart one of the Always On servers. In such a case, you will need to failover the Availability Group …
Read More »SQL Server Availability Group Databases Synchronization Status
Sometimes you may need to restart one of the servers you use Always ON. Suppose you have 2 servers and that you have 10 …
Read More »PostgreSQL – List settings details
One of the features facilitating the management of PostgreSQL is that it hosts its basic document. We can easily learn a brief description of …
Read More »How To Install PostgreSQL On centos/redhat
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 …
Read More »Update Table Without Update Permission On 11gr2
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 …
Read More »How to Find Time Difference Between Primary and Secondary Database in SQL Server Always On Architecture
If you define the availability group asynchronous in the SQL Server Always ON architecture, the secondary database is slightly behind. You can find details …
Read More »How To Backup Only Availability Group Databases in an Instance
Sometimes we need to take backups on an AG basis. Finding databases that are included in individual AG and getting their individual backups will …
Read More »DB2-Database Monitoring-2
Hello Everyone , I am back with next part of Database monitoring . You should read the first article of this series. “DB2-Database Monitoring-1” …
Read More »How To Define a Share and Map This Share To Windows
In this article We create a share on a server and then we map this share on a server. I selected MSSQL as Category. …
Read More »How To Connect To Oracle On Linux and Solution Of The Error:” error while loading shared libraries: libsqlplus.so: cannot open shared object file: No such file or directory”
In this article, I will share the necessary steps to connect to Oracle through the linux operating system and the solutions to the problems …
Read More »