Wednesday, 29 January 2014

How to turn off upper case menus in VS2012

Manual Registry Change

Open the registry editor and go to HKEY_CURRENT_USER\Software\Microsoft\VisualStudio\11.0\General\
(For Windows 8 Desktop Express go to HKCU\Software\Microsoft\WDExpress\11.0\General) //special thanks to msm8bball for the update
(For Web Express go to HKEY_CURRENT_USER\Software\Microsoft\VSWDExpress\11.0\General)

  1. Create a new DWORD value called SuppressUppercaseConversion set to 1
  2. Restart Visual Studio and you should see the change

NOTE: Watch your spelling if you are typing this manually.

P.S. This reg hack also works for VS 2013, just change the 11.0 to 12.0 in the registry path




Friday, 24 January 2014

401 unauthorized from Reporting Services 2008 R2

I used method 2 here to resolve this...;en-us;896861

Method 2: Disable the loopback check (less-recommended method)

The second method is to disable the loopback check by setting the DisableLoopbackCheck registry key.
To set the DisableLoopbackCheck registry key, follow these steps:
  1. Set the


    registry entry to 1. For more information about how to do this, click the following article number to view the article in the Microsoft Knowledge Base:

    281308 Connecting to SMB share on a Windows 2000-based computer or a Windows Server 2003-based computer may not work with an alias name

  2. Click Start, click Run, type regedit, and then click OK.
  3. In Registry Editor, locate and then click the following registry key:


  4. Right-click Lsa, point to New, and then click DWORD Value.
  5. Type DisableLoopbackCheck, and then press ENTER.
  6. Right-click DisableLoopbackCheck, and then click Modify.
  7. In the Value data box, type 1, and then click OK.
  8. Quit Registry Editor, and then restart your computer.

Wednesday, 22 January 2014

Host and Guest Virtual Machine network access


NAT (default)


NAT (advanced, port forwarding)


Then to allow host machine to talk to Virtual machine, configure a second Host only adapter as below...


Monday, 20 January 2014

SQL Server version checking

SELECT @@version

then compare your result against this list

P.S. Pagination in a sub report works only in SQL 2008 R2 versions and above, but only if there is only one column in the Tablix of the master report.

Thursday, 9 January 2014

TFS work item query shortcuts

Just discovered this little gem today, via some help from the newer VS 2013 Ctrl+# work item search box. Turns out in VS2010 work item tracking box, you can enter the short cuts of A: C: T:  and S: to filter on Assigned To, Created By, State and Work Item Type


E.g. all my bugs... is just A:@Me T:Bug


How to Fix a Humax HDR FOX T2 PVR that will not stay powered on

Issue When you attempt to power on your Humax the standby orange light goes blue for a moment, and then powers off automatically again. ...