By Miguel Ángel Motos Posted Tuesday March 26th, 2019 In SQL Server Spanish 0 0 We are going to do a small study and comparison of the indexes oriented in columns for SQL Server (Index ColumnStore). These indexes can be up to 10 times faster than traditional indexes oriented to rows (Index Read More

As we already know, the Internet has changed everything, and buyers no longer want you to sell them your product or service.What customers demand right now is to first approach you and your content, and when they have the need for your product or service, Read More

Surely that everybody know the MailChimp platform, and for those who don’t, it’s one of the most powerful tools of Email Marketing nowadays, besides being characterized by its simplicity and easy to use. It ‘s possible that when analyzing the data of your company you realize that in some Read More

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