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 …
Read More »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 methods to perform this. One …
Read More »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 is because it tries to …
Read More »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 downloaded it in zip format, …
Read More »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 this you must grant relay …
Read More »DBCC SHOW_STATISTICS in SQL Server
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 …
Read More »How To Check Object Privileges Granted to a Role or User in Oracle
To perform various operations on database objects, system and object privileges must be assigned to users. Each system privilege allows a user to perform certain …
Read More »How To Create PostgreSQL Repository To Install Postgres Without Internet
Download Postgres Repository Metadata First, Run the below command on a server that can connect to internet. This command download the latest postgres repository metadata …
Read More »Find UNDO Usage by Sessions
You can find the undo usage of a session with the following query. Historical information is also available. You can find the undo usage of …
Read More »SQL Server Failover Cluster Takes Disk Offline
This is very interesting case. One day we saw that a database is not accessible in a failover cluster due to an offline disk. And …
Read More »