Database Tutorials MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux 
The ARBn background process starts the rebalance process automatically when you delete or insert a disk from the ASM disk groups. This process is …
Read More »
dbtut
SSPI handshake failed with error code 0x8009030c and The login is from an untrusted domain and cannot be used with Windows authentication
If your computer is not connected to the domain, you can get this error when you try to connect to a SQL Server in …
Read More »Normalization Concept
The concept of normalization was created by Edgar F. Codd, the founder of the relational database model. During the design of the tables, we …
Read More »How To Check Oracle ASM Instance
It is useful to check occasionally whether everything is normal in the Oracle ASM instance. To do this, some information should be collected and …
Read More » The operating system returned the error ’59(An unexpected network error occurred.)’ while attempting ‘FlushFileBuffers’ on ‘myDB.BAK’
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 …
Read More »How To List Files and Sizes within an ASM Disk Group
We can see asm files in Oracle ASM disk group without asmcmd. You can run the following query to view files and sizes in …
Read More »How To Connect SQL Server via SSMS(SQL Server Managemet Studio) With Different Domain Account
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 …
Read More »Poor Performance Status on Exadata Cellnode Flash Disks
The status of the Exadata cellnode flash disks may occasionally be poor performance. If the error numbers are 0 (zero) or too low when …
Read More »Policy-Based Management(Special Character Control in Database Names-Database Facet)
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 …
Read More »ORA-01618: redo thread 2 is not enabled – cannot mount
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. …
Read More »