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 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
How we create a SQL Managed Instance in Azure
One of the possibilities we have in the Azure Cloud is to provide us with an entire Instance of SQL Server without having access to a Virtual Machine. You call this service Azure SQL Managed Instance. What are the advantages of… 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
What are the differences between MDX and DAX queries?
They are both expression languages used for data analysis in Power BI, Excel and Analysis Services. If we would like to answer our question with a sentence, MDX (Multidimensional Expressions) you use to analyze multidimensional… 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
