SQL Pass presentation: Management, Configuration, Security

It’s been a little while since my last post.  I wanted to provide additional information related to my presentation to day at SQL PASS.  The talk was extremely well attended – the room was full and standing room only. I hope you got what you were looking for out of the talk – feel free…


Getting Started with Reporting Services

The question sometimes comes up for how to get out of the gate fast when ramping up on Reporting Services. Luckily the User Education team has been doing a fantastic job cranking out tutorials about Reporting Services.  This is where I would start: http://msdn2.microsoft.com/en-us/library/ms170246.aspx And then I’d follow with search queries for specific topics on…


IE 7 Beta 3 Issue when viewing reports in Reporting Services

There are a couple of threads on the Reporting Services MSDN Forumn and newsgroup about IE 7 Beta 3 freezing when trying to view Reporting Services reports.  Just wanted to put some quick info out for folks who run into this issue: Firstly, we know abou the issue (we too hit it in our internal…


Report Designer for SQL Server 2000 Reporting Services does not work on Visual Studio 2005

Some folks have run into a problem using SQL Server 2000 Reporting Services now that Visual Studio 2005 has been released. Specifically, the Report Designer in RS 2000 doesn’t work in Visual Studio 2005.  Luckily, there is a solution: The Visual Studio 2005 license includes a downgrade provision.  The details are located here: http://msdn.microsoft.com/vbasic/previous/downgrade.aspx The…


SQL Server 2005 SP1 Reporting Services database expected version is ‘C.0.8.43’ problem

(Originally I thought this post should be titled: SQL 2005 SP1 Tattered my Report Server Database – What’s up with that?)   When you upgrade SQL Server 2005 to SP1 and you are running Reporting Services, you may start to get the following error message:   The version of the report server database is either…


Upgrading Reporting Services – What about my Report Definitions (RDLs)?

Some folks have asked me what happens when I upgrade my RS 2000 to an RS 2005 deployment with respect to Report Definitions (RDLs).   This is an interesting lifecycle problem that we’ve approached using the following idea: What you publish to the report server is what you retrieve from the report server.   Here’s how…


Populating the Cache before your users pound your report server

Often people take a look at their report execution times and wonder how to optimize it.  They readily see that it is possible to cache a report the first time a user runs it so that subsequent users don’t have to incur the initial execution time.   Well that still leaves the first person to…


I’m famous – no seriously, you can watch a video on Reporting Services and Notification Services upgrade on Microsoft.com

Wanted to share with you the following link.   This is a presentation I gave a little while ago on Reporting Services and Notification Services upgrade.  It is now available for viewing in high fidelity video.     http://www.microsoft.com/emea/itsshowtime/sessionh.aspx?videoid=83 Take care and good luck, -Lukasz