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

As of Oracle 11g R1, long-running queries or queries that we run with the / * MONITOR * / hint are automatically monitored. During the …

In this article, I will explain how to restore a backup on Azure Storage to a local sql instance. Before you read this article, you …

With SQL Server 2014, we are able to back up a database to a URL via SSMS. In fact, this feature came with SQL Server …

You can also change the port of Enterprise Manager Database Express 12c after installation. You can find the current port as follows. [crayon-6769a51fbea05136649127/] You can …

If you do not want to send the entire query result to the client, you can use OFFSET and FETCH in SQL Server to specify …

Oracle Enterprise Manager Database Express, or EM Express, is a web-based tool used to manage Oracle 12c databases. In order to ensure that the user …

In this article I will describe SQL Server Architecture. In the article, I will proceed through the following image that I received from wikipedia. And …

In Oracle 12.2 databases, this error is written in the alertSID.log file when the default maintenance job is timeout and the corresponding job is automatically …

ACID is the four main rules that relational database management systems (RDBMS) must provide. For more detailed information about relational databases and SQL Server, you …

What groups selected during Oracle binary installation may not be remembered after installation. Or it may be necessary to determine which groups are selected for …