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
How do we transfer server configurations from one SQL Server Instance to another
In the article we will see an easy way to transfer the configuration of one SQL Server instance to another. Parameters such as max memory, max degree of parallelism, cost of threshold for parallelism... All that will be needed... read more
How to force a plan in an Oracle database
In a previous article we saw why a query can run with a different plan and how to force one in SQL Server. In this article we will see how to force a plan in an Oracle database with... read more
SQL Server in the Cloud Era. Time for Azure SQL Databases?
Microsoft in the era of the Cloud with Azure decided to give as many options as possible so that everyone is satisfied. Whether you are fans of on-premise or hybrid cloud. With SQL Server in Virtual Machine services… read more
