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
Usamos cookies propias y de terceros para que podamos mejorar su navegación. Si continua navegando consideramos que acepta el uso de cookies. AceptarMás información
Privacy & Cookies Policy
Necessary cookies are absolutely essential for the website to function properly. This category only includes cookies that ensures basic functionalities and security features of the website. These cookies do not store any personal information.
Any cookies that may not be particularly necessary for the website to function and is used specifically to collect user personal data via analytics, ads, other embedded contents are termed as non-necessary cookies. It is mandatory to procure user consent prior to running these cookies on your website.