SQL Server

We finished with the GDPR series, our personal data will be more secure than ever, but it is not enough to do the work once, this work has to be constant and that is why in this last entry we will see how to Monitor and Read More

The purpose of this entry is to verify the connectivity to access a SQL Server Reporting Services using a trust relationship between two domains. This makes it possible to connect to the report with users from another domain. 1. Requirements: First we have to prepare 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

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