RUN command shortcuts

Accessibility Controls : access.cpl
Add Hardware Wizard : hdwwiz.cpl
Add/Remove Programs : appwiz.cpl
Administrative Tools : control admintools
Automatic Updates : wuaucpl.cpl
Bluetooth Transfer Wizard : fsquirt
Calculator : calc
Certificate Manager : certmgr.msc
Character Map : charmap
Check Disk Utility : chkdsk
Clipboard Viewer : clipbrd
Command Prompt : cmd
Component Services : dcomcnfg
Computer Management : compmgmt.msc
Date and Time Properties : timedate.cpl
DDE Shares : ddeshare
Device Manager : devmgmt.msc
Direct X Control Panel (If Installed)* : directx.cp
Direct X Troubleshooter : dxdiag
Disk Cleanup Utility : cleanmgr
Disk Defragment : dfrg.msc
Disk Management : diskmgmt.msc
Disk Partition Manager : diskpart
Display Properties : control desktop
Display Properties : desk.cpl
Display Properties (w/Appearance Tab Preselected) : control color
Dr. Watson System Troubleshooting Utility : drwtsn32
Driver Verifier Utility : verifier
Event Viewer : eventvwr.msc
File Signature Verification Tool : sigverif
Findfast : findfast.cpl
Folders Properties : control folders
Fonts : control fonts
Fonts Folder : fonts
Free Cell Card Game : freecell
Game Controllers : joy.cpl
Group Policy Editor (XP Prof) : gpedit.msc
Hearts Card Game : mshearts
Iexpress Wizard : iexpress
Indexing Service : ciadv.msc
Internet Properties : inetcpl.cpl
IP Configuration (Display Connection Configuration) : ipconfig /all
IP Configuration (Display DNS Cache Contents) : ipconfig /displaydns
IP Configuration (Delete DNS Cache Contents) : ipconfig /flushdns
IP Configuration (Release All Connections) : ipconfig /release
IP Configuration (Renew All Connections) : ipconfig /renew
IP Configuration (Refreshes DHCP & Re-Registers DNS) : ipconfig /registerdns
IP Configuration (Display DHCP Class ID) : ipconfig /showclassid
IP Configuration (Modifies DHCP Class ID) : ipconfig /setclassid
Java Control Panel (If Installed) : jpicpl32.cpl
Java Control Panel (If Installed) : javaws
Keyboard Properties : control keyboard
Local Security Settings : secpol.msc
Local Users and Groups : lusrmgr.msc
Logs You Out Of Windows : logoff
Microsoft Chat : winchat
Minesweeper Game : winmine
Mouse Properties : control mouse
Mouse Properties : main.cpl
Network Connections : control netconnections
Network Connections : ncpa.cpl
Network Setup Wizard : netsetup.cpl
Notepad : notepad
Nview Desktop Manager (If Installed) : nvtuicpl.cpl
Object Packager : packager
ODBC Data Source Administrator : odbccp32.cpl
On Screen Keyboard : osk
Opens AC3 Filter (If Installed) : ac3filter.cpl
Password Properties : password.cpl
Performance Monitor : perfmon.msc
Performance Monitor : perfmon
Phone and Modem Options : telephon.cpl
Power Configuration : powercfg.cpl
Printers and Faxes : control printers
Printers Folder : printers
Private Character Editor : eudcedit
Quicktime (If Installed) : QuickTime.cpl
Regional Settings : intl.cpl
Registry Editor : regedit
Registry Editor : regedit32
Remote Desktop : mstsc
Removable Storage : ntmsmgr.msc
Removable Storage Operator Requests : ntmsoprq.msc
Resultant Set of Policy (XP Prof) : rsop.msc
Scanners and Cameras : sticpl.cpl
Scheduled Tasks : control schedtasks
Security Center : wscui.cpl
Services : services.msc
Shared Folders : fsmgmt.msc
Shuts Down Windows : shutdown
Sounds and Audio : mmsys.cpl
Spider Solitare Card Game : spider
SQL Client Configuration : cliconfg
System Configuration Editor : sysedit
System Configuration Utility : msconfig
System File Checker Utility (Scan Immediately) : sfc /scannow
System File Checker Utility (Scan Once At Next Boot) : sfc /scanonce
System File Checker Utility (Scan On Every Boot) : sfc /scanboot
System File Checker Utility (Return to Default Setting) : sfc /revert
System File Checker Utility (Purge File Cache) : sfc /purgecache
System File Checker Utility (Set Cache Size to size x) : sfc /cachesize=x
System Properties : sysdm.cpl
Task Manager : taskmgr
Telnet Client : telnet
User Account Management : nusrmgr.cpl
Utility Manager : utilman
Windows Firewall : firewall.cpl
Windows Magnifier : magnify
Windows Management Infrastructure : wmimgmt.msc
Windows System Security Tool : syskey
Windows Update Launches : wupdmgr
Windows XP Tour Wizard : tourstart
Wordpad : write

taken from here

Find Last day of the month

To find the last day of the month in SQL:

—-Last Day of Previous Month
SELECT DATEADD(s,-1,DATEADD(mm, DATEDIFF(m,0,GETDATE()),0))
LastDay_PreviousMonth
—-Last Day of Current Month
SELECT DATEADD(s,-1,DATEADD(mm, DATEDIFF(m,0,GETDATE())+1,0))
LastDay_CurrentMonth
—-Last Day of Next Month
SELECT DATEADD(s,-1,DATEADD(mm, DATEDIFF(m,0,GETDATE())+2,0))

Source: here

Learn 3dMax, Adobe etc Online

Website: lynda.com

Need to pay $25 but unlimited, with video quicktime and a good teaching structure.
if you signed up with premium, practice file will be given.

Get list of all tables in SQL and its approximate row count

Here's the SQL to do this.

SELECT
[TableName] = so.name,
[RowCount] = MAX(si.rows)
FROM
sysobjects so,
sysindexes si
WHERE
so.xtype = 'U'
AND
si.id = OBJECT_ID(so.name)
GROUP BY
so.name
ORDER BY
2 DESC

Kewl, huh!?
Reference: here

Bracket Plus Sign (+) in SQL

SELECT *
FROM TABLE1 a, TABLE2 b
WHERE a.CODE = b.CODE(+)

This bracket plus sign (+) indicates a LEFT OUTER JOIN. It includes all records from TABLE1 and from TABLE2 that has CODE field value match.

Click here for more information

Clear Browsing History in IE7

Create batch file (for example: New_IE.bat)

Fill the file with this:

C:\Progra~1\Intern~1\iexplore.exe
RunDll32.exe InetCpl.cpl,ClearMyTracksByProcess 255

When we exit Internet Explorer, System will clear all the history.
This only works for IE 7.

anonymizer
nph-proxy: website that will not write the history to the proxy.
http://www.bpcd.net/cgi-bin/nph-proxy.cgi
enter URL on the site, open all sites, only that url will show in the nph-proxy

or you can use this so that won't keep the history.
chrome: incognito
ie8 (beta): sorry, forgot the name
firefox: there's an option to clear

Identity after inserting

How is exactly to get the identity after inserting in MS SQL?
If the table u are inserting have identity set to YES.
Hence you can use this.

declare @theid as bigint
insert into tablename select myvalue1, myvalue2
set @theid=@@IDENTITY

So the new ID is kept in the variable @theid now.

Reference: here