Truncate (or Purge) Transaction Log in SQL 2008

Over the weekend one of our critical servers ran out of disk space on the volume which contains the transaction logs & all hell broke loose.  Our DBA was at a wedding and couldn’t be reached so it was up to me to get things working ASAP.  I’ve truncated logs before in SQL 2005 and […]

Windows 7 RUNDLL32 Shortcuts

Here is a good list of RUNDLL32 shortcuts / commands that can be used in Windows 7 and Windows 2008 (most also work in Vista and Windows 2003). Add/Remove Programs RunDll32.exe shell32.dll,Control_RunDLL appwiz.cpl,,0 Content Advisor RunDll32.exe msrating.dll,RatingSetupUI Control Panel RunDll32.exe shell32.dll,Control_RunDLL Date and Time Properties RunDll32.exe shell32.dll,Control_RunDLL timedate.cpl Device Manager RunDll32.exe devmgr.dll DeviceManager_Execute Folder Options […]

List of Windows 7 Shell Commands

Windows 7, Windows 2008 (including R2) and Windows Vista shell commands. These can be executed from the “run” command, the “search programs and files” dialog or straight in the address field of Windows Explorer (not Internet Explorer). shell:AddNewProgramsFoldershell:Administrative Toolsshell:AppDatashell:AppUpdatesFoldershell:CD Burningshell:CSCFoldershell:Cacheshell:ChangeRemoveProgramsFoldershell:Common Administrative Toolsshell:Common AppDatashell:Common Desktopshell:Common Documentsshell:CommonDownloadsshell:CommonMusicshell:CommonPicturesshell:Common Programsshell:Common Start Menushell:Common Startupshell:Common Templatesshell:CommonVideoshell:ConflictFoldershell:ConnectionsFoldershell:Contactsshell:ControlPanelFoldershell:Cookiesshell:CredentialManagershell:CryptoKeysshell:Default Gadgetsshell:Desktop shell:Downloadsshell:DpapiKeysshell:Favoritesshell:Fontsshell:Gadgetsshell:GameTasksshell:Gamesshell:Historyshell:InternetFoldershell:Linksshell:Local AppDatashell:LocalAppDataLowshell:LocalizedResourcesDirshell:MAPIFoldershell:MyComputerFoldershell:My Musicshell:My Picturesshell:My […]