If you get the error “This secondary replica is not connected to the primary replica. The connected state is DISCONNECTED”, it means that you are …
Read More »Faruk Erdem
How To Find Deleted Objects in SQL Server
This article contains script to find deleted objects in sql server. It happened to every database administrator. Application developers or your supervisors may ask you …
Read More »Connect To Postgres from command line in Windows
Sometimes you may need to connect to postgresql from command line in windows. In this article, I will show you how to do this. First, …
Read More »Create Hash of File in Windows
If you want to create hash of file in windows, this article will provide necessary information for you. You have an important file and you …
Read More »How To Run Single Command on Multiple Linux Servers
If you have more than one server you manage and if you connect to multiple servers with ssh and run single command on multiple linux …
Read More »How To Create Ssh Key and Connect Another Machine by Copying SSH Key
If you are using Linux and want to securely connect to servers without using a username password, you can create a ssh key and connect …
Read More »How To Grant root Privileges to a User in Centos
In this article, we will see how to create a user in Centos and how to grant root privileges to a user in Centos. How …
Read More »Revoke Permission in PostgreSQL
This article contains information about revoke command usage in PostgreSQL. You may want to revoke permissions of users. In this case, you can use the …
Read More »Upgrade PostgreSQL 11 to 12
In this article, we will upgrade PostgreSQL 11 to 12. If you want to upgrade PostgreSQL 10 to 11 you should read the article “Upgrade …
Read More »How To Change Column’s Data Type in PostgreSQL
Suppose that we created a table in the database by following the normalization rules for our application. However, we realized that the data type of …
Read More »