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

We can perform the following operations with ALTER TABLE Statement. Add a column to a table Delete a column from a table Change the data …

In this article, I will mention about moving a subversion repository from one server to another. Actually, it is a backup and restore job by …

In this article, I will mention about SubVersioN (SVN) installation on Oracle Linux Server. SVN is a type of version control system. Basically it allows …

  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 …