Friday 30 March 2012

How to Fix Error Unable to access the IIS metabase. You do not have sufficient privilege to access IIS web sites on your machine.

Unable to access the IIS metabase. You do not have sufficient privilege to access IIS web sites on your machine.

More info on YouTube video:




Simple solution - run Visual Studio as Administrator






In Visual Studio 2012

Thursday 29 March 2012

Thursday 22 March 2012

Excel - How to read XML files

It is hard to read xml files.  In order to read them, just move it into Excel
View video


Wednesday 21 March 2012

MS SQL 2012 - How to Fix Error - Arithmetic overflow error converting int to data type numeric.


Watch this example on YouTube:


The following sql statement will produce error
Select CONVERT (decimal(5 , 2), 1111)
Arithmetic overflow error converting int to data type numeric.

This is because 1111 is too large
To fix increase the size
Select CONVERT (decimal(10 , 2), 1111)