BitShop LLC
Ashburn, VA
(703) 728-6831
(703) 563-3826

EMail Us

Our Blogs
Loading BitShop News...

BitShop abides by: the Rotary International Four Way Test - Find out what that means..


To navigate our site click the menu at the top.

Non-BitShop Ads (Hold Control when you click)
Author:Steve Radich - Founder BitShop, Inc.Created:1/9/2009 1:15 PM
Steve Radich, Founder of, ASPDeveloper.Net, and numerous other resource sites primary Blog

 I was loading a data set into Redshift for some experiments and was able to get this..

An error occurred when executing the SQL command:

copy dbo.Loans_test from 's3://removed/removed/loans_full.txt'

credentials 'aws_access_key_id=Removed;aws_secret_acces...


[Amazon](500310) Invalid operation: A fatal error occurred. The database will be restarted.;

1 statement failed.


Execution time: 7.07s

Read More »

I ran into an interesting problem where I ran robocopy to copy hundreds of GB of files to a remote location for a test lab, the vpn dropped several times, copies retried - due to bandwidth limitations it was stopped, etc. All things that can explain why this happened.


After getting to the point robocopy said the directories matched with no errors we had problems with several of the files.

Read More »

 For those that use rsync on other platforms, the windows versions are slightly harder to configure / get working than they were a couple years ago.. Most people would prefer a native Windows version and this is about that..

Read More »

Is there a quick / simple way to show the users whose passwords will be expiring soon to reduce the number of comlaints to tech support that their RDP sessions no longer let users login because the password is expired? 

Read More »

 You can install a free RDP server on your Raspberry Pi which may make it easier to connect for those with a Windows computer but not an extra monitor/keyboard/mouse

Read More »

 You may get an error like I did:

pi@raspberrypi:~ $ sudo apt-get install -f xorg-sgml-doctools

Reading package lists... Done

Building dependency tree

Reading state information... Done

xorg-sgml-doctools is already the newest version.

0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded.

1 not fully installed or removed.

Need to get 0 B/21.9 kB of archives.

After this operation, 0 B of additional disk space will be used.

Do you want to continue? [Y/n]

dpkg: error processing package xorg-sgml-doctools (--configure):

 package is in a very bad inconsistent state; you should

 reinstall it before attempting configuration

Errors were encountered while processing:


E: Sub-process /usr/bin/dpkg returned an error code (1)

pi@raspberrypi:~ $ sudo dpkg --configure -a

NOTE: I had this dpkg --configure -a return an error the first time, which it fixed - But the problem above remained..

Read More »

 I had someone point out to stay away from SQL Server varchar(max) per this blog post about benchmark... But WHY is it slower?

Read More »

 In Nagios check_http gives a simple way to check web servers, but what if you need to pass in parameters? 

Read More »

  (default target) (1) ->

(GetAspNetMergePath target) -> 
C:\Program Files (x86)\MSBuild\Microsoft\VisualStudio\v14.0\Web\Transform\Microsoft.Web.Publishing.AspNetCompileMerge.targets(132,5): error : Can't find the valid AspnetMergePath [C:\Jenkins\jobs\BitShop Task List\Workspace\TaskSystem\TaskSystem.csproj]

Read More »

 Sometimes you may need to list the VM Network MAC addresses to find what host is using a MAC address - This simple Powershell command will show you:

Get-VM | Get-VMNetworkAdapter | ft VMName, MacAddress

Read More »

Please Share Your Comments With Us

Submit Comment
Excellent Info0.00%0
Great Info0.00%0
Useful Info0.00%0
Not so useful0.00%0
Confusing / Useless0.00%0

Number of Comments0,Average of Ratings
No comment.
Network Status

ALL Servers

Learn More!

Find more about our founder

Steve Radich:

LinkedIn Profile

Contact Us