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

        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 …

  The “alter system flush redo” command, which is used to transfer operations in the redo log files in the primary database to the standby …

  Resource Governor announced with SQL Server 2008. We are able to limit resources of a session using Resource Governor. For example, a report user …