SQL Server Version Database  

Posted by ReelTym

Querying/Resetting/Opening Remote Desktop Connections  

Posted by ReelTym


Log into a server on the domain and open a windows command prompt

qwinsta = Query WINdows STAtion

To view current connections on a server type:
            qwinsta /server:<server name or ip address>

When the results are displayed pick an ID value that has a state of “Disc” (Disconnected)

rwinsta = Reset WINdows STAtion

To kill a session pick the ID with the state of “Disc” and type the following:
            rwinsta <ID Value> /server:<server name or ip address>

The remote desktop session has been killed and you are now able to Remote Desktop into your original SQL Server.

Starting Remote Desktop from the Command-Line......

If you may wan to run Desktop Console from a batch file, for example RDC over VPN, you can use mstsc /v:servername /console command.

Mstsc

Creates connections to terminal servers or other remote computers, edits an existing Remote Desktop Connection (.rdp) configuration file, and migrates legacy connection files that were created with Client Connection Manager to new .rdp connection files.

Syntax

            mstsc.exe {ConnectionFile | /v:ServerName[:Port]} [/console] [/f] [/w:Width /h:Height]
            mstsc.exe /edit"ConnectionFile"
            mstsc.exe /migrate

Parameters
            ConnectionFile
                        Specifies the name of an .rdp file for the connection.

            /v:ServerName[:Port]
                        Specifies the remote computer and, optionally, the port number to which you want to connect.

            /console
                        Connects to the console session of the specified Windows Server 2003 family operating system.

            /f
                        Starts Remote Desktop connection in full-screen mode.

            /w:Width /h:Height
                        Specifies the dimensions of the Remote Desktop screen.

            /edit"ConnectionFile"
                        Opens the specified .rdp file for editing.

            /migrate
                        Migrates legacy connection files that were created with Client Connection Manager to new .rdp connection files.

Remarks

You must be an administrator on the server to which you are connecting to create a remote console connection.
default.rdp is stored for each user as a hidden file in My Documents. User created .rdp files are stored by default in My Documents but can be moved anywhere.
Examples

To connect to the console session of a server, type:

            mstsc /console

To open a file called filename.rdp for editing, type:

            mstsc /edit filename.rdp

Wooden Centrifugal Puzzle  

Posted by ReelTym

Notchable Burr Puzzles  

Posted by ReelTym


Design/test your own here: IBM Burr Puzzles

Public Domain Flix  

Posted by ReelTym

How to Pick a Dog  

Posted by ReelTym

Michael's Duct Tape Backpack (First Instructable)  

Posted by ReelTym

Not only is this a "Featured" Instructable, it is also a "Finalist" in the Duct Tape Contest!




Paint.NET  

Posted by ReelTym

Get Paint.NET!

Command line reference: Database and Operating Systems  

Posted by ReelTym

                 
  Oracle   Oracle database
dict.
  CMD Commands   Windows XP
+ Resource Kits, Robocopy
 
  Bash   BASH
GNU Linux
  VBScript   VBScript Commands  
  OS X Commands   OS X commands
Leopard 10.5
  Powershell   Windows PowerShell  
  Forum   Discussion
Forums
  SQL Server   SQL Server database  
                 

POWERSHELL: An A-Z Index of Windows PowerShell commands  

Posted by ReelTym

a
    Get-Acl                   Get permission settings for a file or registry key
    Set-Acl                   Set permissions
    Get-Alias           gal   Return alias names for Cmdlets
 Import-Alias          ipal   Import an alias list from a file
    New-Alias           nal   Create a new alias.
    Set-Alias           sal   Create or change an alias
   Get-AuthenticodeSignature  Get the signature object associated with a file
   Set-AuthenticodeSignature  Place a signature in a .ps1 script or other file
