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

  Some time we are facing issue like we forgot the MySQL root password. So here we are providing just some simple steps to reset …

  SQL Server implements different types of locks that determine how concurrent query requests access the data. For example, imagine that one user wants to …

Problem: If a disk previously included in an ASM disk group is attempted to be used for another disk group, it will fail with the …

  Adding Space to Sybase IQ server Little background about IQ space. In IQ 15.0 Dbspace != dbfile Under one dbspace we can have many dbfiles …

  Master-Master Replication setup Replication makes data highly available for applications and websites, master-master replication is an active-active cluster kind of solution which can be …

  The PAGELATCH_EX and PAGELATCH_SH wait types are errors that occur when writing to the same page in memory at the same time. These errors …

  If you are beginner then this post will help you to monitor the mysql server. Here I am listing some most commonly used MySQL …

  We can use Backup Restore for many operations. Below you can find the most common reasons for using it. 1. To get a regular …

Error: When creating an Oracle database in Windows operating system: ORA-12546 TNS: permission denied ORA-12560 TNS protocol adpater error ORA-516 Permission denied From SQL * …

  Single Node Architecture: when we talk about Sybase IQ architecture , We should explain about the Three important IQ stores and three main files. which …