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
Author: Faruk Erdem
Send Email When the Blocked Session Count Exceeds a Certain Number in SQL Server
In some cases, sessions are blocked in databases. There are many reasons for blocking. In this article, I will not
SQL Server Database Mail History Cleanup and Prevent msdb Database From Growing
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
Upgrade SQL Server
First of all, upgrade is an important task. Before upgrading, you must check your database is ready to upgrade with
Cannot connect to WMI provider. You do not have permission or the server is unreachable. Note that you can only manage SQL Server 2005 and later servers with SQL Server Configuration Manager. Invalid class [0x80041010]
You may receive this error if you want to make a change in SQL Server Configuration Manager. Depending on the
How To Create a Linked Server To Connect To PostgreSQL From SQL Server
You may want to transfer data to MSSQL from PostgreSQL or send query to PostgreSQL from MSSQL. There are different
Error in certificate: Peer’s certificate issuer has been marked as not trusted by the.
If you receive this error while sending mail, but you can send the mail, the reason you receive this error
How To Install Check_postgres On Centos(Monitoring Tool)
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
How To Send Email From Linux
There are several methods for sending mail from linux. For Example you can send email by using Exchange. To perform
PostgreSQL AWR
In PostgreSQL, you may need to review more than one thing to analyze database or whole cluster when you encounter