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
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
Useful commands to manage Oracle Grid Infrastructure / RAC (crsctl / srvctl)
In this article we will see some useful commands to manage databases installed on Oracle Grid Infrastructure. We manage Oracle Cluster Resources (CRS) through the CRSCTL tool and Oracle Database , Listener and… read more
How do we limit the resources that a user can consume in SQL Server
Many times a user in the database can consume all the resources that the SQL Server instance has and no other work can be done by another user. In this article we will see how we can… read more
A disk is full of SQL Server datafiles, what should I do?
Sometimes a disk will suddenly become full. On this disk we may have one base or many, while we may have space on another disk, we must somehow find which datafiles are full. In this… read more
