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 have an Acer Iconia Tab A501 Tablet with AT&T Service. Have had a bunch of various problems with an old custom ROM and decided tonight to upgrade it.. Had a few issues..

Read More »

So today I ran into an interesting situation - A drive failed, we replaced the drive and zpool replaced.. However the new drive was going extremely slowly and appeared to be failing..

So using some extra zpool attach/detach we came up with this solution:

 

Read More »

You may receive the following error: HTTP Error 404.17 - Not Found.  The requested content appears to be script and will not be served by the static file handler.

This is because .Net isn't configured correctly in IIS.

I ran into this in Windows Server 8 under IIS - Even after installing .Net 3.5 (and hence 2.0) IIS wasn't configured properly - So the static file handler was trying to handle .aspx requests - Resulting in this error.

 

Read More »

HTTP Error 500.19 - Internal Server Error

This can be caused by the handlers section of your web.config not allowing overrides.

Interestingly I wasn't able to unlock this in the UI / IIS Manager - which is what I intended to show here.. Instead from the command prompt..

 

Read More »

Objects exposing columns with CLR types are not allowed in distributed queries. Please use a pass-through query to access remote object '"server"."dbo"."table"'.

this is the results of trying to run "from server.dbname.dbo.tableInstead you can rewrite the query as:

select 

Read More »

Using Linked SQL Servers sometimes you will have performance issues doing joins, another option is OpenRowSet

Read More »

If you get an error when accessing a database Property page:
TITLE: Microsoft SQL Server Management Studio
ADDITIONAL INFORMATION:
Cannot show requested dialog. (SqlMgmt)
Property Owner is not available for Database '[DBNAME]'. This property may not exist for this object, or may not be retrievable due to insufficient access rights.  (Microsoft.SqlServer.Smo)

Read More »

Many times you need to convert from a YYYYMM date field to a date or datetime field - There's multiple ways to do this but this one meets most peoples needs and is simple..

update <table> set fielddate=.....

Read More »

Are you tired of the same old "marketing only" sites showing up in your google results? Perhaps like me you run into, quite often, some sites that are really just advertising hype with a LOT of keywords to get high up in the results.. What can you do about it? Block them...

Read More »

SQL Server has the ability to define views - at the simplest level a view is a select query, usually joining mulitple tables, and usually with a where clause - which you will commonly use.  For simplicity in your programming it's common to use a view insead of show the select / join / where statements in every query..

However what if your view is slow? 

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