jetlounge

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 optimization reports and traffic path analysis...

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

Two great series of articles on FBA and SharePoint: FBA & SharePoint 2010 FBA & SharePoint Services 3.0

An Adobe Acrobat PDF may display as a blank page in IE 8. Additionally, you may see an error popup that is also blank. This appears to be due to a compatibility issue with the plug in for IE. To fix, force the PDF to open in Adobe Acrobat Reader instead of IE. 1. Open Adobe Acrobat 2. Click Edit, Preferences. 3. Click Internet option in the right pane...

In Terminal Services, if you cannot get IE ESC to disable, even when you have turned the setting off in Server Manager - try the following: Option 1: Modify Internet Explorer settings for administrator accounts loadTOCNode(2, 'resolution'); For administrator accounts, you can run the following command to turn off Internet Explorer Enhanced Security...

Forms based authentication setup on SharePoint 3.0 is so much easier on IIS 7, and a ton easier with this series of tutorials. Yeah, No more web.config hacks for Forms Based Authentication setup! Blog post here .

YES! It is possible: http://blog.summitcloud.com/2009/10/advanced-string-functions-in-sharepoint-workflows-yes-we-can/

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 (on Windows Server 2008), follw instructions for...

SQL Reporting Services Report Builder 2.0 ClickOnce broke in the CU2 of Service Pack 1. So, if you are on Service Pack 1, get Cumulative Update 3. Be sure to install all of the files if you are running Reporting Services in SharePoint integrated mode.

Great point solution for analytics that combines EDI 852, EDIFACT, Partners Online, RetailLink, retail spreadsheets and popular ERPs (to name a few) into easily digested actionable metrics to manage reorder velocity, inventory turn and manage best and worst sellers around the globe. CloudMetrix by SummitCloud .

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 it has a holiday spin. This is the abstact: Gantt...

Me.Value will not work in SQL Server Reporting Services 2008 (SSRS 2008) if you have some complex code behind. This is regardless whether you use that code in your expression. For example, your Tooltip might simply be =Me.Value . Not only will that not work, but the combination might leave you without a visbile value in the cell. What?? I use quite...

Passing URL report parameters directly to a report in a SharePoint Document Library is enabled in the SQL Server Reporting Services 2008 Integration with SharePoint Add-in . When a report is rendered in full-page view in SharePoint, the URL is displayed in the following format: http://<SharePoint_site>/_layouts/ReportServer/RSViewerPage.aspx?rv...

In a SharePoint integrated SQL Server Reporting Services environment, you find you can access a model, open Report Builder, drag an drop a few items. But when you attempt to actually run the report you're told the model cannot be found. What? But you were just using it! The error looks like: An error has occurred during report processing. (rsProcessingAborted...

Enabling Anonymous Access to Report Builder Application Files Report Builder uses ClickOnce technology to download and install application files on the client computer. When it starts on the client computer, the ClickOnce application launcher will make a request for additional application files on the report server computer. If the report server is...