Azure Portal Corrupts Downloaded Files Have you ever had a situation where you’re working with a tester who has reported a bug, and you can’t for the life of you recreate it? It does after all work on your own machine… We had an example of when downloading a parquet file using the Azure Portal…

In the Advanced Analytics team here at ASOS, we have a few infrequently executed (monthly or weekly) Python processes. They were built by technical users, not engineers, and therefore used to run on a physical machine somewhere in a cupboard. …

Description When querying a SSAS instance using a linked server on a remote server while the same user also have a RDP session (Active/Inactive) to the same remote server using SSMS or any other method for ex SQL Unit Tests this error is produced: OLE DB provider "MSOLAP" for linked server…

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 Microsoft.SqlServer.Dts.Pipeline.ScriptComponentHost.HandleUserException(Exception e) at Microsoft.SqlServer.Dts.Pipeline.ScriptComponentHost.ProcessInput(Int32 inputID, PipelineBuffer buffer) at Microsoft.SqlServer.Dts.Pipeline.ManagedComponentHost.HostProcessInput(IDTSManagedComponentWrapper100 wrapper, Int32 inputID, IDTSBuffer100 pDTSBuffer, IntPtr bufferWirePacket) DFT Extract interface_RiskScorecard:Error: SSIS Error Code DTS_E_PROCESSINPUTFAILED. The ProcessInput method on…

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 Partial-Reload, leave open. /v Pass variable. None of these options suited me, what I wanted was the following; Open QVW…

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 haven’t made any changes. …

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. I was deliberating over the different methods possible to…

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. She wanted to go to the User Details page instead as this is where all the Admin gets done. She realised that to go to the User Details page all you needed to do was append noredirect=1 to the end of the Url. I decided to develop a Chrome Extension to do this automatically for all User Profile links (i.e. Id’s that Start with 005).

How often have you received the error below? — Error SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager “Ovott” failed with error code 0xC0202009. There may be error messages posted before this with more information on why the AcquireConnection method call failed. Very helpful, I know… Please excuse the sarcasm. I spent days trying to fix…