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

  GTID replication is a simple High Availability solution (HA) offered in MySQL and MariaDB though the implementation technique is unique but compared to MySQL …

  You can use the following command to see the list of tablespaces created. [crayon-673f632163b6d340405261/]   You can also use the following script to list …

  There are countless ways of understanding how long PostgreSQL has been turned on. In this article we will talk about 3 methods.   1)Using …

  Page is the most basic unit of SQL Server on storage. Each page consists of 8 KB. The mdf or ndf files that allocate …

  To trap Ctrl-C in a shell script, we will need to use the trap shell builtin command. When a user sends a Ctrl-C interrupt …

  As you know, at the end of September 2016, PostgreSQL version 9.6 was released. In this article you will find the installation steps of …

Create Extension First, if the extension is not present, it is created with the following command. [crayon-673f6321642fa214464326/] The functions we will use; [crayon-673f6321642fd919035634/] Example: We …

  SQL Server re-creates tempdb on predefined folders each time sql server service starts. In the article “How To Move The Tempdb Database To Another …

  In this article I will share some monitoring scripts about postgresql.   To Check if the Postgresql service is running via OS(linux): [crayon-673f63216462d283059203/]   …

  There are several methods to delete the disk group from an ASM. It is possible to do this operation with “Enterprise Manager”, asmca and …