SQL Server
2019-02-13
Speed Up SQL Server with ColumnStore Index
2019-01-08
How to Create “TOOLTIP” in Power BI
2018-12-21
Fran Lens
2019-06-04
Fran Lens
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
Sergi Roig
2019-04-24
Sergi Roig
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
Miguel Ángel Motos
2019-03-26
Miguel Ángel Motos
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
Miguel Ángel Motos
2019-02-13
Miguel Ángel Motos
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
Fran Lens
2019-01-24
Fran Lens
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
Rosa del Hoyo Balanzá
2019-01-08
Rosa del Hoyo Balanzá
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
Aleson ITC
2018-12-21
Aleson ITC
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