Monthly Archives: October 2010

TFS Reports/Analysis Server Configuration Issue: Could not load file or assembly ‘Microsoft.AnalysisServices’

Posted on October 21, 2010 by Phil

For those of you attempting to configure Reporting in Team Foundation Server 2010, you may have the above error if the Team Server is on a different machine than that of your Analysis server. To resolve the issue, install the … Continue reading →

Posted in SQL Server Analysis Server 2008, Team Foundation Server 2010 | Tagged , , | Leave a comment

TSX to MSX Connection Errors After Upgrading to SQL Server 2008 R2

Posted on October 19, 2010 by Phil

Problem After upgrading your TSX SQL Server 2005/2008 to SQL Server 2008 R2, you may experience some connectivity issues between your newly upgraded TSX server and your MSX server.  If you see the below error in the SQL Server Agent … Continue reading →

Posted in SQL Agent Multi-Server Administration, SQL Server 2008 R2 Upgrade | Tagged , , | Leave a comment

Get the query text for specific SPID/session

Posted on October 6, 2010 by Phil

Have you ever wanted to get the query text for a SPID to see what query is or was in use? Continue reading →

Posted in T-SQL Code Examples | Tagged , | Leave a comment

Deploying CLR assemblies using .Net code

Posted on October 5, 2010 by Phil

VB .Net code example that allows you to deploy .Net assemblies to SQL Server 2005/2008 databases. Continue reading →

Posted in .Net Code Examples | Tagged , , , , , | 1 Comment