Solver App for Android and iPhone
Strategies for Number Puzzles of all kinds
Page Index
Solvers
Puzzles
Latest Apps
Str8ts
Other

Tech Tips I Need to Remember

T-SQL: Find Column Used in Stored Procedure

USE AdventureWorks2012
GO
SELECT obj.Name SPName, sc.TEXT SPText
FROM sys.syscomments sc
INNER JOIN sys.objects obj ON sc.Id = obj.OBJECT_ID
WHERE sc.TEXT LIKE '%' + 'BusinessEntityID' + '%'
AND TYPE = 'P'
GO
Source

Link to guides and resources for creating HTML emails compatible with a wide range of email programs:

Windows 2008 server
Change RDP port (best guide)
http://www.iteezy.com/change-rdp-3389-port-on-windows-2008-server/qc/10098

Classic Windows Alt-Tab

Applies to Windows 7
Source
To change the cluttered, visually noisy Alt+Tab back to icons, change this registry value:
[HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Explorer]

and add a DWORD called AltTabSettings at set its value to 1.

ODBC Driver for Windows 7 64 Bit

Windows 7 64 Bit
Use c:\windows\sysWOW64\odbcad32.exe instead of the one in control panel which is for 64 bit drivers


MIME type for Android Packages

Any web server
Extension: .apk
MIME: application/vnd.android.package-archive


Remove favourites from Windows Explorer

Applies to Windows 7
Source
To remove Favorites, change this registry value:
[HKEY_CLASSES_ROOT\CLSID\{323CA680-C24D-4099-B94D-446DD2D7249E}\ShellFolder]
"Attributes"=dword:a9400100

To restore Favorites to its default setting (i.e., so it shows):
[HKEY_CLASSES_ROOT\CLSID\{323CA680-C24D-4099-B94D-446DD2D7249E}\ShellFolder]
"Attributes"=dword:a0900100

To remove Libraries, change this registry value:
[HKEY_CLASSES_ROOT\CLSID\{031E4825-7B94-4dc3-B131-E946B44C8DD5}\ShellFolder]
"Attributes"=dword:b090010d

To restore Libraries to its default setting (i.e., so it shows):
[HKEY_CLASSES_ROOT\CLSID\{031E4825-7B94-4dc3-B131-E946B44C8DD5}\ShellFolder]
"Attributes"=dword:b080010d



Windows Photo Viewer - change the background to black

Applies to Windows 7
  • Open Regedit
  • Navigate to HKEY_CURRENT_USER/SOFTWARE/MICROSOFT/WINDOWS PHOTO VIEWER/VIEWER
  • On the right hand side that has MainWndPos right click on an empty surface, pick new DWORD (32-BIT) VALUE
  • Change NEW Value #1 to Backgroundcolor
  • Double click on the backgroundcolor word and change the value from 0 to ff000000
  • On the right hand side that has MainWndPos right click on an empty surface, pick new DWORD (32-BIT) VALUE
  • Change NEW Value #1 to Textcolor
  • Double click on the backgroundcolor word and change the value from 0 to ffffffff

Now you should have to values that look like below
BackgroundColor = 0xff000000 (Some long number)
TextColor = 0xffffffff (Some long number)

It is as easy as that you don't have to reboot. Open a Picture using Windows Photo Viewer

If you want to change Windows Live Photo Gallery you do the same thing in this location below
HKEY_CURRENT_USER\Software\Microsoft\Windows Live\Photo Gallery\Viewer

Credit: Joseph Karman, Calgary, Alberta


Windows Photo Viewer - Fix dull or off-white colours

Applies to Windows 7
On my system a number of applications would display graphics with dull colors, including Windows Photo Viewer and Firefox browser.
  • Open control panel, click on "Hardware and Sound"
  • Find color management. If it is not there under "Display" open "Start" and "Run" the following (and/or create a shortcut to Color Management): C:\Windows\System32\colorcpl.exe
  • In the dialog that appears tick the box under your monitor name which says "use my settings for this device"
  • click on the Add button
  • There will appear a list of color profiles. You want to select sRGBIEC611966-2.1 and click ok
  • Click on the set as default profile button and then close button
  • Reboot
Repeat this procedure for each monitor you may have.



Article created on 25-March-2012. Views: 2437
This page was last modified on 2-October-2014.
All text is copyright and for personal use only but may be reproduced with the permission of the author.
Copyright Andrew Stuart @ Syndicated Puzzles Inc, 2014