SQL Server

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

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

With Power BI Desktop we can create “Tooltip” with our reports to visualize it, when we keep the mouse pointer on the added visual objects. This “Tooltip” pages can be associated to one or several fields of reports as desired. In this post, we are going to follow the Read More

The team of Aleson ITC wishes you a Merry Christmas and a good start in SQL Server 2019, we leave you our Christmas in Power BI that this year is a little more international: PC: Move the mouse over the red points of the map (You can zoom in) Mobile: Keep clicking on 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

Today we bring you the previous version of SQL Server 2019 CTP 2.2., so you can try it. In addition, we have provided the links so that you can download the latest updates for SQL Server 2017, SQL Server 2016 and SQL Server 2014. We remind you Read More