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
Useful VBA routines in Microsoft Excel (Part 1)
We have talked in a previous article about what VBA (Visual Basic for Applications) is and what possibilities it has within Microsoft Excel. In this article we will look at some routines I have written that can be executed by calling the… 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 to record who last modified the record in shared Microsoft Excel
We all know Microsoft Excel as one of the most basic and first programs created for use with a graphical environment on computers. Many times we have a shared Excel file that is being edited by multiple users. Maybe for… read more
How can we schedule automatic tasks in Unix
Unix-based operating systems such as Linux and MacOS have the Cron program installed. Cron allows us to schedule tasks to run automatically over time. Its usefulness stands out in tasks that… 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
Pivoting in Microsoft Excel using Python
In an earlier article we have seen the possibilities to perform Excel functions such as vlookup through Python. In this article we will see how we can perform pivoting through Python. We will analyze ways so that we can find information… read more
