In a previous article we saw how to backup an Oracle database with RMAN, in this article we will see a simple case of recovering data with RMAN Restore. There are many subcases with different steps each… read more
How can we connect SQL Server to another SQL Server using Linked Server?
SQL Server allows us to connect to and execute queries on remote Database Instances that do not necessarily have to be in the same RDBMS. In this article we will see specifically how it is done from an instance of SQL… read more
How to free up reserved space from datafiles / tempfiles of an Oracle database
In this article we will see a script with which we can easily free up space from datafiles and tempfiles where it is not used in Oracle databases. More specifically, we will reduce the size of the datafiles so that… read more
How to convert a database from Physical Standby to Logical Standby in Oracle Data Guard
In another article we have seen how to install Oracle Data Guard, how to create a database as Physical Standby and how to create a Snapshot Standby. In this article we will see how to convert a database that is physical… read more
How to roll back an Oracle Database using a restore point in a Data Guard environment
In a previous article we saw how we can roll back an Oracle Database through flashback database to guaranteed restore point. In this article we will see what procedure we follow in case we have primary and standby databases… read more
How can we increase performance on Oracle GoldenGate Replicat target with parallelism?
If we choose to do the Initial Load before synchronization via GoldenGate Replicat or simply Replicat has a large volume of data to synchronize, one Replicat thread is not enough. In this article we will see two ways to… read more
How to create users in databases that belong to a SQL Server Always On Availability Group
When we create new users in databases that belong to an Always On Availability Group in SQL Server, we want them to work even if they failover to a Secondary node, but when we create a new login in a SQL… read more
How to create a Logon Trigger to control which users are allowed to connect to an Oracle Database
Many times, for security reasons, we may want specific users to connect only from specific machines - servers, and in the event that a connection comes from a different machine, not allow access but display a rejection message.… read more
How do we collect the actual execution plan from queries using Extended Event and how do we read its data
In an earlier article we saw how we activate the Query Store to monitor the performance of the queries and the plan they ran. But as we said, the Query Store has quite a performance impact, so we may want some lightweight profiling. In this... read more
