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 to find out who deleted …

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, psql must be installed on …

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 sent this file to someone …

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 servers, this article is for …

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 to remote server by copying …

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 to Create Users in Centos …

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 plpgsql commands below. First, let’s …

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 PostgreSQL 10 to 11” 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 the column was inconvenient. In …

In some cases, sessions are blocked in databases. There are many reasons for blocking. In this article, I will not go into details of this topic. In this article, I …