SQL ServerHow to enable the slow query log in SQL Server?
How to capture slow queries in SQL Server? If you come from the MySQL, PostgreSQL or even Oracle world, you…
DatabasesWhat is a database?
Introduction to databases: the heart of the digital era
OracleHow to install Oracle Database 19c on Oracle Linux
Oracle Database 19c on Oracle Linux 7.9 in silent mode To install Oracle Database 19c, the operating system must be…
PostgreSQLUnderstanding the execution plan in PostgreSQL: how to improve the performance of your SQL queries, part 2
Continuing with part 2 of our article on execution plans, we will look at how to analyze and interpret an…
OracleUnderstanding the execution plan in Oracle: how to improve your SQL query performance (part 1)
The power of SQL and the performance challenge One of the great advantages of SQL is its declarative nature. That…
OCIHow to upload a SQL Server backup to an OCI bucket.
Backup safety is one of the main pillars of database administration. Keeping an external copy guarantees data recovery in case…
![[SCRIPT] – showplan.sql](https://furushima.com.br/wp-content/uploads/2025/01/SQL.png)
Oracle[SCRIPT] – showplan.sql
How do you know which part of the plan your query is spending the most time on?
OracleRunning Datapump Export (expdp) on Oracle RDS
\n \n\n\n\n In this tutorial, we will explore how to perform a data export using Datapump Export via the DBMS_DATAPUMP…
SQL ServerEnabling encryption for a SQL Server database (TDE)
We recently had a request driven by LGPD, where we had to enable encryption at the database layer on a…