I stumbled across a small MDX performance tuning trick when using SSRS reports (or any other client tool where you can edit the MDX). When you create the MDX query using the designer, it will append some cell properties at the end of the query. Basically it’s just metadata about the cells of the result […]
Tag: ssrs
Webinar – SQL Server BI Best Practices
I’ll be giving a webinar for MSSQLTips.com on Thursday March 10, 2016. The title is SQL Server BI Best Practices and its abstract goes like this: Join us for this webcast to learn about best practices for SSIS, SSRS and SSAS. Our presenter, Koen Verbeeck has several years of experience working with the SQL Server Business […]
Overview of Published Articles – 2015Q4
Here is an overview of the articles I published in the final quarter of 2015: Integrated Logging with the Integration Services Package Log Providers SQL Server Integration Services Best Practices and Tuning Tips Webcast Q&A Retrieve Error Column in SSIS 2016 Customize the SQL Server Reporting Services 2016 Parameter Pane SQL Server Integration Services 2016 Control […]
Reporting Services redesign – it’s the little things
SQL Server Reporting Services (SSRS) is getting quite the overhaul in SQL Server 2016. Lot’s of things are changing: new look ‘n feel for Report Builder: Report Builder Changes in SQL Server 2016 new chart types (check out my sunburst, treemap and heatmap articles) a (somewhat) customizable parameter pane HTML 5 support and many, many […]
New SSRS features in SQL 2016 CTP 2.4
SQL Server 2016 CTP 2.4 hasn’t been released yet (any day now I guess), but someone was apparently very eager at Microsoft because some of the MSDN documentation pages are already updated. One of those pages is What’s New in Reporting Services. There we can see three new features will be added: PDF replaces ActiveX […]
Report Builder Changes in SQL Server 2016
As a lot of features, Report Builder will improve as well in SQL Server 2016. At the moment of writing CTP 2.3 has been released and Report Builder has the following changes: more up-to date look ‘n feel high dpi in the preview HTML5 support Screenshot of the look ‘n feel: That’s right: away with baby-blue and enter […]