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

  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-684bd9d10d8d7686888375/] The functions we will use; [crayon-684bd9d10d8db767823610/] 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-684bd9d10e322707189127/]   …

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

  Previously i just shared the full backup script. Now we will take incremental backups using last_checkpoints. Basically, what this script will do is that …

  Below is the simple script for taking non-blocking Mysql physical backup using percona xtrabackup toolkit. This backup is encrypted using AES256 algorithm. [crayon-684bd9d1104c5591630941/]   –extra-lsndir:  save …