Excel Trick Tip 1: Change dates like 20050923 to one Excel can “understand”

Suppose you are looking at a worksheet which contains dates which can’t be formatted as “real” dates because of their structure:

Select the date(s), and use Data tab, Text-to-Columns, [Excel2003:Data|Text to Columns]

Which brings up the Text-to-Columns wizard:

Even though the dates are fixed width, in this case you can simply click “Next” twice.

In step 3 of wizard Select Date, YMD:

If you click Finish now, the result will replace the dates. You can select another destination cell:

Here’s the result:


iPhone sending attachment problems Sending this message failed

When you use certificate authentication you have to set the uploadReadAheadSize in the IIS metabase to your max email size, the default is 48KB so nearly any attachment cannot be sent/forwarded.

With the following command you can change the value (in this case 10MB):

C:\Windows\System32\inetsrv\appcmd.exe set config -section:system.webServer/serverRuntime /uploadReadAheadSize:"10485760" /commit:apphost

C:\Windows\System32\inetsrv\appcmd.exe set config “Default Web Site” -section:system.webServer/serverRuntime /uploadReadAheadSize:”10485760″ /commit:apphost

After this restart the IISAdmin service to affect the change.

How to disable Java updates by deleteing registry key via GPO ?

In group policy go to “Computer Configuration” -> “Preferences” -> “Windows Settings” -> “Registry”

Right click on “Registry” and select “New”->”Registry Item”

In the new registry item select “Delete” then specify the path and item you want to delete.

Following values are for java updates



And/or delete the file using GPO:

%CommonProgramFiles(x86)%\Java\Java Update\jusched.exe
%CommonProgramFiles%\Java\Java Update\jusched.exe



Install ImageMagick on CentOS

ImageMagick® is a software suite to create, edit, compose, or convert bitmap images. It can read and write images in a variety of formats (over 100) including DPX, EXR, GIF, JPEG, JPEG-2000, PDF, PNG, Postscript, SVG, and TIFF. Use ImageMagick to resize, flip, mirror, rotate, distort, shear and transform images, adjust image colors, apply various special effects, or draw text, lines, polygons, ellipses and Bézier curves.

Make sure that the required dependencies are installed:

yum install -y ImageMagick ImageMagick-devel

How to Start-Stop MySQL Server on CentOS Server

This small post is to explain how you can start/stop/restart MySQL server from command line on CentOS Server.
Stop MySQL Server

# /etc/init.d/mysqld stop
Start MySQL Server

# /etc/init.d/mysqld start
Restart MySQL Server

# /etc/init.d/mysqld restart
Hope you find this small tip useful

Restore MySQL Database from FileSystem Backup

Always backup your  MySQL database with mysqldump but if you didn’t you can restore it from file system.

If your backup include the /var/lib/mysql directory, if so then you should be able to restore the database. Each database is contained in a separate subdirectory off /var/lib/mysql, so look for one named with the name of your database (WordPress or any other). To restore it, shutdown the mysql server first

sudo /etc/init.d/mysql stop

Copy the backup-ed directory into the same location on your new server, then restart mysql server

sudo /etc/init.d/mysql start

Note:- that its much better to take actual database dumps using the mysqldump command than to rely on this method. so for the future, you should schedule something like this:

mysqldump -h host -u user -ppassword --databases database1 database2 > myfile.dump


Disk Management in Windows 2012 R2

In Windows Server 2012 R2 I to find the option to reassign the drive letter for a CD/DVD drive where the disks are normally managed Run diskmgmt.msc just like previous versions of Windows.