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 …

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 …

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 …

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 …

If you are using SQL Server Database Mail, your msdb database can grow undesirably. We can use the msdb.dbo.sysmail_delete_mailitems_sp procedure to clear Database Mail History. …

First of all, upgrade is an important task. Before upgrading, you must check your database is ready to upgrade with the help of Database Migration …

You may receive this error if you want to make a change in SQL Server Configuration Manager. Depending on the version of SQL Server you …

You may want to transfer data to MSSQL from PostgreSQL or send query to PostgreSQL from MSSQL. There are different methods to perform this. One …

If you receive this error while sending mail, but you can send the mail, the reason you receive this error is because it tries to …

Check_postgres is a tool you can use to monitor PostgreSQL. You can download from the link below. https://github.com/bucardo/check_postgres If you downloaded it in zip format, …