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

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

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

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

PowerApps show us an entire world of possibilities, but they are in a premature state, so we have not too much sites to get information about the problems that can appear. Sometimes things happen that we can’t understand. Mistakes that never happened to us, applications Read More

Have you ever needed an application to share information with someone, access a SQL Server database, or simply to see your business store? The solution to this type of questions used to be to make an application using Visual Studio, but in this post we Read More