Browse by Tags

29 July 2010
URLs to reports with non-default parameters

You can give somebody a hyperlink to get to a Reporting Services report and that's all they need if there are no parameters or if the default values are what they want. But how do you specify values for parameters? It turns out to be pretty simple but the documentation is a little vague on some of... Read More...

no comments

Filed under: SQL Server 2005, Reporting Services, SQL Server 2008

11 June 2010
Upgrading log shipping from 2005 to 2008 or 2008R2

If you're using log shipping you need to be aware of some small print. The general idea is to upgrade the secondary server first and then the primary server because you can continue to log ship from 2005 to 2008R2. But this won't work if you're keeping your secondary databases in STANDBY... Read More...

no comments

Filed under: SQL Server 2005, Log Shipping, SQL Server 2008, SQL Server 2008 R2

01 December 2009
Reporting security audit

Today I set out to produce a list of who has access to each report so I could get this audited by the business management. I didn't think it would take long. Download a couple of scripts, evaluate them, pick a good one, execute it, and on with the next job. After all, this is crucial stuff. There's... Read More...

1 comment(s)

Filed under: SQL Server 2005, Reporting Services, SQL Server 2008, Security