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

  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 …

The PIVOT , which is indispensable for Excel users, can be implemented with SQL Server 2005 via T-SQL. But I can’t say it’s as talented …

In this article, I will tell you to get the create script of an oracle user. First, we will create a file named user.sql that …

  You can find detailed information about Contained Database in the article “What is Contained Database” We can create a new Contained Database and create …

  When the catupgrd.sql is run during the manual upgrade process, it ends with “ORA-01722: invalid number” error due to the Database Vault configuration in …

  I would like to write this article because it is a topic that some friends who are interested in SQL Server are usually curious …

In some cases, we may need to determine the memory rates used by databases. Because some databases using extra memory may be degrading the performance …

PostgreSQL is a database management system that is bare when it is first installed. Therefore, you should make some configurations according to your system resorce. To …

We can read data from Oracle or MSSQL with the help of PostgreSQL Foreign Data Wrapper. Please read the following articles for installation and detailed …