c
   Set-Location  cd/chdir/sl  Set the current working location
   Get-ChildItem   dir/ls/gci Get child items (contents of a folder or registry key)
     Clear-Host    clear/cls  Clear the screen
     Clear-Item         cli   Remove content from a variable or an alias
       Get-Command      gcm   Retrieve basic information about a command
   Measure-Command            Measure running time
     Trace-Command            Trace an expression or command
        Add-Computer          Add a computer to the domain
 Checkpoint-Computer          Create a system restore point (XP)
    Restore-Computer          Restore the computer to a previous state
     Add-Content         ac   Add to the content of the item
     Get-Content cat/type/gc  Get content from item (specific location)
     Set-Content         sc   Set content in the item (specific location)
   Clear-Content        clc   Remove content from a file/item
     Get-Command        gcm   Get basic information about cmdlets
  Invoke-Command        icm   Run command
   Enable-ComputerRestore     Enable System Restore on a drive
   Disable-ComputerRestore    Disable System Restore on a drive
   Get-ComputerRestorePoint   Get the restore points on the local computer
   ConvertFrom-CSV            Convert object properties (in CSV format) into CSV objects
   ConvertTo-CSV              Convert .NET Framework objects into CSV variable-length strings
   ConvertTo-Html             Convert the input into an HTML table
   ConvertTo-Xml              Convert the input into XML
   ConvertFrom-SecureString   Convert a secure string into an encrypted standard string
   ConvertTo-SecureString     Convert an encrypted standard string into a secure string
   Copy-Item     copy/cp/ci   Copy an item from a namespace location
   Export-Counter             Export Performance Counter data to log files
      Get-Counter             Get performance counter data
   Import-Counter             Import performance counter log files

   Get-Credential             Get a security credential (username/password)
   Get-Culture                Get region information (language and keyboard layout)
d
   Get-ChildItem   Dir/ls/gci Get child items (contents of a folder or registry key)
   Get-Date                   Get current date and time
   Set-Date                   Set system time on the host system
   Remove-Item  Del/erase/rd/rm/rmdir   Delete an item
   Compare-Object diff/compare   Compare the properties of objects
   Do                         Loop while a condition is True
e
     Get-Event                Get events in the event queue
     Get-WinEvent             Get events from event logs and event trace logs
     New-Event                Create a new event
  Remove-Event                Delete events from the event queue
 Unregister-Event             Cancel an event subscription
   Clear-EventLog             Delete all entries from an event log
     Get-Eventlog             Get event log data
     New-Eventlog             Create a new event log and a new event source
  Remove-EventLog             Delete an event log
   Get-EventSubscriber        Get event subscribers
Register-EngineEvent          Subscribe to powershell events
Register-ObjectEvent          Subscribe to .NET events
   Register-WmiEvent          Subscribe to a WMI event
   Get-ExecutionPolicy        Get the execution policy for the shell
   Set-ExecutionPolicy        Change the execution policy (user preference)
   Export-Alias         epal  Export an alias list to a file
   Export-Clixml              Produce a clixml representation of powershell objects
   Export-Console             Export console configuration to a file
   Export-Csv          epcsv  Export to Comma Separated Values (spreadsheet)
   Exit                       Exit Powershell (or exit a script)
f
   ForEach-Object    foreach  Loop for each object in the pipeline ( % )
   ForEach                    Loop through values in the pipeline
   For                        Loop through items that match a condition
   Format-Custom         fc   Format output using a customized view
   Format-List           fl   Format output as a list of properties, each on a new line
   Format-Table          ft   Format output as a table
   Format-Wide           fw   Format output as a table listing one property only
  Export-FormatData           Save formatting data from the current session 
     Get-FormatData           Get the formatting data in the current session
g
   Get-Item              gi   Get a file/registry object (or any other namespace object)
   Get-ChildItem   dir/ls/gci Get child items (contents of a folder or registry key)
h
   Get-Help            help   Open the help file
     Add-History              Add entries to the session history
   Clear-History       clhy   Delete entries from the session history
     Get-History  history/h/ghy Get a listing of the session history
  Invoke-History     r/ihy    Invoke a previously executed Cmdlet
     Get-Host                 Get host information (PowerShell Version and Region)
   Clear-Host      clear/cls  Clear the screen
    Read-Host                 Read a line of input from the host console
   Write-Host                 Display message on screen
     Get-HotFix               Get Installed hotfixes
i
   if                         Conditionally perform a command
   Import-Clixml              Import a clixml file and rebuild the PS object
   Import-Csv         ipcsv   Take values from a CSV list and send objects down the pipeline.
      Get-Item           gi   Get a file object or get a registry (or other namespace) object
   Invoke-Item           ii   Invoke an executable or open a file (START)
   Invoke-Expression    iex   Run a PowerShell expression
      New-Item           ni   Create a new item in a namespace
   Remove-Item  rm/del/erase/rd/ri/rmdir   Remove an item
      Set-Item           si   Change the value of an item
    Clear-ItemProperty  clp   Remove the property value from a property
     Copy-ItemProperty  cpp   Copy a property along with it's value
      Get-ItemProperty   gp   Retrieve the properties of an object
     Move-ItemProperty   mp   Move a property from one location to another
      New-ItemProperty        Set a new property
   Remove-ItemProperty   rp   Remove a property and its value
   Rename-ItemProperty  rnp   Renames a property at its location
      Set-ItemProperty   sp   Set a property at the specified location to a specified value
