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 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
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
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 this article we will see an easy way to transfer the parameters of one SQL Server instance to another. Parameters such as max memory, max degree of parallelism, cost of threshold for parallelism … All you need to do is… 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
