Thursday, July 20, 2017

TFS: Undo Check-out From Other User

Out-of-the-box, there is no functionality to undo check-outs from other users in Team Foundation Services. But there is an option with TFS Power Tools for VS, available from VS 2012.

  1. Go to Tools and Extensions and Updates.
  2. In the Online Visual Studio Gallery search for Power Tools
  3. Download the extension, close VS and install the extension.

Wednesday, May 31, 2017

Power BI Report Server

I just want to share this short post with anyone that is not familiar with the SQL Server Slack channel at: https://sqlcommunity.slack.com.
If you want to join the Slack channel, visit Brent’s (@BrentO) post: How to Join the SQL Server Community Chat in Slack.

With the introduction of Power BI Report Server on May 3rd, a lot of questions arose.

The particular question that started the thread I want to share was whether it is possible to upgrade an existing SSRS instance to Power BI Report Server. You can read Adam Saxton’s (@GuyInACube) answer to this and other interesting questions in the screenshot below.

nickyvv.com - Power BI Report Server Slack Channel

Friday, April 21, 2017

SSDT Error Message: Unable To Cast COM Object of Type…

Just a short blog post today explaining a problem (and solution) I ran into when working at a client recently. Hopefully it is helpful for anyone out there.

Problem

I recently got this error message at a client when trying to open an SSIS solution in SSDT.

Unable to cast COM object of type 'System.__ComObject' to interface type 'Microsoft.SqlServer.Dts.Pipeline.Wrapper.IDTSObject100'

The reason could be a badly applied Service Pack or CU for example, but I’m not entirely sure about that (source).

Solution

Before starting, make sure you close any open Visual Studio instance.
In a Command Prompt go to the following path (be sure to start the Command Prompt as Administrator):

C:\Program Files\Microsoft SQL Server\120\DTS\Binn\

where 120 is you SQL Server version number.
Reregister the dts.dll by executing the command:

regsvr32 dts.dll

image

If all goes well you should see the following message pop up:

image

I found info here.

Happy coding :)