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 7SourceTo 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 7SourceTo 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 7On 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.