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

  For disk errors such as ORA-700 or ORA-600 on the cell server, first check whether there is a physical fault. If there is a …

  Most DBA usually define the SQL Server Service Account as the Administrator on the server. Actually, this authority is not necessary. You must not …

  There are many ways to setup the RMAN. Here i am using the separete database to store backup catalog information with windows Server 2008 …

  Numeric data type SAP IQ – supports up to (126, 38) MySQL/memSQL – support up to 65 digits; https://docs.memsql.com/sql-reference/v6.5/datatypes/ ISNULL vs IFNULL SAP IQ …

  Percona XtraDB Cluster is a active/active database clustering solution for MySQL. It ensures high availability, prevents downtime and data loss, and provides linear scalability …

  In this article we have examined many of CellCLI commands. CellCLI  — Cell Command Line Interpreter (Exadata) [crayon-66432256d2cfc964743823/] Help Command: [crayon-66432256d2d03460607842/]   Commands for obtaining …

  Sometimes we need to change Collation after we have done SQL Server Installation. I will do my warning from the beginning. After changing Collation, …

  Guarantee security on Data is a key element and auditing is one of them. FGA provides a flexible way to achive this goal. With …

  To create Availability Group(AG) Fail-over SQL Server Cluster with secondary replica we need 4 machines/VMs which are as follows Domain Controller: Machine Name: DC 192.168.1.71 …

  The File Table uses the technology of File Stream. It keeps file system data as a table. That is, you can access the data …