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 […]

Windows Developer Preview (aka Windows 8) on my HP Touchsmart tm2

Thanks to Scott Hanselman’s excellent post a Guide to Installing and Booting Windows 8 Developer Preview off a VHD (Virtual Hard Disk), I now have a very useable touchscreen tablet. Kudos to Microsoft for a very good job with the tablet usability–the side swiping gestures are intuitive and work well.  And the same keyboard in  […]

HP Touchsmart TM2 Bios/Boot Manager Startup Menu

While pressing F2 takes one to the HP Advanced Diagnostics System Manager, to get to the Startup Menu repeatedly press Esc during the tablet’s boot procedure.  The Startup Menu has these options: F1 System Information F2 System Diagnostics  (same as pressing F2 while booting) F9 Boot Device Options F10 BIOS Setup F11 System Recovery

Installing the Windows Developer Preview (aka Windows 8 beta)

The .iso for the Windows Developer Preview can be downloaded from: http://msdn.microsoft.com/en-us/windows/apps/br229516 While it felt a bit like an early Christmas in September, getting the gift unwrapped was challenging.  I could not get the OS to run in VMWare (7.1.4) or Microsoft Virtual PC.  So I turned to Bing and found a link to other’s […]