Since I administer a very high load news site, I noticed that MSSQL log file of the site database is growing enormously. Database itself devided into 2 files one 330MB and the other 721MB, but log files grew to 5GB for the first file, and 20GB for the second file.
Since Microsoft doesn’t recommend that you delete these files, you need to shrink them to smaller files. To do this you have to backup your database (f.e. acctfiles) log files with truncate_only option. Continue reading “Shrink databasename_Log.LDF file on Microsoft SQL”
I generally dislike when movies are divided in two or more parts, although it’s just one more click to load 2nd or 3rd file, I prefer joining them together. Up until recently I was using avimerge tool fromtranscode package to do all of my merging, just because it was so simple to do with:
avimerge -i inputfile1.avi inputfile2.avi -o outputfile.avi
Continue reading “How to merge video files under Linux”
To do this you need at least one more user account with administrator privileges (f.e. I want to move my user profile named Username to another partition and I will use default Administrator user to do this).
First you need to reboot your machine and log in with theAdministrator account and do the following: Continue reading “Transfer user profile to another partition in Windows XP”
In case you have forgotten your root password for MySQL database, you can change it by first killing all mysql processes with:
killall mysql or /etc/init.d/mysql stop (for Debian users)
Now you have to start mysql again with this command:
mysqld --skip-grant-tables &
Continue reading “MySQL root user hack”
One thing that really bothers me is a balloon tip that appears every time I reconnect to my home WiFi. Simplest solution is to disable balloon tips by using RegEdit. Open up this branch:
Add this DWORD value: “EnableBalloonTips” and set it’s value to “0” (zero).
Balloon tips will be disabled after your next logon.