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 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
How to force a plan in an Oracle database
In a previous article we saw why a query can run with a different plan and how to force one in SQL Server. In this article we will see how to force a plan in an Oracle database with... read more
SQL Server in the Cloud Era. Time for Azure SQL Databases?
Microsoft in the era of the Cloud with Azure decided to give as many options as possible so that everyone is satisfied. Whether you are fans of on-premise or hybrid cloud. With SQL Server in Virtual Machine services… 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
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
