Main Page - Back

Tech Tips I Need to Remember

From, the puzzle solver's site

T-SQL: Find Column Used in Stored Procedure

USE AdventureWorks2012
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' + '%'

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)

Classic Windows Alt-Tab

Applies to Windows 7
To change the cluttered, visually noisy Alt+Tab back to icons, change this registry value:

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/

Remove favourites from Windows Explorer

Applies to Windows 7
To remove Favorites, change this registry value:

To restore Favorites to its default setting (i.e., so it shows):

To remove Libraries, change this registry value:

To restore Libraries to its default setting (i.e., so it shows):

Windows Photo Viewer - change the background to black

Applies to Windows 7

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.
Repeat this procedure for each monitor you may have.