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

Error: When the database is upgraded to version 10.2.0.4 or 10.2.0.5, the Enterprise Manager configuration ends with an error and fails to start manually. Reason: …

  For Always on Perrequisite Refer Document Prerequisite For AlwaysOn Basic Availability Groups in SQL Server 2016 in Standard Edition OR SQL Server Mirroring in …

  We explained how to get the create script of all objects belonging to the database in the article titled “How To Get Script of …

  I mentioned that we can not get the script of the partitioned tables by right clicking on the SSMS and using the Script To …

CCQL: CCQL is a tool that allow user to connect multiple mysql server node Concurrently at the same time. It comes into picture when a …

Replica set configuration on ‘n’ node Replica: We generally have 3 nodes replica set with 1 Primary and 2 secondaries. Below are the steps we will need to …

Important Note : Following features are deprecated in 3.6 ‘rest = true’ and ‘httpinterface = true’ these options need to be commented in mongod.conf . …

Error: When connecting to rman, “PLS-00201: identifier ‘DBMS_BACKUP_RESTORE.SET_CHARSET’ must be declared” error and connection could not be established. Reason: Problematic DBMS_BACKUP_RESTORE package or invalid sys …

  Partition is the process of dividing tables and indexes into parts. For example, I have a table with a size of 1 TB. And …

  Teradata architecture is based on Massively Parallel Processing (MPP) architecture. The major components of Teradata are Parsing Engine, BYNET and Access Module Processors (AMPs). …