As we already know, SQL Server 2025 has been part of our catalog since late 2025. This new version introduces significant enhancements to Intelligent Query Processing (IQP). These innovations focus on automating tasks, reducing the need for manual tuning, and optimizing…
Contained Availability Groups in SQL Server 2022 AlwaysOn
Welcome to a new post on the Aleson ITC blog. As many of us know, in SQL Server 2022 there are many new features that we are loving and one of the least known is the ability to manage contained availability…
SQL Server 2022 Parameter Sensitive Plan
Welcome to a new post on the best Data & AI blog. In today’s article, we will talk about one of the most important new advantages of SQL Server 2022. En concreto, estamos hablando de “Parameter Sensitive Plan” o PSP, que…
Discover SQL Server 2022 Query Store Hints
Hello! Welcome to the new post on the best SQL Server blog. In today’s post we will talk about some of the most outstanding features of SQL Server 2022. As we already know, SQL Server 2022 is currently a reality. We…
Query Store & Automatic Tuning in SQL Server 2017
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…
Get Live Index Creation Percentage in SQL Server
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…
💹 Breaking Up the Columnstore Indexes
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…
Economize Space with the Index ColumnStore Compression
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…
Speed Up SQL Server with ColumnStore Index
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…
Learning to Connect PowerApps with SQL Server
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…