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

In Azure, you can create a virtual machine to manage SQL Server databases. In this article, I will explain how to create this virtual machine …

You may see this error in the database alert log file during upgrade from 11.2 to 12.2. [crayon-68bb759c0eb56635523288/] The reason for this error is that …

What is Stretch Database? If you want to archive your old data to Azure, all you need is StretchDatabase. You can then query as you …

When running Database Configuration Assistant (dbca) on Exadata compute nodes, you will receive this error if all nodes cannot connect to each other without password …

What is PolyBase? This article contains information about PolyBase in sql server. Use cases, installation steps,configuring polybase cluster. With PolyBase; We can bridge between SQL …

Enable Unified Auditing Relink is required to enable the new audit mechanism announced with Oracle database 12c (12.1). You can do this as follows. First, …

Tempdb is a very important system database for heavily used systems. If it is not configured correctly, it can cause serious performance problems in the …

Because the segment space management of the tablespace of the AUD$ and FGA_LOG$ tables is not automatic, a “gc buffer busy acquire” wait event can …

With SQL Server 2016, we are now able to use parallelism in the query using INSERT INTO… SELECT with WITH (TABLOCK). In order for the …

The AUD$ and FGA_LOG$ tables used for audit recordings are in the SYSTEM tablespace by default. SYSTEM tablespace is a tablespace with manual segment space …