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

  In this article, I will share linux scripts with you for staring database automatically when operating system is started. My environment is: Oracle 11.2.0.4 …

  In this article, I will show you hot to solve “Error in invoking target ‘agent nmhs of makefile ins_emagent.mk”  while you try to install …

  In this article, I will talk about how SQL Server writes data to storage and reads data from storage. I will also explain how …

  Before reading this article, I suggest you read my article “SQL Server Always ON Availability Group” to understand the operation logic of the Availability …

  After ASM disk operations, rebalance operation may end with ORA-15041 error. This error means there is not free space. When we check the ASM …

  When choosing a RAID structure or designing storage, I strongly recommend that you do not stay away. These processes directly affect database performance. The …

  In the article “Postgresql Foreign Data Wrapper“, we created Foreign Data Wrapper to read data between two PostgreSQLs. And we have created Foreing Data …

  When temp tablespace grows uncontrollably, it may be necessary to reduce its size. For this, the temp tablespace needs to be recreated in a …

  In this article, we will examine several ways to determine if SQL Server Memory is sufficient. SQL Server tries to use all memory on …

  Restore Point is used to create a return point when flashback is active in Oracle 11g and above databases. While the flashback feature of …