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

Cell services automatically start when the cell is started. You can follow the following procedures to start and stop manually. “CELLSRV, MS and RS” services …

Being a DBA we have many hands-on experience and knowledge about replication. But replication is quite a bit different in case of Cassandra because it …

        In the recent times i have come across various perople asking why do we need to adopt MongoDB as a database …

  Transaction count shows that how heavily the database is used. Some third-party applications can show the transaction count graphs of the databases. But each …

We can use try-catch blocks in TSQL since SQL Server 2005. In the try block; We write the TSQL code that we want to catch …

  It is possible to reset Rman configurations to default values. You can see “#default” at the end of the unmodified configurations. It is possible …

  Before reading this article, I suggest you read my article “Fixed Server Level Role in SQL Server“. Apart from the default roles on Instance, …

  In the 12c databases, ORA-39014 ORA-39029 ORA-31671 and ORA-00600 errors can be received during expdp or impdp operation. In such a case, existing processes …

  These roles are the default server level roles at the instance level. You can find the brief description about these roles below. sysadmin sysadmins …

  In SQL Server, we can join two tables with JOIN operators. You can read the “Join Types in SQL Server” article. With the CROSS …