In this article we will analyze what the Transaction Log is in Microsoft SQL Server, what it is used for and what to watch out for. What is the Transaction Log Every database we create apart from the data files that… read more
How can we get email whenever Tablespace needs Datafile in Oracle database
In Oracle databases tables are stored in logical entities called Tablespaces. Each Tablespace consists of physical files called Datafiles. In Oracle, however, each datafile can have a maximum size of up to 32GB, because of this... read more
How can we perform backups and other Agent jobs in an Always On Availability Group of SQL Server
In this article we will see how to take backups and run jobs on any server that has the Primary role or is a Preferred Backup Replica in an Always On Availability Group of SQL Server. While installing… read more
How do we find what queries are currently running in SQL Server?
Many times we will need to quickly find out what queries are running in an instance of SQL Server. In this article we will see a query that I have written that can directly extract all the information we need. The query retrieves… read more
How to restore a table to a point in time in Oracle Database with RMAN
In this article we will see how in Oracle Database we can restore a table at a specific time. The data to carry out the process comes from RMAN backups and during the process they are temporarily restored automatically to... read more
How do we automate the database backup process in SQL Server without using a maintenance plan
In this article we will see the easiest and most efficient way to backup all instance databases. We will do this using the DatabaseBackup procedure created by Ola Hallengren. Of course… read more
What is Change Data Capture (CDC) and how is it enabled in SQL Server
Change Data Capture known as CDC records that DML (insert, update, delete) action is performed on a table of a database. These changes are recorded in a corresponding table that is created. Through systemic functions we can... read more
How to replicate tables from Oracle Database to SQL Server using GoldenGate
In this article we will see how we can copy table records from Oracle Database that is on Unix to SQL Server that is on Windows using Oracle GoldenGate. What is GoldenGate Oracle GoldenGate… read more
How we enable Oracle Data Guard with automatic failover for High Availability
In a previous article we saw how we activate Oracle Data Guard in physical standby. Now we will take the installation one step further with a modern commit that will allow us to enable automatic failover from primary to standby... read more
