Clam Antivirus

Looking for free antivirus for Windows ? Look no more. Clam Antivirus is available at no cost.

 

Excel file size extremely huge

Been having problem with Excel file size whenever saving a workbook with lots of formula converted to values. A small file with formula of less than 30KB can grow to as big as 13MB.

Found a solution to this. Download  Microsoft Excel Excess Formatting Cleaner Add-in.

Instant Email Account, Simple & Practical

Need a temporary email account with instant access without going through the hassle of registration, verification, filling in forms ? Try  http://no-spam.ws

SQL 2008 LDF too huge

One of my SQL 2008 database transaction log file (LDF) is growing bigger each day, taking up almost 350GB of disk space.  Found a great write up from André van de Graaf  which helps. Follow his solution in this link. Click here.

Great Open Source Software

Some free software directory here - http://directory.fsf.org/wiki/Main_Page

Go Back On Time

How To Check MAC Address

The simplest & easiest way to check or find a MAC Address of a computer hardware such Network Card is to :

1. At command prompt, PING the IP address of the network card.
2. Issue command -> ARP -a

The File Is Corrupt And Cannot Be Opened

Been getting the error " The file is corrupt and cannot be opened " in Outlook 2010. This happened to all Excel attachment in Office 2010.

Thanks again to the power of Net, the solution :

1. Launch Excel 2010.
2. Click FILE - OPTIONS - TRUST CENTER - TRUST CENTER SETTINGS.
3. Click PROTECTED VIEW. Unchecked the options :

- enable protected view for files originating from the internet
- enbable protected view for files located in potentially unsafe locations
- enable protected view for outlook attachments

4. Click OK - OK.
5. Exit Excel.