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

  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 …

  There can be different scenario’s where Teradata database needs to be stopped and started by database administrator or the database restarted automatically. So there …

  In this article, I will show you how to recreate oracle central inventory in Real Application Clusters. This is not an usual routine work …

  Hello Folks, Today I’ll be writing an article on how to do schema comparison of MySQL database between 2 servers(For eg. : PROD and …

  In Postgresql, we can capture the record with the trigger, encrypt and write to the table. Let’s create the table, [crayon-67429bd6486e0349155363/]   Then we …

  In this article I will tell you how to add the MS DTC service to the windows cluster. First, we open Disk Management. You …

  In this article, we will examine the settings that should be done on a Numa Node system. You must make these settings on systems …

  Greetings, In this paper, I will describe the Replication structure and installation stages of the HANA Database, which is the HA (High Availability) feature. …

  MySQL Enterprise Monitor is a tool that register several MySQL Instances and provide complete details i.e. performance graphs and other details for analysis, Costly …