Microsoft in Analysis Services for the creation of Business Intelligence (Data Warehouse) beyond the use of Multidimensional Cubes also provides the Tabular model approach. Tabular models are new, faster to build and easier to use.… read more
How to bulk data into database using Oracle Data Pump (impdp)
Many times we will need to keep the table data and their metadata (packages, procedures, functions, etc.) so that we can then import them into the same or a different system. In a previous article we saw the use of Oracle Data… read more
How to install SQL Server on Linux
In this article we will see how easy it is to install SQL Server 2019 on a machine with a Linux operating system and more specifically on a Red Hat distribution. We will also see how we connect and how we can… read more
The Great Database Battle – SQL Server vs Oracle Database
The two best-known RDBMS (Relational Database Management Systems) with the largest market shares are Microsoft SQL Server and Oracle Database. They have a lot in common but also a lot of differences between them. Let's see in detail: Filegroups: They are… read more
How we collect blocking queries via Extended Event and how we read its data
In an earlier article we saw how we create an Extended Event to see queries with a long duration. In this article we will create an Extended Event that records blockings. All we need to do is create it… read more
How do we backup an Oracle Database that is in archive-log mode
In this article we will analyze what it takes to take an online backup of an Oracle database that is in archived-log mode. In order to take a backup in addition to the datafiles, we should also take a backup of the controlfile,... read more
What are set operators (Union) and how they differ from Joins in SQL
In this article we will analyze the use of set operators, the types that exist and the differences between them and SQL Joins. In the world of SQL (Structured Query Language) many times we will want to combine… read more
How do we find how much more it takes to complete the query and which is delayed (SQL Server Query Profiling)
Many times we will encounter queries that take too long to complete or never complete at all. To find what exactly is at fault the most useful information is the actual execution plan. As the actual execution plan requires the completion of the query, with… read more
How can we see historical image of a table in Oracle Database with Flashback Query
Many times we will need to see what entries the table had some time ago. We may still have to restore it from a wrong update or even drop. In Oracle this is easily done using flashback query… read more
