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

  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). …

  Teradata Wallet is a facility for storage of sensitive/secret informatio n, such as Teradata Database user passwords. Users save and retrieve items by using the …

  AlwaysOn Basic Availability Groups provide a high availability solution for SQL Server 2016 Standard Edition. This new functionality will replace database mirroring, which is a …

  Hi guys, Today I want to talk about performance issues on MongoDB. As a dba you may informed by users or developers that the …