In a previous article we saw how to patch an Oracle database. In this article we will see the same process in an Oracle Data Guard environment on a UNIX operating system. The steps we will follow allow us to… read more
How can we from SQL Server read Excel / CSV / TXT and insert the records into a table
SQL Server allows us to read and import files at will without the use of SSIS (Integration Services) and Wizard packages. This process is done using the OPENROWSET function and the BULK INSERT. We can… read more
How can we see what CPU Usage we had per minute in SQL Server
SQL Server during its installation creates a lightweight Extended Event with a size of up to 5mb in which it records performance information. This Extended Event is called system_health and in this article we will see how we can with… read more
How to manually set up SSH communication between Unix Servers for Oracle Grid Infrastructure and RAC
In this article we will see what to do if during the installation of Oracle Grid Infrastructure on Unix we get an error when we try to Setup SSH connectivity. When we select in the tab below SSH connectivity and Setup for… read more
How to save space from old table partitions in an Oracle database
When we have very large tables, using Table Partitions helps a lot. Table Partition divides the table into smaller pieces depending on the field we have defined as a criterion, e.g. “date of entry”, these tracks can be located either… read more
How can we find when a database was last used in SQL Server
In the article we will see an easy and quick way to see which databases are in use and which users are currently connected to them. To see when a database was last accessed in... read more
How to transfer bulk datafiles online to Oracle database
In this article we will see a script with which we can transfer mass datafiles online that we may have created in the wrong location or we want to change their storage in an Oracle database. THE… read more
How can we run multiple SQL Scripts in SQL Server from within Windows with batch script
In this article we will see an easy way to be able to run SQL Scripts en masse in SQL Server with batch script and keep the results for each separately in CSV. The example Suppose we have… read more
How to replicate tables from SQL Server to Oracle Database using GoldenGate
In a previous article we saw how we can replicate tables from Oracle Database to SQL Server using GoldenGate. In this article we will see how we can do the reverse from SQL Server to… read more
