In this article we will analyze what Dynamic Data Masking is and what options we have for using it in SQL Server. Dynamic Data Masking is a function whose purpose is to hide the sensitive… read more
How to improve the performance of a query running on an Oracle database (SQL Tuning Advisor)
Many times we will hear that suddenly a query that was running fast suddenly started to run slow or that a query is running very slowly for no reason. The easiest way to find out what is wrong and solve it is with… read more
How do we find which sessions are active and which queries they are executing in an Oracle database
Many times the need will arise to quickly look for a session that executes a query. We might want to see the plan it ran with, the memory it consumes, the sql text, the session id, if… read more
How we create a SQL Managed Instance in Azure
One of the possibilities we have in the Azure Cloud is to provide us with an entire Instance of SQL Server without having access to a Virtual Machine. You call this service Azure SQL Managed Instance. What are the advantages of… read more
How can we bulk backup/restore databases in SQL Server
Many times we may need to backup several small databases and transfer them to another system or restore them to the same one. The backup/restore process of each database one by one will be time-consuming and... read more
How can we run multiple scripts in Oracle in Unix environment
In the article we will see how to easily and quickly create a script that can execute multiple other scripts in an Oracle database in a Unix environment. It even provides the ability to stop in case of an error. Creating the executable… read more
How we create a simple database in Azure SQL Database
In a previous article we saw what an Azure SQL Database is and the differences between SQL managed instances and SQL elastic pools. In the article we will analyze how to create a Simple Azure SQL Database step by step and... read more
How do we transfer server configurations from one SQL Server Instance to another
In the article we will see an easy way to transfer the configuration of one SQL Server instance to another. Parameters such as max memory, max degree of parallelism, cost of threshold for parallelism... All that will be needed... 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
