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

  Last night, a customer started to receive error messages about one of the Replica in an AlwaysOn Availability Group configuration. Error messages were related …

When we get a backup with Rman, if there is a damaged block on a datafile, the ORA-19566 error will be received and the backup …

We perform maintenance operations on SQL Server using Maintenance Plan. In this article I will describe the process of running a sql server job. I …

We had a job adding a new node to a Cluster the other day. During this process, I encountered the error you would see in …

  A chained row is called a row that does not fit into a single database block. For example, when you try to add a …

We perform maintenance operations on SQL Server using Maintenance Plan. This article describes how to delete the maintenance plan history. I will share links to …

You can use GRANT, REVOKE, and DENY commands on many database objects in SQL Server. With the GRANT command, you can authorize a user. With …

  ERROR: DCOM was unable to communicate with the computer “server_name.domain_name” using any of the configured protocols; requested by PID     5cac (C:\Windows\system32\ServerManager.exe). Event …

When you are backing up with Data Pump (expdp), it may indicate that the privileges are insufficient and may end with errors such as ORA-39127, …

We perform maintenance operations on SQL Server using Maintenance Plan. In this article I will describe the process of updating statistics. For more detailed information …