How To Run Single Command on Multiple Linux Servers
If you have more than one server you manage and if you connect to multiple servers with ssh and run
Author: Faruk Erdem
How To Create Ssh Key and Connect Another Machine by Copying SSH Key
If you are using Linux and want to securely connect to servers without using a username password, you can create
How To Grant root Privileges to a User in Centos
In this article, we will see how to create a user in Centos and how to grant root privileges to
Revoke Permission in PostgreSQL
This article contains information about revoke command usage in PostgreSQL. You may want to revoke permissions of users. In this
Upgrade PostgreSQL 11 to 12
In this article, we will upgrade PostgreSQL 11 to 12. If you want to upgrade PostgreSQL 10 to 11 you
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
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