Delayed Durability is a feature that introduced with SQL Server 2014. It is a feature that flexs Durability, a common feature of advanced relational databases. …
Read More »dbtut
Real-Time SQL Monitoring with /*+MONITOR*/ Hint in Oracle
As of Oracle 11g R1, long-running queries or queries that we run with the / * MONITOR * / hint are automatically monitored. During the …
Read More »How To Restore a Backup From URL(Backup On Azure Storage)
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 …
Read More »How To Backup SQL Server Database to URL
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 …
Read More »How To Change Enterprise Manager Database Express Port in 12c
You can also change the port of Enterprise Manager Database Express 12c after installation. You can find the current port as follows. [crayon-67408a79c2e41451196519/] You can …
Read More »OFFSET and FETCH in SQL Server
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 …
Read More »Grant Read-Only Access To Enterprise Manager Database Express 12c
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 …
Read More »SQL Server Architecture
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 …
Read More »opidrv aborting process J00n ospid (nnnnn) as a result of ORA-1013
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 …
Read More »SQL Server ACID Rules
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 …
Read More »