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 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
What do I do when Oracle Grid Cluster Services (CRS) won't start as system file permissions have been lost
In this article we will see what to do when one of the Oracle Cluster servers/nodes shows an error and the Cluster Services (CRS) do not start. The symptom When we go to start Cluster Services (CRS): It shows us the… 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 get emails whenever we have high CPU Usage in SQL Server
In this article we will see a script that creates a SQL Server Agent Job that will notify us by email whenever the CPU exceeds a threshold. It derives the information not from performance counters of the operating system but... read more
