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

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 …

MySQL Workbench Workbench is the MySQL official GUI tool to access the MySQL database engine. The tool is very user friendly and a DBA does …

Sysaux tablespace is an auxiliary tablespace to the SYSTEM tablespace. If SYSAUX tablespace becomes unusable database functionality will remain operational. Occupants of the SYSAUX tablespace …

  Yesterday in one of our mongodb databases developer asked for unshard a sharded collection. Yes it is possible to unshard a sharded collection but …