In this serie of articles, we are going to talk about indexes oriented in columns for SQL Server (Column Store Index), this is an introductory post in which we will include the different aspects that we will deal with later in each of them. The Column Read More

Today we return with an entry where we will discuss the creation of a Virtual Machine in Azure with the new version of Windows Server 2019 Datacenter. To start we must have a subscription in Microsoft Azure, if we do not have one we can get a free with Read More

In the previous entry of the series we learned to manage the access and use of data, but to be completely safe, it is not enough to just secure the data in use, we also have to protect it at rest and in transit. Why is Read More

Creating DimDates with Power BI is the perfect ally for your company’s data analytics. All our data models have a common dimension, the dimension of date or DimDate. Thanks to the date dimension we can make comparisons of data between ranges of dates, see how the annual production Read More

With Power BI Desktop we can create “Tooltip” with our reports to visualize it, when we keep the mouse pointer on the added visual objects. This “Tooltip” pages can be associated to one or several fields of reports as desired. In this post, we are going to follow the Read More

The team of Aleson ITC wishes you a Merry Christmas and a good start in SQL Server 2019, we leave you our Christmas in Power BI that this year is a little more international: PC: Move the mouse over the red points of the map (You can zoom in) Mobile: Keep clicking on Read More

It’s time to do more interesting things with PowerApps. In this entry, we will connect PowerApps to a SQL Server table by inserting a DataTable, because it is a good way to show data on the PowerApp. 1: Scenario. To begin, let’s create a blank PowerApp. At first, we will see Read More