In the bygone era of database management, sluggish SQL queries often led to suspicions directed at indexes. Manual creation, deletion, and rebuilding of indexes were labor-intensive tasks, even with the assistance of scripts. However, these generic index treatments applied to Read more…
Recently, I was talking to the IT infrastructure manager of a magnificent industry in the western region of Paraná. When we were talking about databases, I asked if the database was in the cloud. Demonstrating a concern for greater flexibility, Read more…
Recently, I found myself confronted with the challenge of presenting detailed information about receivable invoices from a company. A crucial requirement was displaying the salesperson and department linked to the original sale. However, the complexity arose from multiple invoices grouping Read more…
In a world overflowing with data, Data Mining projects stand out as an essential tool to uncover valuable insights. One of the most fascinating aspects of these projects is the need to go beyond the obvious, aiming to extract knowledge Read more…
Introduction: Recently, I found myself tasked with analyzing an application that was causing an excessive number of redundant records to be stored in the database. The issue stemmed from the fact that certain pieces of information, which ideally should have Read more…
Are you looking to integrate Google Sheets into your application? Google Sheets API provides a powerful way to interact with your spreadsheets programmatically. In this blog post, we will walk you through the process of authenticating and accessing the Google Read more…
Introduction In today’s data-driven business landscape, the efficient handling of data is critical for making informed decisions and shaping effective strategies. However, managing data from various sources can be a time-consuming and error-prone process. In this blog post, we will Read more…
In recent database management tasks, I encountered the need to extract an “attendant” ID from a JSON document stored in a CLOB column within the table df_nsf_mov_det. This information was crucial for storing the value in another table. The challenge Read more…
Hello! I’m Dênio, a professional with over 15 years of experience in IT and a bachelor’s degree in Economics, which enriches my knowledge in Data Science. Since 2006, I’ve been working in data-related roles, honing my expertise in data analysis, Read more…