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

  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-65107a4c2c92e562104349/] Help Command: [crayon-65107a4c2c93b269884631/]   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 …

  Cellcli can be used to change e-mail alert settings on cell servers.   To find out the current situation: [crayon-65107a4c2db7a433642076/]   To change: [crayon-65107a4c2db82807851765/] …