Since 2018, when the European GDPR (data protection) legislation began in Europe, all companies started looking for solutions on how to implement the data protection policy immediately with as little impact as possible. There it comes… read more
What are isolation levels and how can they affect a transaction
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
What is a Data Warehouse?
In this article we will analyze what Data Warehouse is, what it consists of and what is its usefulness. In the age of IT, managing the ever-increasing data is becoming more and more difficult. We want to leverage the data… read more
