No Picture
Office and Browsers

Count Number of Cell with Errors in Excel

This problem occurs, when you have a column with a formula that sometimes returns an error.  That is very typical for all kind of look-up situations .  Let’s say, you have a column E with formula that returns good values and errors.  You need to count how many errors are […]

Places

How to enter GPS coordinates into Google Maps

Let’s say you moved pictures  from your smart phone to a PC, but you want to know, where this picture was taken.  Most likely picture would have a GPS information attached to it (unless you explicitly disabled that feature on your phone).  Open picture properties (Alt + Enter) and check […]

IIS

Move IIS inetpub Directory

To keep your operating system completely separate from all the web stuff, it is advisable to move inetpub directory off the root of a %SystemDrive% to a completly different drive. In these sample I am moving IIS from C:\inetpub to x:\inetpub.   Adjust this to your needs. Steps described here were […]

No Picture
ASP.NET

The EXECUTE permission was denied on the object ‘aspnet_CheckSchemaVersion’, database ‘YourDB’, schema ‘dbo’

ASP.NET page returns this erorr: The EXECUTE permission was denied on the object ‘aspnet_CheckSchemaVersion’, database ‘YourDB’, schema ‘dbo’. (1) First try runing this command/wizard: %WinDir%\Microsoft.NET\Framework\v2.0.50727\aspnet_regsql.exe   (2) If this doesn’t work, try this query:  — Add user ASPNET to DB role USE YourDB GO sp_addrolemember ‘aspnet_Membership_FullAccess’, ‘ASPNET’ These steps should resolve […]

WordPress

New User Registration in WordPress 3.X

There is a certain magic in many well-constructed marvels.  This definitely applies to a WordPress.  Just recently I needed to fix something inside user registration procedure, and with very limited PHP knowledge, I was able to figure out, what was going on and fix the problem. On the way there, […]