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 access SQL information in Oracle from a PROCESS ID on the operating system. [crayon-6741de0381d5c578013523/]   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 …

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 …