When having Microsoft SQL databases, its log files can grow quite a bit, potentially slow down the database server and eat up disk space.
To shrink a database, one can run the following line:
EXEC D_ShrinkDBLogs 0,100,1000,'with truncate_only','DB_NAME'
(change DB_NAME with the database’s name)
To shrink all databases, one can use “sp_MSforeachdb” which is an undocumented sql stored procedure:
EXEC sp_MSForEachDB 'D_ShrinkDBLogs 0,100,1000,''with truncate_only'',''?'''
To run this, the following stored procedure need to be installed. It can just be copy pasted from the code below (or download from this link):
read more
When installing Debian on a HP BL465 server, we sometimes run into the problems that after installing, GRUB won’t boot up anymore.
First off, it’s not a Debian specific problem, we had this problem with other Linux distributions also, but decided to standardize on Debian across the organization.
Installing to the MBR fails, and you have to install grub on /dev/cciss/c0d0, although upon rebooting after the installation, Grub throws out an error that it cannot boot off (hd1,0).
When you encounter this, you need to edit the configuration (by pressing e in the initial grub screen), and change the (hd1,0) to (hd0,0).
This did the trick for us,
Thanks,
Michael
Ages ago, I installed 
About