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 :)

Tuesday, April 11, 2017

T-SQL Tuesday #89: The Times They Are a-changing

TSQL2sDay150x150

This months T-SQL Tuesday is hosted by Koen Verbeeck (@Ko_Ver) on the topic how the cloud will change and maybe has already changed our jobs as data professionals.
This idea was inspired by Kendra Little’s (@Kendra_Little) blog post Will the Cloud Eat My DBA Job? I listened to the podcast version of her post and here are my 2 cents to the party.