j
       Get-Job          gjb   Get PowerShell background jobs that are running
   Receive-Job         rcjb   Get PowerShell background job results
    Remove-Job          rjb   Delete a PowerShell background job
     Start-Job         sajb   Start a PowerShell background job
      Stop-Job         spjb   Stop a PowerShell background job
      Wait-Job          wjb   Wait for background job
k
   Stop-Process    kill/spps  Stop a running process
l
   Get-Location    pwd / gl   Get and display the current location
   Pop-Location        popd   Set the current working location from the stack
  Push-Location       pushd   Push a location to the stack
   Set-Location  cd/chdir/sl  Set the current working location
m
   Add-Member                 Add a member to an instance of a PowerShell object
   Get-Member            gm   Enumerate the properties of an object
    Get-Module          gmo   Get the modules imported to the session
 Import-Module         ipmo   Add a module to the session
    New-Module          nmo   Create a new dynamic module (only in memory)
 Remove-Module          rmo   Remove a module from the current session
   Move-Item      mv/move/mi  Move an item from one location to another
o
  Compare-Object diff/compare Compare the properties of objects
    Group-Object       group  Group objects that contain the same value
  Measure-Object              Measure the properties of an object
      New-Object              Create a new .Net object
   Select-Object      select  Select properties of objects
     Sort-Object        sort  Sort objects by property value
    Where-Object              Filter the objects passed along the command pipeline
   Out-Default                Send output to default
   Out-File                   Send command output to a file
   Out-GridView         ogv   Send output to an interactive table
   Out-Host              oh   Send the pipelined output to the host
   Out-Null                   Send output to null
   Out-Printer           lp   Send the output to a printer
   Out-String                 Send objects to the host as strings
p
   Powershell                 Launch a powershell session
   Convert-Path        cvpa   Convert a ps path to a provider path
      Join-Path               Combine a path and child-path
   Resolve-Path        rvpa   Resolves the wildcards in a path
     Split-Path               Return part of a path
      Test-Path               Return true if the path exists, otherwise return false
 Get-Pfxcertificate         Get pfx certificate information
    Pop-Location       popd   Set the current working location from the stack
   Push-Location      pushd   Push a location to the stack
     Get-Process     ps/gps   Get a list of processes on a machine
   Debug-Process              Attach a debugger to a running process
   Start-Process  start/saps  Start one or more processes
    Stop-Process   kill/spps  Stop a running process
   Enable-PSBreakpoint  ebp   Enable a breakpoint in the current console
  Disable-PSBreakpoint  dbp   Disable a breakpoint in the current console
      Get-PSBreakpoint  gbp   Get the currently set breakpoints
      Set-PSBreakpoint  sbp   Set a breakpoint on a line, command, or variable
   Remove-PSBreakpoint  rbp   Delete breakpoints from the current console
      Get-PSDrive       gdr   Get drive information (DriveInfo)
      New-PSDrive   mount/ndr Install a new drive on the machine
   Remove-PSDrive       rdr   Remove a provider/drive from its location
      Get-PSProvider          Get information for the specified provider
      Set-PSdebug             Turn script debugging on or off
    Enter-PSSession  etsn     Start an interactive session with a remote computer
     Exit-PSSession  exsn     End an interactive session with a remote computer
   Export-PSSession  epsn     Import commands and save them in a PowerShell module
      Get-PSSession   gsn     Get the PSSessions in the current session
   Import-PSSession  ipsn     Import commands from another session
      New-PSSession   nsn     Create a persistent connection to a local or remote computer
   Remove-PSSession   rsn     Close PowerShell sessions
    Disable-PSSessionConfiguration  Deny access to PS session configuration
     Enable-PSSessionConfiguration  Enable PS session configuration
        Get-PSSessionConfiguration  Get the registered PS session configuration
   Register-PSSessionConfiguration  Create and register a new PS session configuration
 Unregister-PSSessionConfiguration  Delete registered PS session configuration
   Add-PsSnapIn        asnp   Add snap-ins to the console
   Get-PsSnapin        gsnp   List PowerShell snap-ins on this computer
   Remove-PSSnapin     rsnp   Remove PowerShell snap-ins from the console
q
   Quest AD cmdlets           Read and write to Active Directory
r
   Read-Host                  Read a line of input from the host console
   Remove-Item  rm/del/erase/rd/ri/rmdir   Remove an item
   Rename-Item      ren/rni   Change the name of an existing item
   Rename-ItemProperty        Rename a property of an item
   Run/Call             &     Run a command (call operator)
