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

If you are moving from Microsoft SQL Server to Snowflake you'll likely be moving some datediff sql statements over, datediff(m, date, date) gives the number of months between dates in Microsoft SQL Server - However in snowflake ...

Read More »

Using RedShift you may experience very odd hangs, horrible performance, think that queries aren't returning that you expect to be fairly simple.. 

Read More »

In Amazon's RedShift if you try to use the year() function from Microsoft SQL server you may often end up with:

[Amazon](500310) Invalid operation: function year(timestamp without time zone) does not exist

Read More »

During the transition phase from .Net 4.5 / 4.6 to .Net Core we will have many projects that need to compile under both frameworks. How do you go about this? 

Read More »

When trying to run Invoke-WebRequest it's not found..

I'm doing this on Windows 2016 Nano Server..

Read More »

 On Windows you may want to run some Powershell scripts and may need to override the default ExecutionPolicy.

Should you set this server wide or for the Jenkins user only? 

Read More »

 In Jenkins for a customer we several several powershell scripts configured to run like:

powershell -file \\\data\ExtDataTeam\ImportProcesses\ThisScriptFails.ps1

I may have, for example, this for output (with some removed to obscure customer specific details):

File .ps1 is not digitally signed. You cannot run this script on the current system. For more information about running scripts and setting execution policy, see 
about_Execution_Policies at
+ CategoryInfo          : SecurityError: (:) [], ParentContainsErrorRecord 
+ FullyQualifiedErrorId : UnauthorizedAccess
C:\......\workspace>exit 0 

Read More »

 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 »

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