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

Enabling the archive log mode in the RAC database is slightly different from the normal database. You can enable archive log mode in the rac …

We will create sql server audit step by step in this article. We need to create an Audit file to record transactions made by people …

  You can use the following script to access SQL information in Oracle from a PROCESS ID on the operating system. [crayon-651077726ef91370876548/]   If your …

I wanted to write this article to make it easier for you to choose between SQL Server’s technologies used for HA (High Availability) and DR …

  You can use the following script to collect the enviroment information that are set on the user you are connecting to the database. This …

  Database Snapshot is the creation of an unchangeable image of the database, you can think of it as taking current photo of database. If …

  Snapshot technology is used during the first synchronization in other types of replication. Below you can find more articles about the types of replication. …

  Uuid is the abbreviation for “universal unique identifier”. It consists of 36 characters, a set of numbers and letters, and its most important feature …

  Merge Replication is a technology developed for applications that want to update on the same table through multiple servers. In other words, Publisher and …

We may want to change the schema name because of some needs. For this we can use the following script. First, we list the schemes …