Some notes on software development... RSS 2.0
# Tuesday, 29 October 2013

I always forget the exact sql server commands for shrinking a transaction log file so, thanks to Pinal Dave, here they are:

USE DatabaseName
DBCC SHRINKFILE(<TransactionLogName>, 1)
DBCC SHRINKFILE(<TransactionLogName>, 1)

Pinal Dave - SQL SERVER – Shrinking Truncate Log File – Log Full

Tuesday, 29 October 2013 17:54:04 (GMT Standard Time, UTC+00:00)  #    -
SQL Server
# Thursday, 19 September 2013

Download and install the latest version of DiffMerge 

From the Visual Studio 2010 menu select Tools->Options->Source Control->Visual Studio Team Foundation Server->Configure User Tools

Add the following…

Extension: .*
Operation: Compare
Command: C:\Program Files\SourceGear\Common\DiffMerge\sgdm.exe
Argument: /t1=%6 /t2=%7 %1 %2


Extension: .*
Operation: Merge
Command: C:\Program Files\SourceGear\Common\DiffMerge\sgdm.exe
Argument: /m /r=%4 /t1=%7 /t2=%8 /t3=%6 /c=%9 %2 %3 %1


Thursday, 19 September 2013 08:54:26 (GMT Standard Time, UTC+00:00)  #    -
Source Control | Visual Studio
# Tuesday, 17 September 2013

Here is the direct link to the Microsoft Orca MSI Editor installer


Tuesday, 17 September 2013 13:46:50 (GMT Standard Time, UTC+00:00)  #    -
# Friday, 23 August 2013 have a great article describing how to shrink a VirtualBox disk image with lots of screenshots, but here are the basic steps for shrinking a VirtualBox image that runs a Windows 7 guest OS. This only works on VDI disk images.

On the Windows 7 guest OS follow these steps:

  1. Uninstall any unused programs
  2. Delete any files you don’t need
  3. Run Disk Cleanup Start->All Programs->Accessories->System Tools->Disk Cleanup
  4. Download CCLEANER and run it.
  5. Run Disk Defragmenter Start->All Programs->Accessories->System Tools->Disk Defragmenter
  6. Download SDELETE and run this command: sdelete –z C:\

The guest Windows 7 OS has now had all the free space zeroed out and is ready for compacting. So from a command line on the host OS:

  1. Navigate to the VirtualBox installation folder, on my Windows 7 x64 OS it’s located here: C:\Program Files\Oracle\VirtualBox\
  2. Run: vboxmanage modifyvdi YOUR-VDI-FILENAME.vdi compact

Job done!

How To Shrink Your Virtualbox VM And Free Up Space For Your Hard Disk

Friday, 23 August 2013 08:04:31 (GMT Standard Time, UTC+00:00)  #    -

Sign In
Total Posts: 116
This Year: 0
This Month: 0
This Week: 0
Comments: 36
About the author/Disclaimer

The opinions expressed herein are my own personal opinions and do not represent my employer's view in any way.

© Copyright 2018
Hadrian Phillips

All Content © 2018, Hadrian Phillips
DasBlog theme 'Business' created by Christoph De Baene (delarou)