Eugene Niemand

Reconfigure an existing Integration Runtime on a Virtual Machine without Reinstalling

It worked on my machine

Downloading parquet files using the Azure Portal Data Explorer corrupts files…

Cannot set the initialization properties for OLE DB provider “MSOLAP” for linked server “TABULAR”

Description

When querying a SSAS instance using a linked server on a remote server while the same user also have a RDP session…

Vague SSIS error message — SSIS Error Code DTS_E_PROCESSINPUTFAILED

So today I got the error message below

DFT Extract interface_RiskScorecard:Error: System.NullReferenceException: Object reference not set to an instance of an object.
 at…

QlikView — Open, Save, Close a QVW without reloading data using PowerShell

So you can open a QVW file from the command line with one of the following options

/r  Reload, save, close.
/rp Partial-Reload, save, close.
/l  Reload, leave open.
/p…

SQLPackage and SSDT dropping and recreating items where they already exist and no changes were made

So I have been struggling for hours trying to figure out why my SQLPackage.exe task thinks it needs drop my Certificates even though I just deployed them and…

T-SQL Code Documentor

I recently resigned and was tasked to document all the important stored procedure and triggers. Yes I know this should have been done at the time but we have never had time, or should I rather say it’s never been priority.

Go Directly To User Detail on SFDC

My wife works as a Salesforce Administrator. When Chatter launched she very quickly became annoyed with the new Chatter profile page that appeared when you clicked on a user’s name.

SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER

How often have you received the error below?

Error

SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The…