Reporting Service Execution Log Retention

The default logging retention value is 60 days in SSRS. If you want to modify the retention period, you could use SQL Server Management Studio to connect to SSRS instance, check the Advanced page of Server Properties, and change the value of ExecutionLogDaysKept. From the GUI it reads “Valid values for this property include -1…

0

SQL16 Reporting Service Execution Log for Mobile Report

Update: SQL 2016 SP1 makes the change! One area of feedback we rec’d was around the inability to see any logs in the report catalog related to specific mobile reports.  With this release, you now can see basic information in the execution logs for mobile reports, including the folder path, report name, user who ran the…

0

Data Warehouse, Clustered Columnstore Indexes and SAS

Clustered Columnstore Indexes (CCI) is a game changer for data warehouse workload, which is available from SQL Server 2014 Enterprise Edition. I worked for a PoC project last year to adopt Clustered Columnstore Indexes for data warehouse. The PoC method is simple but the improvement is very significant. Below is some detailed. The Pain and…

0