In this article we will talk about one of the ACID properties of RDBMS and more specifically about the Isolation property. During relational database transactions, many users will try to access the same data… read more
How do we restore a specific page only in SQL Server
In the article we will analyze what we can do in the case of page corruption in SQL Server. It is possible to restore only the specific page and avoid restoring the entire database through the backups we have (just... read more
How do we collect long-running queries via Extended Event and how do we read its data
Many times we will need to find how many and which SQL queries were executed for a long time in a period of time in SQL Server. The easiest solution with the least performance impact is to create an Extended Event. The… read more
How we can easily backup metadata in an Oracle database
Sometimes we need to backup a procedure, a package, a function, etc. (the so-called metadata) so that we can see its code or keep it somewhere so that we can restore it if necessary. In this article we will see… read more
How to write advanced SQL queries
In a previous article we analyzed what SQL (Structured Query Language) is and how it is used with basic examples. In this article we will see its more advanced functions. The code is written with the Transact-SQL extension… read more
What are SQL Joins and how tables are related to each other
Relational databases rely on relationships between their entities (tables and views). However, in order to be able to call associated records from two or more tables / views above, we must somehow declare with which field... read more
How do we backup a database that is in no-archive-log mode in Oracle
In this article we will analyze what it takes to take an offline backup of an Oracle database that is in no-archive-log mode. As the base does not keep the redo logs as an archive, we do not have the option for online... read more
How do we load files (csv, txt) into Oracle database
It is possible to import files like csv and txt into an oracle database table. There are two similar ways. Using SQL*Loader or using External Table. Their mode of operation is similar, but depending on the case, it is more suitable... read more
What is Oracle Data Guard
Data Guard is Oracle's database solution for high availability and disaster recovery. In the article we will analyze how it works and the types it has. In its use we define our production base as primary… read more
