Browse by Tags

Reporting Services Execution Log Reports

November 22, 2009

Need to scrub those RS 2008 Execution logs to determine who, what and when those reports ran? A platform for deeper optimization analysis? There's a codeplex project with the DB Schema, SSIS Package and a set of reports: Community Edition : http://scrubs.codeplex.com Premium Edition (offers 15+ more...

SharePoint and SQL Server 2008 Administration - Free eBook!

November 09, 2009

Microsoft has released a free ebook for administration and performance management of SharePoint on SQL Server 2008. http://bit.ly/2RpALX

FTP Task Blocked When Run in SQL Server Agent

September 24, 2009

Got the connectionstring and credentials down pat, and no error message when executing a SQL Server Agent Job that included an FTP task. It just sat there, and sat there. Looked and smelled like a firewall issue. And it was. Didn't occur in Visual Studio, just when running in automated mode. To fix...

Gantt Charting With SQL Reporting Services 2008

August 20, 2009

Update: So SQL Server 2008 is here, and still no Gantt Chart. So this free native workaround will still get you through on SQL Server Reporting Services 2008. I've got an article over at SQL Server Central that describes how to get Gantt charts in SSRS using native controls, not third party. And...

Suppress Auto Update of MDX Parameter Datasets in Reporting Services 2008

June 25, 2009

With the MDX Query Designer in SSRS 2008 Report Designer and Report Builder 2.0, changing the main dataset overwrites the parameter datasets, which will kill any manual adjustments made. Bummer. The hack to fix is to add a SuppressAutoUpdate =true to the parameter dataset: < Query > < DataSourceName...

FIX: Cannot connect to MICROSOFT##SSEE database

June 11, 2009

If you can't connect to the MICROSFT\SSEE instance for sharepoint, try the following: Use " \\.\pipe\mssql$microsoft##ssee\sql\query " as your Server name in SQL server management Studio.

jetlounge