From time to time we have to check the integrity of our bases for any corruptions. In this article we will see the easiest and most efficient way to check for corruption in all instance databases. This… read more
How do we apply a patch in an Oracle Data Guard environment (even online)
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 we check the integrity of databases and how we fix any corruption in SQL Server
In a database there is always the possibility of corruption. This can be either physical e.g. from some disk damage or either logical e.g. wrong values in a table field. In the article we will see how… 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 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
How do we install Oracle Data Guard as a Physical Standby for Disaster Recovery?
In this article we will see step by step how to install Oracle Data Guard as Physical Standby on Unix. By using it, we have the possibility that changes made on the primary base are automatically transferred to another standby... read more
How to setup a SQL Server Always On Availability Group for High Availability
Microsoft provides us with the ability to Replicate our databases as a Group on up to eight Secondary Nodes (servers) as a solution for High Availability, Disaster Recovery or even for reading without the Primary Node being occupied. THE… read more
What is Always On Availability Group
The Always On Availability Group is the feature provided by Microsoft in SQL Server to Replicate our bases on up to eight Secondary Nodes (servers) as a solution for High Availability, Disaster Recovery and for reading... read more
How do we restore a specific page only in SQL Server
In the article we will analyze what we can do in the case of page corruption in SQL Server. It is possible to restore only the specific page and avoid restoring the entire database through the backups we have (just... read more
