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 […]

 

SQL Server 2012 Full-Text search and XML Search - the Wiki project

Finally, here are some results from the Wiki project.

After a few days of development, here is the accounting for the wiki project:

Desktop PC with 8Gb RAM, single home use HDD
SQL Server 2012, using XML and Full-Text search
the total amount of data to be imported: 39.2 GB
the original XML files had to be sliced in 150Mb

Continue reading […] SQL Server 2012 Full-Text search and XML Search – the Wiki project […]

 

Full-Text catalog properties - SQL Server

Recently I have been working with the Wiki project – just to prove that my desktop PC can be as fast as Windows Azure in hosting and searching through the entire Wiki content.

In order to do that I created a local database which contains all wikipedia articles in XML format and it uses XML indexing

Continue reading […] Full-Text catalog properties – SQL Server […]