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

  To move the MSDTC disk to another storage, we need to remove MSDTC from the cluster and then re-add to the cluster. To remove …

We have mentioned the LEAD and LAG functions announced with SQL Server 2012. In this article, we will examine the FIRST_VALUE function. Now let’s look …

As a consultant and training provider in business intelligence projects on SQL Server, some analytic functions I expected to be announced for a long time …

  Hybrid Columnar Compression (HCC) introduced with Oracle Database 11g Release 2. HCC is a feature that can be used with Exadata storage, Pillar Axiom …

  First, you should request two 5 GB disks from new storage. These 2 disks must be visible to all servers included in the windows …

  We find the minimum value in a column in a dataset, with the MIN Function and we find the maximum value  in a column …

We can display the cause of an error that we received and troubleshooting suggestions, with the OERR Utility. It is located under the $ORACLE_HOME/bin directory. …

In this article I will show you how to validate windows cluster configuration step by step with screen shots. You can perform validate configuration to …

  The COUNT_BIG function performs the same function as the COUNT function. The only difference is that the COUNT_BIG function returns the BIGINT value while …

  The database instances can be closed with an “ASMB terminating” error due to a bug. The error codes are ORA-15064 and ORA-03113. Possible errors …