In a previous article we saw the installation of SQL Server 2019 on Red Hat Enterprise Linux. In this article we will see how to install SQL Server 2017 again on RHEL but with only 1 core and 1GB Ram... read more
What is Dynamic Data Masking and how do we enable it in SQL Server
In this article we will analyze what Dynamic Data Masking is and what options we have for using it in SQL Server. Dynamic Data Masking is a function whose purpose is to hide the sensitive… read more
How to improve the performance of a query running on an Oracle database (SQL Tuning Advisor)
Many times we will hear that suddenly a query that was running fast suddenly started to run slow or that a query is running very slowly for no reason. The easiest way to find out what is wrong and solve it is with… read more
How can we schedule a Job in Azure SQL Database using Logic App
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 to online migrate an instance from on-premise to Azure Managed Instance in the Cloud (Azure Database Migration Service)
In this article we will analyze how we can do online migration of a SQL Server Instance from on-premise to Azure Managed Instance. To be able to do it online, with near zero downtime, we will use Azure Database... 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
