In this article we will see a query that I have made so that we can easily find the specs of each SQL Server instance. This query can be run in any version without needing any conversion as... read more
How can we get email whenever an error occurs in SQL Server Error Log
In an instance of SQL Server, potential problems that occur are recorded in a place called the Error Log. However, it would be very useful for us if any important error appeared in the Error Log, SQL Server forwarded it to us... 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
How to do a fresh installation of Oracle Database on Linux
In this article we will see step by step how to install Oracle Database 19c on Unix and more specifically on Oracle Linux / Red Hat. The prerequisites To begin with, we should have a graphical environment either with the… read more
How do we create a Group Managed Service in Active Directory to pick up the SQL Server service without using a password
In SQL Server, we must change the user that "starts" the SQL Server service from the Windows default to someone with specific rights that belongs to the Active Directory Domain. In this article we will see how we can… 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 can we get email whenever we have blocking session in Oracle database
In an Oracle database, every time a session updates the elements of a table, it becomes locked to ensure that no other session will be able to modify the same table at the same time. But when… read more
How we send email through SQL Server
Through Microsoft SQL Server we have the possibility to send emails either for some alerting or so that we can send reports. In this article we will see step by step how it works and how to activate Database Mail... read more
How to Text Search Documents Stored in Database Table in SQL Server Using Full-Text Index
In SQL Server we have the possibility to store files such as docx, xlsx, XML, etc. in table fields. To search for words in these fields, a full table scan would have to be performed, but there is also the solution of creating... read more
