On-Demand Report Processing in Reporting Services 2008

You may have heard by now that the report processing engine of Reporting Services 2008 works significantly different underneath the covers, compared to previous releases.  While I plan to dive into more technical details in future postings, I wanted to provide a few examples upfront explaining why you as a report author or end user might care: On-demand…

8

SQL Server 2008 RTM

  SQL Server 2008 was released to manufacturing (RTM) today (see press release).   You can download it on MSDN Subscriber Downloads and TechNet Subscriber Downloads.  Either search for SQL Server 2008 or navigate under Servers then to SQL Server 2008. SQL Server 2008 is a big release and includes very significant changes and enhancements in Reporting…

8

What’s New In Power View

Today SQL Server 2012 RC0 was released.  You can download it here:  http://www.microsoft.com/download/en/details.aspx?id=28145.  This post summarizes much of the new functionality in Power View with RC0. Related information: TechNet page and TechNet wiki for Power View. Multiple Views in a Single Report You asked for it, and we are delivering it!  Power View reports now…

7

ExecutionLog2 View – Analyzing and Optimizing Reports

There are several options for monitoring performance of a report server.  The fourth article in our technical note series on performance and scalability covers information for optimizing entire report servers.  Besides performance counters, analyzing report execution log data in particular can help answer questions such as, which reports might be good candidates for caching, how many reports were returned from…

7

Reporting Services 2008 Resources

Get an overview and the latest information on Reporting Services 2008 at the MSDN aggregation page for Reporting Services!  Research and ask questions on the updated MSDN forums for Reporting Services. Important downloads for Reporting Services: SP2: Report Builder 2.0 (SP2 Download)for Reporting Services 2008 (build 10.00.4000)  SQL Server 2008 SP2 Cumulative Update #3 (build 10.00.4279) SQL Server 2008…

5

Scale-Up Improvements in Reporting Services 2008

A few months ago, leading up to the release of RC0 of SQL Server 2008, I was involved in working with the SQL Server Customer Advisory Team.  They were investigating and comparing the scalability of Reporting Services 2005 and Reporting Services 2008, using common customer report scenarios and workloads.  A more detailed whitepaper is planned…

4

Multi-Player Gaming in RS (aka BI Power Hour 2008)

At the traditional annual “BI Power Hour” sessions, several teams that contribute to the Microsoft Business Intelligence platform show off their technology in a fun way.  It is about demonstrating, in perhaps unusual ways, of how business intelligence and various tools of the BI stack can be useful. In past years, Reporting Services made a…

4

RDL 2008 Specification

Our documentation team made the latest RDL specification available on the Reporting Services site: http://www.microsoft.com/sqlserver/2008/en/us/reporting.aspx The 2008 RDL specification is available as XPS and as PDF document.  Older versions of the RDL specifications are still available: 2005/01 and 2003/10.

3

The Ultimate Guide to Color Scales / Conditional Formatting

I recently provided a tip to my Australian colleague David Lean to successfully solve a small report design challenge with tables and charts that use conditional formatting.  The specific goal was to dynamically calculate and assign a color shade so that the minimum value present in the data is shown red, the average value yellow, and the maximum value…

2

Turn-Based Gaming Against AI in RS Reports (aka BI Power Hour 2009)

At the traditional annual “BI Power Hour” sessions several teams contributing to the Microsoft Business Intelligence platform show off their technology in a fun way.  It is about demonstrating, in perhaps unusual ways, of how business intelligence and various tools of the BI stack can be useful. In past years, Reporting Services made a number…

2