Archives

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 [...]

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 [...]

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 [...]

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 [...]

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 [...]

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 [...]

Have you ever needed an application to share information with someone, access a database, or simply to see your store? The solution to this type of questions used to be to make an application [...]