Feeds:
Posts
Comments

Archive for the ‘Reporting Services’ Category

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 »

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 »

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 »

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 »

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 »

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 »

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 »