Feeds:
Posts
Comments

Archive for the ‘Reporting Services’ Category

SQL Server Reporting Services Disaster Recovery Case Study

Posted in Reporting Services, tagged on October 23, 2009 | Leave a Comment »

There are many ways to perform disaster recovery with Microsoft SQL Server Reporting Services (SSRS). Based upon customer experience and internal testing, this technical note provides guidance around best practices to design and manage robust end-to-end disaster recovery (DR). This DR method will involve both automatic and manual failover in the [...]

Read Full Post »

Reporting Services, Report Builder, and ReportViewer Controls

Posted in Reporting Services, tagged , , on April 9, 2009 | Leave a Comment »

I had been asked a number of times what is the difference between Reporting Services, Report Builder, and ReportViewer Controls, so here’s a quick recap:

Reporting Services: This is the server-based reporting platform as part of the Microsoft BI stack that allows you to create reporting solutions against multiple data sources.  More information can be found at: http://msdn.microsoft.com/en-us/library/ms159106.aspx.  [...]

Read Full Post »

Reporting Services Performance Optimization

Posted in Reporting Services, tagged on January 15, 2009 | Leave a Comment »

The final technical note as part of the Building and Deploying Large Scale SQL Server Reporting Services Environments technical note series on Reporting Services Performance Optimization has just been published at Reporting Services Performance Optimization.
 
This technical note provides guidance on the reasons to use 64-bit, how to handle large workloads, Monitoring Reporting Services (which includes [...]

Read Full Post »

ExecutionLog2 View – Analyzing and Optimizing Reports

Posted in Reporting Services, tagged on January 8, 2009 | Leave a Comment »

An excellent blog explaining the ExecutionLog2 view within Reporting Services has been written by Robert Bruckner at: http://blogs.msdn.com/robertbruckner/archive/2009/01/05/executionlog2-view.aspx
 
Quoted from Robert:
Before you can optimize particular reports or your entire system, you need metrics and understand what they tell you.  In this posting, I want to focus on how to effectively interpret and utilize the data present in the [...]

Read Full Post »

Technet Webcast: Building SQL Server Reporting Services 2008 Large-Scale Solutions

Posted in Reporting Services, Uncategorized, tagged , on October 24, 2008 | Leave a Comment »

Check out my Technet webcast on Building SQL Server Reporting Services 2008 Large-Scale Solutions.
 
In this webcast, you learn about successful configuration and architecture principles to maximize the scalability of your enterprise Microsoft SQL Server 2008 Reporting Services (SSRS) environment. Join us as we provide you details, based on real customer scenarios, on how to make [...]

Read Full Post »

Reporting Services Scale-Out Deployment Best Practices

Posted in Reporting Services, tagged on October 22, 2008 | Leave a Comment »

Check out the the third of five technical note as part of the Building and Deploying Large Scale SQL Server Reporting Services Environments Technical Note Series: Reporting Services Scale-Out Deployment Best Practices
This technical note reviews the

SSRS Scale-Out Architecture
Report Catalog sizing
The benefits of File System snapshots for SSRS 2005
Why File System snapshots may not help [...]

Read Full Post »

Reporting Services Performance and Scalability Technical Notes

Posted in Reporting Services, tagged on July 1, 2008 | Leave a Comment »

Over the next few months, I will be publishing a series of technical notes on sqlcat.com that provide guidance on how to build and deploy large scale SQL Server Reporting Services environments.  This series provides general guidance on how to set up, implement, and optimize an enterprise scale-out architecture for your SQL Server Reporting Services (SSRS) environment; [...]

Read Full Post »