By Steve Radich on 4/12/2012 12:07 PM

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 »

By Steve Radich on 4/9/2012 4:37 PM

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 .html requests - Resulting in this error.

 

Read More »

By Steve Radich on 4/9/2012 3:40 PM

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 »

By Steve Radich on 4/4/2012 2:32 PM

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 »

By Steve Radich on 4/3/2012 12:57 PM

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

Read More »