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

EMail Us
 

 
Our Blogs
 
Loading BitShop News...
   
 
Morals
 

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

   
 
NEXT STEP
 

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 BitShop.com, ASPDeveloper.Net, and numerous other resource sites primary Blog

I had an interesting question come thru, an IT guy said I can't browse microsoft.com or visualstudio.com from Windows Server 2016 on a brand new server install and was tasked with installing Visual Studio Community Edition for a requirement..

Read More »

When you create an ASG (Auto Scaling Group) you may want to have your SSL certificate auto isntalled and auto pointed to the main site.. However this doesn't export / import with the usual APPCMD methods..

Read More »

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 \\example.com\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 http://go.microsoft.com/fwlink/?LinkID=135170.
+ CategoryInfo          : SecurityError: (:) [], ParentContainsErrorRecord 
Exception
+ 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 »

 
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
Operational


   
 
Learn More!
 

Find more about our founder

Steve Radich:

LinkedIn Profile

Contact Us