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

  Some logins may want to see queries that requested from the database. They can see these queries from SQL Server  DMWs(Dynamic Management View) and …

  Sometimes when we want to insert rows into a table which contains duplicate keys, then we consider using ‘replace into’ or ‘insert into … …

We will upgrade POSTGRESQL 10 To 11 on CENTOS in this article. Before I start the upgrade process, I want to make the following critical …

  Policy-Based Management is a feature that introduced with SQL Server 2008. It allows us to set the rules we want in our systems, to …

  A materialized view is a database object that contains the results of a query. The FROM clause of the query can name tables, views, …

  With the Log Shipping technology, the backup of the SQL Server Transaction Log file is periodically transferred to another instance and recovered on the …

  In some cases, we may need to know how many percent of the ASM disks are used. The following query shows the percentage of …

  I will use SQL Server 2014 in this article. Other versions can be installed in similar ways. SQL Server Always On Failover Cluster was …

  In Postgresql, sometimes we need a sample database when we test. We can use pagila in postgresql.org for this. You can follow the steps …

In PostgreSQL we have 2 functions to split a string according to a certain character; regexp_split_to_array and regexp_split_to_table. regexp_split_to_array : It splits the string according to regular expression and …