In today’s post we are going to talk about Query Store, the repository that we find within our SQL Server databases. First of all, we are going to learn more about the main objective of this tool. What is Query Store Query Store was born Read More

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 index has. In many cases, we do not have an Read More

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