Wednesday, 29 January 2014

How to turn off upper case menus in VS2012

http://blogs.msdn.com/b/zainnab/archive/2012/06/14/turn-off-the-uppercase-menu-in-visual-studio-2012.aspx

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

HKEY_CURRENT_USER\Software\Microsoft\VisualStudio\12.0\General

 

clip_image002

Friday, 24 January 2014

401 unauthorized from Reporting Services 2008 R2

I used method 2 here to resolve this...

http://support.microsoft.com/default.aspx?scid=kb;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

    DisableStrictNameChecking

    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:

    HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Lsa

  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)

image

NAT (advanced, port forwarding)

image

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

image

Monday, 20 January 2014

SQL Server version checking

SELECT @@version

then compare your result against this list

http://sqlserverbuilds.blogspot.co.uk/

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

image

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

image