Skype was written in Delphi

Wikipedia credits Skype as being written in Delphi.  For a good list of other applications written in Delphi, visit delphi.wikia.com.  Plus Embarcadero has  a dizzying showcase here.  The list of software built with Delphi includes Ad-Aware (which I recommend/install on all relatives machines), Beyond Compare (used at work), Adobe Captivate, FinalBuilder, Help and Manual, Macromedia Homesite, TOAD, Total Commander, and many more.

MS SQL backup and restore commands (utilizing with move)

While I usually like to detach, copy/rename, then reattach development databases, for online databases I often need to refer to these SQL commands:

BACKUP DATABASE MY_DATABASE TO DISK=‘C:\SQLBACKUPS\MY_DATABASE_BACKUP20111117a.BACKUP’

RESTORE FILELISTONLY FROM DISK=‘C:\SQLBACKUPS\MY_DATABASE_BACKUP20111117a.BACKUP’

RESTORE DATABASE MY_DATABASE_NEW FROM DISK=‘C:\SQLBACKUPS\MY_DATABASE_BACKUP20111117a.BACKUP’
WITH
  MOVE
‘MY_DATABASE_Data’ TO ‘C:\PRODUCTION_DATA\MY_DATABASE.MDF’,
 
MOVE ‘MY_DATABASE_Log’ TO ‘C:\PRODUCTION_DATA\MY_DATABASE.LDF’

Delphi IDE Fix Pack from Andy’s Blog and Tools is amazing!

The Delphi IDE Fix Pack from Andy Hausladen in truly incredible.  At work we have a very large Delphi project (core application has about 3.9 million lines of code) and using the Delphi IDE was painfully slow—doing a ‘Find Declaration’ would lock the IDE for minutes.  After installing the IDE Fix Pack the IDE is now useable (and the same ‘Find Declaration’ now it works within a few seconds).  Kudos to Andy Hausladen for a wonderful piece of software!