s
   Select-Object     select   Select properties of objects
       Get-Service      gsv   Get a list of services
       New-Service            Create a new service
   Restart-Service            Stop and then restart a service
    Resume-Service            Resume a suspended service
       Set-Service            Change the start mode/properties of a service
     Start-Service     sasv   Start a stopped service
      Stop-Service     spsv   Stop a running service
   Suspend-Service            Suspend a running service
   Sort-Object         sort   Sort objects by property value
   Start-Sleep        sleep   Suspend shell, script, or runspace activity
   Switch                     Multiple if statements
   ConvertFrom-StringData     Convert a here-string into a hash table
   Select-String              Search through strings or files for patterns
t
   Tee-Object           tee   Send input objects to two places
   New-Timespan               Create a timespan object
   Trace-Command              Trace an expression or command
   Get-Tracesource            Get components that are instrumented for tracing.
   Set-Tracesource            Trace a PowerShell component
     Start-Transaction        Start a new transaction 
  Complete-Transaction        Commit the transaction
       Get-Transaction        Get information about the active transaction
       Use-Transaction        Add a command or expression to the transaction
      Undo-Transaction        Roll back a transaction
   Start-Transcript           Start a transcript of a command shell session
    Stop-Transcript           Stop the transcription process
   Add-Type                   Add a .NET Framework type to a PowerShell session
   Update-TypeData
u
   Get-Uiculture              Get the ui culture information
   Get-Unique            gu   Get the unique items in a collection
    Update-Formatdata         Update and append format data files
    Update-Typedata           Update the current extended type configuration
v
   Clear-Variable       clv   Remove the value from a variable
     Get-Variable        gv   Get a powershell variable
     New-Variable        nv   Create a new variable
  Remove-Variable        rv   Remove a variable and its value
     Set-Variable    set/sv   Set a variable and a value
