Let's say that every day we would like to send by email a report from the result of a query in a database. This process in SQL Server is done using SQL Server Agent and Database… read more
What is Query Store and how we use it in SQL Server
Query Store appeared from SQL Server 2016 onwards. It is a tool provided so that we can track each query in the database. Through the Query Store we can see a query... read more
How to Flashback an Oracle Database (Flashback Database)
In a previous article we analyzed how to flashback a database to a guarantee restore point in an Oracle database. In this article we will see how to go back in time through flashback database technology without using a restore point... read more
How do we find the size of a database over time in SQL Server?
Very often we will need to make an estimate of the space that a database will need in SQL Server in the future. To do this we need to know the growth rate of the space used by the database. Where… read more
What are triggers?
Do they have overhead? Where is their utility? and finally how are they made? There are 3 different types: DDL triggers for CREATE / DROP actions, AFTER LOGON triggers for when a user logs in, DML triggers for Update, Insert, Delete actions. In the article… read more
How do we find what queries are running in an Oracle database?
Many times the need will arise to quickly look for a session that executes a query. We might want to see the plan it ran with, the memory it consumes, the sql text, the session id, if… read more
How can we bulk backup/restore databases in SQL Server
Many times we may need to backup several small databases and transfer them to another system or restore them to the same one. The backup/restore process of each database one by one will be time-consuming and... read more
How can we run multiple scripts in Oracle in Unix environment
In the article we will see how to easily and quickly create a script that can execute multiple other scripts in an Oracle database in a Unix environment. It even provides the ability to stop in case of an error. Creating the executable… read more
How we create a simple database in Azure SQL Database
In a previous article we saw what an Azure SQL Database is and the differences between SQL managed instances and SQL elastic pools. In the article we will analyze how to create a Simple Azure SQL Database step by step and... read more
