Reporting Services performance problems can often be narrowed down to report design or resource constraints and sometimes a combination of the two. In this post I’ll review the process of scaling-out Reporting Services so server resource constraints can be shared across multiple servers instead of relying on a single server for all report processing. If you are new to understanding Reporting Services architecture it is important to understand the general steps that are occurring behind the...
Read More
Have you ever experienced this? You have developed a set of Reporting Services report that your users love and they often show them off. The most common way users show off the reports is by taking screenshot images of the reports and embedding those images in a PowerPoint slide deck along with other information they plan to discuss. I personally have seen this several times and I’ve always thought wouldn’t it be better to have a live version of the report available in the PowerPoint ...
Today Pragmatic Works released a whitepaper I wrote and I thought I would share it with you. Prepare for Marketing email… A Whitepaper by Devin Knight SQL Server Reporting Services is capable of creating eye-popping visualizations that can be consumed by a variety of business users. The tool has built-in functionality for developers to produce reports that users will find not only functional, but also visually appealing. This whitepaper will focus on how to overcome the gaps that expressi...
I’m so excited to tell you about SQL Saturday 130 in Jacksonville coming April 28th. This is the 5th year SQL Saturday has been held in Jacksonville and we have some exciting news about the event this year. If you have never attended a SQL Saturday before… WHERE HAVE YOU BEEN?! All kidding aside you really are missing out if you’ve never been to these free events that occur all over the world now. This year we are happy to announce that Kevin Kline will be delivering a Preconf...
Dynamic Management Views are a very powerful tool that are part of Analysis Services in 2008 and 2008 R2. They give you the ability to monitor Analysis Services usage and metadata. MSDN articles on SSAS DMVs – http://msdn.microsoft.com/en-us/library/ms126079.aspx Good post on using SSAS DMVs – http://dwbi1.wordpress.com/2010/01/01/ssas-dmv-dynamic-management-view/ A report developer could leverage the capability to read Analysis Services metadata to build a report that can dynamicall...