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

  The concept of normalization was created by Edgar F. Codd, the founder of the relational database model. During the design of the tables, we …

  It is useful to check occasionally whether everything is normal in the Oracle ASM instance. To do this, some information should be collected and …

You may encounter this error when taking a backup to a NFS Mounted disk. You will see the error through SQL Server as follows. Msg …

  Sometimes the standard installation is not sufficient for the extension package you want to install. The reason for this is that the extension has …

  We can see asm files in Oracle ASM disk group without asmcmd. You can run the following query to view files and sizes in …

  In some cases, you may need to connect to the sql server via SSMS with a different domain account(for windows authentication). You connect to …

  The status of the Exadata cellnode flash disks may occasionally be poor performance. If the error numbers are 0 (zero) or too low when …

  Policy-Based Management is a feature that introduced with SQL Server 2008. It allows us to set the rules we want in our systems, to …

  When opening the database, if there is a redolog group that is not enabled for the corresponding thread, it gives an error as ORA-01618. …

  You have defined a share on a remote server, and you cannot authorize the SQL Server service account on that share. You just have …