Effective Thoughts

If you're experiencing "Query execution failed for dataset 'ds[Whatever]'. ", more than likely, your warehouse processing is failing. Going into the Admin Console or invoking the web service directly , invoking the Start Rebuild action, I kept receiving a TF221122. Finally, when I added the account under "Account for accessing data sources" under the "Analysis Services" tab to the SQL Server Tfs_Warehouse database TFSEXECROLE role, processing began to succeed again. Whew.

Recently, I delivered a client presentation on SQL Server Reporting Services 2008. There were some follow-ups I thought I’d share: Q. After creating and deploying an .RDL file to Report Manager, later, when I want to modify it, can I bring it back into BIDS? A. Yes. Simply create a new, empty Reporting Services project within BIDS and then Add >> Existing, browse out and open the existing .RDL file. You may need to make some minor edits if you were using a shared data source. Q. Compare Report Builder 2.0 with BIDS. A. Reference this page: http://www.microsoft.com/sqlserver/2008/en/us/report-builder.aspx Q. Compare SSRS 2008 for Standard and Enterprise SQL Server editions. A. Reference this document: http://download.microsoft.com/download/2/D/F/2DF66C0C-FFF2-4F2E-B739-BF4581CEE533/SQLServer2008EnterpriseandStandardFeature%20Compare.pdf Additional, informative article: http://sqlserverpedia.com/wiki/SQL_Server_Standard_and_Enterprise Q. Is there a freely av...

You may have noticed it takes a while for Team Foundation Server (TFS) reports to reflect changes you've made to work items or builds. Let me guess...about an hour, right? Out of the box, TFS is set to refresh the data warehouse from its transactional store every 60 minutes. How do I change the frequency of the data warehouse refresh? Browse to the TFS Controller Web Service on your TFS application tier server within IE at: http://localhost:8080/Warehouse/v1.0/warehousecontroller.asmx Select the ChangeSetting option Enter RunIntervalSeconds for the settingId and the desired number of seconds for newValue (300 for 5 minutes...5*60) Select Invoke How do I force a data warehouse refresh? Two methods here: either via the above web service or using SQL Server Management Studio. Via the web service: Browse to the TFS Controller Web Service within IE at: http://localhost:8080/Warehouse/v1.0/warehousecontroller.asmx Select the Run option Click Invo...