Database Tutorials MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux

You may receive this error when there are multiple IPs on the same server that use the same port. In this case, you cannot run …

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 …

With DBCC SHOW_STATISTICS we can get detailed information about a statistic. As many of you know, statistics have one of the most important roles in …