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

In today’s post I will explain how to prepare our Azure subscription to deploy the Kubernetes service. Follow the simple steps below: 1. First of all we will need the VMSSPREVIEW service to use node scaling in AKS. This way we will open the command line to register the service in our Read More

In today’s post, we are going to present the sixth edition in Madrid of one of the best known data events worldwide: SQL Saturday. SQL Saturday is a free training event for professionals who use the Microsoft data platform. These community events offer the opportunity to find out first-hand the Read More

In today’s post, we’re going to end up with the DimDate series in Power BI. To begin, I will show you some of the visualizations that Power Bi offers by default as well as the personalized visualizations that we can find in the Marketplace. 1.Slicer These are the types of Slicer that Power Bi Read More

We finished with the GDPR series, our personal data will be more secure than ever, but it is not enough to do the work once, this work has to be constant and that is why in this last entry we will see how to Monitor and Read More

At Aleson ITC we are fans of Game of Thrones, that’s why we wanted to make our particular tribute to the series, although after watching the 8 seasons we have different opinions about the end. Above all opinion, Game of Thrones is a series with a Read More

The purpose of this entry is to verify the connectivity to access a SQL Server Reporting Services using a trust relationship between two domains. This makes it possible to connect to the report with users from another domain. 1. Requirements: First we have to prepare Read More