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

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 …

  Before restoring database dumps to new servers we need to install MongoDB on each system. Step 1: Installation: [crayon-673f373bbdf69509168293/]   inside it: [crayon-673f373bbdf6d016294299/] [crayon-673f373bbdf6f003499829/] …

  In sharded replicas before backup process you need to disable balancer and when backup finishes you need to enable the balancer. This process doesn’t …

  In MongoDB we can take backups with database dumps or filesystem snapshots. In large databases it is recommended to use file system snapshots rather …

  You can login to a remote Linux server without entering password in 3 simple steps using ssky-keygen and ssh-copy-id as explained in this article. …

This article contains information about mysql safe mode such as start mysql in safe mode, find mysqld_safe location, changing password. MySQL Safe Mode Sometime you …

  1.Check error log to find the tempdb full. 2.Find out the space free in tempdb using [crayon-673f373bbf403564552377/] 3.dum tran with truncate only if still …

  In this article I will explain some information about SQL Server System databases. System databases are created automatically when you install SQL Server. The …

  What is Teradata: Teradata is a relational database management system (RDBMS) that is: an open system, running on a UNIX MP-RAS or Windows server platform. capable of …