w
   Where-Object      where/?  Filter input from the pipeline
   Where                      Filter objects from the pipeline
   While                      Loop while a condition is True
   Write-Debug                Write a debug message to the host display
   Write-Error                Write an object to the error pipeline.
   Write-Output   write/echo  Write an object to the pipeline
   Write-Progress             Display a progress bar
   Write-Verbose              Write a string to the host's verbose display
   Write-Warning              Write a warning message
    Set-WmiInstance           Create or update an instance of an existing WMI class
 Invoke-WmiMethod      iwmi   Call WMI methods
    Get-WmiObject      gwmi   Get WMI class information
 Remove-WmiObject      rwmi   Delete an instance of a WMI class
    Connect-WSMan             Connect to the WinRM service on a remote computer
 Disconnect-WSMan             Disconnect from the WinRM service on a remote computer
       Test-WSMan             Test whether the WinRM service is running
  Invoke-WSManAction          Invoke an action on a specified object
 Disable-WSManCredSSP         Disable Credential Security Service Provider (SSP) authentication
  Enable-WSManCredSSP         Enable Credential SSP authentication
     Get-WSManCredSSP         Get the Credential SSP configuration
   New-WSManInstance                                                                                                         
   Get-WSManInstance          Display management information (XML or value)
   Set-WSManInstance          Modify the management information related to a resource
   Set-WSManQuickConfig       Configure the local computer for remote management
   New-WSManSessionOption
   #                          Comment / Remark
   ?                          Alias for Where-Object
   $variable = "value"        Define a variable  also: ${n!a#me} = "value"
   @(...)                     Force an expression to be evaluated as an array


The cmdlets on this page are listed in A-Z order, matching either the Verb- or -Noun or Alias of the cmdlet (some are listed more than once).


In addition to the above, Powershell can also run all the standard CMD commands (apart from internal commands), plus VBScript and Resource kit utilities.


Related:
   Microsoft: PowerShell 2.0 core and PowerShell Scripting help Exchange 2010 cmdlets SQL Server 2008
   Discussion forum,
   Links to other websites, books etc...

SQL: An A-Z Index of the SQL Server 2005 database  

Posted by ReelTym

Aggregate - CREATE AGGREGATE
          - DROP AGGREGATE 
Application Role - CREATE APPLICATION ROLE
                 - ALTER APPLICATION ROLE
                 - DROP APPLICATION ROLE
Assembly - CREATE ASSEMBLY
         - ALTER ASSEMBLY
         - DROP ASSEMBLY
ALTER AUTHORIZATION

BACKUP
BACKUP CERTIFICATE
BEGIN [DIALOG [CONVERSATION]]

Certificate - ALTER CERTIFICATE
            - CREATE CERTIFICATE
            - DROP CERTIFICATE
CHECKPOINT
COMMIT
Contract - CREATE CONTRACT
         - DROP CONTRACT
Credential - CREATE CREDENTIAL
           - ALTER CREDENTIAL
           - DROP CREDENTIAL

Database - CREATE DATABASE
         - ALTER DATABASE
         - DROP DATABASE
DBCC CHECKALLOC   - Check consistency of disk allocation.
DBCC CHECKCATALOG - Check catalog consistency
DBCC CHECKCONSTRAINTS - Check integrity of table constraints.
DBCC CHECKDB    - Check allocation, and integrity of all objects.
DBCC CHECKFILEGROUP - Check all tables and indexed views in a filegroup.
DBCC CHECKIDENT - Check identity value for a table.
DBCC CHECKTABLE - Check integrity of a table or indexed view.
DBCC CLEANTABLE - Reclaim space from dropped variable-length columns.
DBCC dllname    - Unload a DLL from memory.
DBCC DROPCLEANBUFFERS - Remove all clean buffers from the buffer pool.
DBCC FREE... CACHE  - Remove items from cache.
DBCC HELP        - Help for DBCC commands.
DBCC INPUTBUFFER - Display last statement sent from a client to a database instance.
DBCC OPENTRAN    - Display information about recent transactions.
DBCC OUTPUTBUFFER - Display last statement sent from a client to a database instance.
DBCC PROCCACHE   - Display information about the procedure cache
DBCC SHOW_STATISTICS - Display the current distribution statistics
DBCC SHRINKDATABASE - Shrink the size of the database data and log files.
DBCC SHRINKFILE  - Shrink or empty a database data or log file. 
DBCC SQLPERF     - Display transaction-log space statistics. Reset wait and latch statistics.
DBCC TRACE...    - Enable or Disable trace flags
DBCC UPDATEUSAGE - Report and correct page and row count inaccuracies in catalog views
DBCC USEROPTIONS - Return the SET options currently active
DBCC deprecated commands
DBCC Undocumented commands
DECLARE
Default - CREATE DEFAULT
        - DROP DEFAULT
DELETE
DENY - DENY Object permissions
     - DENY User/Role permissions
Endpoint - CREATE ENDPOINT
         - ALTER ENDPOINT
         - DROP ENDPOINT
Event - CREATE EVENT NOTIFICATION
      - DROP EVENT NOTIFICATION
EXECUTE
EXECUTE AS
EXISTS - Test for the existence of rows

Fulltext Catalog - CREATE FULLTEXT CATALOG
                 - ALTER FULLTEXT CATALOG
                 - DROP FULLTEXT CATALOG
Fulltext Index - CREATE FULLTEXT INDEX
               - ALTER FULLTEXT INDEX
               - DROP FULLTEXT INDEX
Function - CREATE FUNCTION
         - ALTER FUNCTION
         - DROP FUNCTION

GO
GRANT - GRANT Object permissions
      - GRANT User/Role permissions

IF    - Conditionally execute T-SQL statements.
Index - CREATE INDEX
      - ALTER INDEX
      - DROP INDEX
INSERT
iSQL -U user -P password -i script.sql -o logfile.log

Key - CREATE ASYMMETRIC KEY
    - ALTER ASYMMETRIC KEY
    - DROP ASYMMETRIC KEY
    - CREATE SYMMETRIC KEY
    - OPEN SYMMETRIC KEY 
    - CLOSE SYMMETRIC KEY
    - ALTER SYMMETRIC KEY
    - DROP SYMMETRIC KEY
KILL
KILL QUERY NOTIFICATION
KILL STATS JOB

Login - CREATE LOGIN
      - ALTER LOGIN
      - DROP LOGIN

Master Key - CREATE MASTER KEY
           - ALTER MASTER KEY
           - BACKUP MASTER KEY
           - DROP MASTER KEY
           - RESTORE MASTER KEY
           - ALTER SERVICE MASTER KEY
           - BACKUP SERVICE MASTER KEY
           - RESTORE SERVICE MASTER KEY
Message Type - CREATE MESSAGE TYPE
             - ALTER MESSAGE TYPE
             - DROP MESSAGE TYPE

Partition Function - CREATE PARTITION FUNCTION
                   - ALTER PARTITION FUNCTION
                   - DROP PARTITION FUNCTION
Partition Scheme - CREATE PARTITION SCHEME
                 - ALTER PARTITION SCHEME
                 - DROP PARTITION SCHEME
Procedure - CREATE PROCEDURE
          - ALTER PROCEDURE
          - DROP PROCEDURE

Queue - CREATE QUEUE
      - ALTER QUEUE
      - DROP QUEUE

Remote Service Binding - CREATE REMOTE SERVICE BINDING
                       - ALTER REMOTE SERVICE BINDING
                       - DROP REMOTE SERVICE BINDING

RESTORE - RESTORE DATABASE Complete
          RESTORE DATABASE Partial
          RESTORE DATABASE Files
          RESTORE LOGS
          RESTORE DATABASE_SNAPSHOT 
          RESTORE FILELISTONLY - List database and log files
          RESTORE HEADERONLY - List backup header info
          RESTORE LABELONLY  - Media info 
          RESTORE REWINDONLY - Rewind and close tape device 
          RESTORE VERIFYONLY
REVERT
REVOKE - REVOKE Object permissions
       - REVOKE User/Role permissions
Role - CREATE ROLE
     - ALTER ROLE
     - DROP ROLE
ROLLBACK
Route - CREATE ROUTE
      - ALTER ROUTE
      - DROP ROUTE

Schema - CREATE SCHEMA
       - ALTER SCHEMA
       - DROP SCHEMA
SELECT
SEND
SERVERPROPERTY
Service - CREATE SERVICE
        - ALTER SERVICE
        - DROP SERVICE
SESSION_USER
SESSIONPROPERTY
SET @local_variable
SET
SHUTDOWN
Signature - ADD SIGNATURE
          - DROP SIGNATURE
Statistics - CREATE STATISTICS
           - UPDATE STATISTICS
           - DROP STATISTICS

Synonym - CREATE SYNONYM
        - DROP SYNONYM

Table - CREATE TABLE
      - ALTER TABLE
      - DROP TABLE
      - TRUNCATE TABLE
Transaction - BEGIN DISTRIBUTED TRANSACTION
            - BEGIN TRANSACTION
            - COMMIT TRANSACTION
Trigger - CREATE TRIGGER
        - ALTER TRIGGER
        - ENABLE TRIGGER
        - DISABLE TRIGGER
        - DROP TRIGGER
Type - CREATE TYPE
     - DROP TYPE

UNION
UPDATE
User - CREATE USER
     - ALTER USER
     - DROP USER
USE

View - CREATE VIEW
     - ALTER VIEW
     - DROP VIEW
 
XML Schema Collection - CREATE XML SCHEMA COLLECTION
                      - ALTER XML SCHEMA COLLECTION
                      - DROP XML SCHEMA COLLECTION


Related:
   Microsoft books online - T-SQL Reference: SQL 2000 | SQL 2005 | SQL 2008
   SS64 Discussion forum
   Links to other SQL Server websites, books etc.

CMD: Windows XP Command Line Syntax  

Posted by ReelTym

   Parameters    Command Line Parameters  %1  %~f1 
   Variables     Create/read environment variables
   Redirection   Spooling output to a file, piping input
   AND/OR Logic  Conditional Execution (If-Then-Else)
   Loops         Loops and Subroutines
   functions     How to package blocks of code
Services     List of Windows XP Services

Evaluating expressions
   Using brackets to Group and expand expressions
   Delayed Expansion Manage <xml> and <html> text
   SET /A        Environment variable arithmetic
   VarSubstring  Extract part of a variable (substring)
   VarSearch     Search & replace part of a variable
   Escape chars, delimiters and quotes
   Wildcards     Match multiple files

Batch Files 
   DateMath      Add or subtract days from any date
   GetDate.cmd   Get todays date (any region, any OS)
   GetTime.cmd   Get the time now 
   GetGMT.cmd    Time adjusted to Greenwich Mean Time
   datetime.vbs  Get Date, Time and daylight savings 
   deQuote       Remove quotes from a string
   DelOlder.cmd  Delete files more than n days old
   StampMe.cmd   Rename a file with the date/time
   Which.cmd     Display full path to any command
   DragDrop.cmd  Drag and drop onto a batch script

Reference/How to
   RUN commands   Start-Run Snap-Ins and Control panel applets
   Slow Browsing  Speed up network browsing
   Printing       Printer connections and print drivers
   Qchange        Script to change Printer connections
   Desktop Heap   Memory configuration
   Permissions    Local vs Global workgroups
   Long Filenames NTFS filename issues
   WorkGroups     Built-In Users and Security Groups
   autoexec       Run commands at startup
   Recovery       The Recovery Console
   WinXP Registry User interface settings


Related: Microsoft.com - Command-line Reference 

CMD: An A-Z Index of the Windows XP command line  

Posted by ReelTym

a
   ADDUSERS Add or list users to/from a CSV file
   ARP      Address Resolution Protocol
   ASSOC    Change file extension associations•
   ASSOCIAT One step file association
   ATTRIB   Change file attributes
b
   BOOTCFG  Edit Windows boot settings
   BROWSTAT Get domain, browser and PDC info
c
   CACLS    Change file permissions
   CALL     Call one batch program from another•
   CD       Change Directory - move to a specific Folder•
   CHANGE   Change Terminal Server Session properties
   CHKDSK   Check Disk - check and repair disk problems
   CHKNTFS  Check the NTFS file system
   CHOICE   Accept keyboard input to a batch file
   CIPHER   Encrypt or Decrypt files/folders
   CleanMgr Automated cleanup of Temp files, recycle bin
   CLEARMEM Clear memory leaks
   CLIP     Copy STDIN to the Windows clipboard.
   CLS      Clear the screen•
   CLUSTER  Windows Clustering
   CMD      Start a new CMD shell
   CMDKEY   Manage stored usernames/passwords
   COLOR    Change colors of the CMD window•
   COMP     Compare the contents of two files or sets of files
   COMPACT  Compress files or folders on an NTFS partition
   COMPRESS Compress individual files on an NTFS partition
   CON2PRT  Connect or disconnect a Printer
   CONVERT  Convert a FAT drive to NTFS.
   COPY     Copy one or more files to another location•
   CSCcmd   Client-side caching (Offline Files)
   CSVDE    Import or Export Active Directory data 
d
   DATE     Display or set the date•
   DEFRAG   Defragment hard drive
   DEL      Delete one or more files•
   DELPROF  Delete NT user profiles
   DELTREE  Delete a folder and all subfolders
   DevCon   Device Manager Command Line Utility 
   DIR      Display a list of files and folders•
   DIRUSE   Display disk usage
   DISKCOMP Compare the contents of two floppy disks
   DISKCOPY Copy the contents of one floppy disk to another
   DISKPART Disk Administration
   DNSSTAT  DNS Statistics
   DOSKEY   Edit command line, recall commands, and create macros
   DSACLs   Active Directory ACLs
   DSAdd    Add items to active directory (user group computer) 
   DSGet    View items in active directory (user group computer)
   DSQuery  Search for items in active directory (user group computer)
   DSMod    Modify items in active directory (user group computer)
   DSMove   Move an Active directory Object
   DSRM     Remove items from Active Directory
e
   ECHO     Display message on screen•
   ENDLOCAL End localisation of environment changes in a batch file•
   ERASE    Delete one or more files•
   EVENTCREATE Add a message to the Windows event log
   EXIT     Quit the current script/routine and set an errorlevel•
   EXPAND   Uncompress files
   EXTRACT  Uncompress CAB files
f
   FC       Compare two files
   FIND     Search for a text string in a file
   FINDSTR  Search for strings in files
   FOR /F   Loop command: against a set of files•
   FOR /F   Loop command: against the results of another command•
   FOR      Loop command: all options Files, Directory, List•
   FORFILES Batch process multiple files
   FORMAT   Format a disk
   FREEDISK Check free disk space (in bytes)
   FSUTIL   File and Volume utilities
   FTP      File Transfer Protocol
   FTYPE    Display or modify file types used in file extension associations•
g
   GLOBAL   Display membership of global groups
   GOTO     Direct a batch program to jump to a labelled line•
   GPUPDATE Update Group Policy settings
h
   HELP     Online Help
i
   iCACLS   Change file and folder permissions
   IF       Conditionally perform a command•
   IFMEMBER Is the current user in an NT Workgroup
   IPCONFIG Configure IP
k
   KILL     Remove a program from memory
l
   LABEL    Edit a disk label
   LOCAL    Display membership of local groups
   LOGEVENT Write text to the NT event viewer
   LOGMAN   Manage Performance Monitor
   LOGOFF   Log a user off
   LOGTIME  Log the date and time in a file
m
   MAPISEND Send email from the command line
   MBSAcli  Baseline Security Analyzer. 
   MEM      Display memory usage
   MD       Create new folders•
   MKLINK   Create a symbolic link (linkd)
   MODE     Configure a system device
   MORE     Display output, one screen at a time
   MOUNTVOL Manage a volume mount point
   MOVE     Move files from one folder to another•
   MOVEUSER Move a user from one domain to another
   MSG      Send a message
   MSIEXEC  Microsoft Windows Installer
   MSINFO   Windows NT diagnostics
   MSTSC    Terminal Server Connection (Remote Desktop Protocol)
   MUNGE    Find and Replace text within file(s)
   MV       Copy in-use files
n
   NET      Manage network resources
   NETDOM   Domain Manager
   NETSH    Configure Network Interfaces, Windows Firewall & Remote access
   NETSVC   Command-line Service Controller
   NBTSTAT  Display networking statistics (NetBIOS over TCP/IP)
   NETSTAT  Display networking statistics (TCP/IP)
   NOW      Display the current Date and Time 
   NSLOOKUP Name server lookup
   NTBACKUP Backup folders to tape
   NTRIGHTS Edit user account rights
o
   OPENFILES Query or display open files
p
   PATH     Display or set a search path for executable files•
   PATHPING Trace route plus network latency and packet loss
   PAUSE    Suspend processing of a batch file and display a message•
   PERMS    Show permissions for a user
   PERFMON  Performance Monitor
   PING     Test a network connection
   POPD     Restore the previous value of the current directory saved by PUSHD•
   PORTQRY  Display the status of ports and services
   POWERCFG Configure power settings
   PRINT    Print a text file
   PRINTBRM Print queue Backup/Recovery
   PRNCNFG  Display, configure or rename a printer
   PRNMNGR  Add, delete, list printers set the default printer
   PROMPT   Change the command prompt•
   PsExec     Execute process remotely
   PsFile     Show files opened remotely
   PsGetSid   Display the SID of a computer or a user
   PsInfo     List information about a system
   PsKill     Kill processes by name or process ID
   PsList     List detailed information about processes
   PsLoggedOn Who's logged on (locally or via resource sharing)
   PsLogList  Event log records
   PsPasswd   Change account password
   PsService  View and control services
   PsShutdown Shutdown or reboot a computer
   PsSuspend  Suspend processes
   PUSHD    Save and then change the current directory•
q
   QGREP    Search file(s) for lines that match a given pattern.
r
   RASDIAL  Manage RAS connections
   RASPHONE Manage RAS connections
   RECOVER  Recover a damaged file from a defective disk.
   REG      Registry: Read, Set, Export, Delete keys and values
   REGEDIT  Import or export registry settings
   REGSVR32 Register or unregister a DLL
   REGINI   Change Registry Permissions
   REM      Record comments (remarks) in a batch file•
   REN      Rename a file or files•
   REPLACE  Replace or update one file with another
   RD       Delete folder(s)•
   RMTSHARE Share a folder or a printer
   ROBOCOPY Robust File and Folder Copy
   ROUTE    Manipulate network routing tables
   RUNAS    Execute a program under a different user account
   RUNDLL32 Run a DLL command (add/remove print connections)
s
   SC       Service Control
   SCHTASKS Schedule a command to run at a specific time
   SCLIST   Display NT Services
   SET      Display, set, or remove environment variables•
   SETLOCAL Control the visibility of environment variables•
   SETX     Set environment variables permanently
   SFC      System File Checker 
   SHARE    List or edit a file share or print share
   SHIFT    Shift the position of replaceable parameters in a batch file•
   SHORTCUT Create a windows shortcut (.LNK file)
   SHOWGRPS List the NT Workgroups a user has joined
   SHOWMBRS List the Users who are members of a Workgroup
   SHUTDOWN Shutdown the computer
   SLEEP    Wait for x seconds
   SLMGR    Software Licensing Management (Vista/2008)
   SOON     Schedule a command to run in the near future
   SORT     Sort input
   START    Start a program or command in a separate window•
   SU       Switch User
   SUBINACL Edit file and folder Permissions, Ownership and Domain
   SUBST    Associate a path with a drive letter
   SYSTEMINFO List system configuration
t
   TASKLIST List running applications and services
   TASKKILL Remove a running process from memory
   TIME     Display or set the system time•
   TIMEOUT  Delay processing of a batch file
   TITLE    Set the window title for a CMD.EXE session•
   TLIST    Task list with full path
   TOUCH    Change file timestamps    
   TRACERT  Trace route to a remote host
   TREE     Graphical display of folder structure
   TYPE     Display the contents of a text file•
   TypePerf Write performance data to a log file
u
   USRSTAT  List domain usernames and last login
v
   VER      Display version information•
   VERIFY   Verify that files have been saved•
   VOL      Display a disk label•
w
   WHERE    Locate and display files in a directory tree
   WHOAMI   Output the current UserName and domain
   WINDIFF  Compare the contents of two files or sets of files
   WINMSD   Windows system diagnostics
   WINMSDP  Windows system diagnostics II
   WINRM    Windows Remote Management
   WINRS    Windows Remote Shell
   WMIC     WMI Commands
x
   XCACLS   Change file and folder permissions
   XCOPY    Copy files and folders
   ::       Comment / Remark• 
y
z
Commands marked • are Internal commands only available within the CMD shell.
All other commands (not marked with •) are external commands which may be used under the CMD shell, PowerShell, or directly from START-RUN.