SQL Server

In our day to day as DBA we must create indexes to improve the performance of the queries launched against the production tables. A necessary tool would be to know what percentage of creation our index has. In many cases, we do not have an Read More

Continuing with the post of my colleague Fran Lens’ about Instance Pools, today I am going to teach you Step by Step how to create Instance Pool in Azure using Powershell. Next, I show you the steps to follow to carry out this process: 1. Creation of a Valid Virtual Read More

For more than a year we have been working and migrating clients to Managed Instance in Azure, that’s why when last September 4, 2019 Microsoft made the news of a new option for this, called Instance Pools, we wrote it to the list ” We have to prove Read More

Hello again! This post is the continuation of Learning to deploy Kubernetes in Azure (1/2) in which we deploy the necessary resources to use Kubernetes in Azure, if you have not seen this entry which I encourage anybody to read it. In this post we will learn Read More

Today, we are back with another post related to the Microsoft Azure Cloud platform, this time we are going to talk about a new service, a service that will mark a before and after in the migrations from SQL Server to Azure, we will talk about Managed Read More

Today we are going to talk about the last Saturday, September 28th, 2019, we celebrated the SQLSATURDAY MADRID 2019. This year we had to move, we no longer fit in Microsoft offices in Madrid and we found the best place we could think of, the Higher Read More

In today’s post, we will talk about the structure of the Columnstore indexes, as well as the way in which it works internally to facilitate its understanding. 1.- Columnstore. Let’s refresh the definition of column store. Column store indexes are the standard for storing and querying big sized fact tables. Read More