In this article we will see how in Oracle Database we can restore a datafile that has been deleted or has become corrupt while the database remains "open" and continues its operation. The data to carry out the… read more
How do we enable auditing in SQL Server?
In this article we will see the steps and options we have to enable the database auditing specification in SQL Server. Through the database auditing specification we can record who accesses and how... read more
How we set an Azure Storage Account as a Cloud Witness in Windows Failover Cluster Quorum
When we install a Windows Failover Cluster on Windows Server and we want to have automatic failover, we need to define a Witness. Witness's job is to communicate with both sites and in case any… read more
How do we add a database that has TDE Encryption enabled to a SQL Server Always On Availability Group?
In a previous article we have seen that TDE (Transparent Data Encryption) is the encryption of a database at a physical level. That is, it encrypts data files, log files and backups. When a database in SQL Server has enabled… read more
How can we get emails whenever syncing to SQL Server via Oracle GoldenGate is having problem
When we synchronize tables through Oracle GoldenGate, it can either stop the extract of the source from writing trail files to the target in the tables, or stop the replicat of the target from applying the trail files. So for any… read more
How can we get email whenever synchronization between databases is lost in Oracle Data Guard
In this article we will see how we make a mechanism that will inform us by email when some of the standby databases that synchronize with the primary have fallen behind in the sequence number of the logs or because... read more
How to migrate a SQL Server database to Azure using Data Migration Assistant
Many times we will need to migrate databases to a newer version or move them to Azure. In such a transfer there is a possibility that some components are not compatible and need corrections before we start the migration. The tool… read more
How can we export daily data from SQL Server to Excel and email it
In the daily operations of companies it is often necessary to extract daily data from the database and give it to an Excel. In these Excels we usually want to have some specific name along with a date and to… read more
How to improve a previously run query on an Oracle database (SQL Tuning Advisor with AWR Snapshots)
In a previous article we analyzed how to improve a query in Oracle using the SQL Tuning Advisor. But in order to run the SQL Tuning Advisor, the query must still be in the Shared Pool, i.e. in memory... read more
