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, …

There are several methods for sending mail from linux.  For Example you can send email by using Exchange. To perform this you must grant relay …

In PostgreSQL, you may need to review more than one thing to analyze database or whole cluster when you encounter a problem. For example, a …