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

  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 …

You may get an error as follows when you want to change and save a column type or size in a table in the database. …

One of the useful data types of PostgreSQL is the inet data type. inet is used to define IPv4 and IPv6 addresses. The ip address …

The Oracle Database produces reports that are called AWR at specific periods and that share the general status of the database. You can use the …

It uses the technology of Transactional Replication. As a difference, every subscriber is also publisher. You can read my article “Transactional Replication On SQL Server“. …