Get the list of SSRS subscriptions

To get the list of all SSRS Subscriptions, just Log on to the Reporting Services instance and run the following query to retrieve the ID, Name, Path, Description ... of the jobs that launche the subscriptions :
Note that to use this query, it requieres to have permission on ReportServer database. especially SELECT permission.

Read More Get the list of SSRS subscriptions

Parent-Child Dimension Properties - Part 2

After creating our Parent-Child dimension (Part 1), we will see in this second part, the different properties of this dimension.

For this, we keep the same example as before: the dimension of the families (Categories) of a product organized according to a descending hierarchy.

Let's go !!!

Read More Parent-Child Dimension Properties - Part 2

Parent-Child Dimension - Part 1

Parent-Child dimension is a type of dimension that I did not know before (yes we can not know everything), but I had the opportunity to use it as part of a project I worked on; So, I thought it would be a good idea to share with you what I learned about this dimension.

In order to better explain how to create this type of dimension and the options, you need to understand the context of the example which is part of this article.

Read More Parent-Child Dimension - Part 1

MPP & Distribution in Azure SQL Data Warehouse

I was fortunate to attend a training about Cortana Intelligence Suite and SQL Data warehouse at Microsoft Paris. The training covered a series of modules on the field of Data Science + Azure SQL Data Warehousing.

As a BI specialist, I became interested in the SQL Data Warehousing part and plunged into the fantastic world of Azure Data Warehouse (ADW) in the last days.

In this article, I would like to talk about two concepts in Azure SQL Data warehouse : MPP & distribution. These concepts define how your data is distributed and processed in parallel:

Read More MPP & Distribution in Azure SQL Data Warehouse

Create an HDInsight cluster using PowerShell

This article provides a mechanism for creating an HDInsight cluster using Windows PowerShell.

The goal is to define a PowerShell script to create and configure your HDInsight cluster and of course remove it afterwards because one of the features that is not yet managed in Azure and we hope that it will be added soon , is stopping your cluster when it is not used because leaving it running costs money.

Read More Create an HDInsight cluster using PowerShell

What is fragmentation?

What is fragmentation? How to detect fragmentation and how to eliminate it?

A fragmented table is a table where some of its data pages point to pages that are not immediately following pages in the extent, and all pages are contiguous in both the allocation plan and the extents , then the table is not fragmented.

Read More What is fragmentation?

Set up a lookup

Using a parameterized query in a lookup can lighten the cached data, especially in the case of iterative processing, and you do not have to load all the data into the cache.

Even though the lookup component does not offer the ability to use variables but it does have the property SqlCommand which allows to specify the query of the lookup and that can be parameterized.

Read More Set up a lookup

Clustered Vs Non-Clustered Index

The difference between the index clustered et Non-clustered in a database is one of the most popular questions in SQL.

Indexes are a very important concept, it makes the execution of your queries fast and if you compare a query SELECT which uses a column indexed to the one that does not, you will see a big difference in performance.

Read More Clustered Vs Non-Clustered Index