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

  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-66a46230b2ed6692775239/] Help Command: [crayon-66a46230b2ede151860407/]   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-66a46230b4995206262856/]   To change: [crayon-66a46230b499c886929823/] …

  Full-text Search used to search for columns with large text, such as varchar (max). You can do the same with LIKE, but LIKE will …

ERROR: When a query is executed, an error “ORA-04030: out of process memory when trying to allocate nn kilobytes” is being received. SOLUTION: Decrease pga …

  The File Stream structure keeps the BLOB objects (document, image, video, etc.) integrated with the database on the NTFS File system on the server. …