Migrating data to Azure: Error: 0xC020844B An existing connection was forcibly closed by the remote host

I was trying to migrate some ‘big’ data to Azure today.

Well, not that big – about 20,000 rows.

But no matter how many times I tried, I was getting the following error:

Error: 0xC020844B at Table1, ADO NET Destination [31]: An exception has occurred during data insertion, the message returned from the provider is: A transport-level error

Continue reading […] Migrating data to Azure: Error: 0xC020844B An existing connection was forcibly closed by the remote host […]

 

Azure vs. inhouse SQL Server - the Wiki project - performance tuning

In my earlier blog post I wrote about setting up the WikiDB database and importing the files.

Initially I was inclined to import the XML files as they came – the files had different sizes ranging from 140 Mb to 7 Gb.

I managed to import the first 12 files, and thought I would stop there.

But on

Continue reading […] Azure vs. inhouse SQL Server – the Wiki project – performance tuning […]

 

Proxy permissions in a Sql Server Agent job

I have a SSIS package which was failing to execute from a SQL Server Agent job with the following error:

Message
Unable to start execution of step 1 (reason: JobOwner EUR\s2sqlhotelldb01 doesn’t have permissions to use proxy 8 for subsystem SSIS). The step failed.

I solved the problem by changing the owner of the job to the account

Continue reading […] Proxy permissions in a sql server agent job […]