In a previous article we saw what indexes are. In this article we will see how to find the status of their hash, if you are using, when they were created, when they were updated and if they are missing indexes recommended by SQL Server.… read more
How to install an Oracle Real Application Cluster (RAC) on Linux using Direct NFS
In this article we will see step by step how to install an Oracle Database belonging to a Real Application Cluster (RAC) on a Linux operating system (Oracle Linux 7.7) with shared NFS disks without using Oracle ASM (Automatic Storage... read more
How to enable Oracle Direct NFS for increased performance between Oracle Database and NFS Shares
In this article we will see how to enable Direct NFS for Oracle Database connectivity with NFS Servers. When we enable it the communication between Oracle Database and NFS Servers is done directly, without involving the kernel of… read more
What is Oracle Real Application Cluster (RAC)
In this article we will see a detailed description of what Oracle RAC (Real Application Cluster) is, what features it provides and how it works. Oracle RAC is a software that allows us to connect multiple servers (up to… read more
Why is restarting the SQL Server instance delayed?
In this article we will look in detail at some of the most common reasons why a SQL Server instance may be slow to restart and what we can do to improve this time on a case-by-case basis. Using a very large… read more
What is the Transaction Log and what is it used for in SQL Server
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
