Categories
How to : MySQL

How to get the size of MySQL Databases?

SELECT table_schema “ohmygoh”,
sum( data_length + index_length ) / 1024 / 1024 “Data Base Size in MB”,
sum( data_free )/ 1024 / 1024 “Free Space in MB”
FROM information_schema.TABLES
GROUP BY table_schema ;

Categories
Windows

Fastest way to remove all hyperlinks in Excel

The fastest way is you will need to create a macro to delete the hyperlinks in your Excel.

Step 1:  Create a new Macro. Go to View > Macros > Record Macro…


Step 2:  Enter a Macro name “removehyperlinks”.

 Step 3:  Edit Macro. Go to View > Macros > View Macros… And then click on Edit button.

 Step 4:  Insert/Paste fomular code into your  Macro as following figure:

     ActiveSheet.Hyperlinks.Delete

After inserted the code, go back to the sheet of Microsoft Excel, Views > Macros > Stop recording…

 Step 5:  Run the Macro. Go to View > Macros > View Macros… And then click on Run button.

Result:

 

Categories
Windows

Screen Capture Utilities

  1. FastStone Capture : Shareware. FastStone Capture is a powerful, lightweight, yet full-featured screen capture tool that allows you to easily capture and annotate anything on the screen including windows, objects, menus, full screen, rectangular/freehand regions and even scrolling windows/web pages. You can choose to send captures to editor, file, clipboard, printer, email, Word/PowerPoint document or upload them to your website. Editing tools include annotating (texts, arrowed lines, highlights), resizing, cropping, sharpening, watermarking, applying edge effects and many more. It also allows you to record screen activities and sound into highly compressed video files. Other features include global hotkeys, automatic filename generation, support for external editors, a color picker, a screen magnifier and a screen ruler.
  2. PicPick : FREE. PicPick is user friendly and full of features for creating your image, suitable for software developers, graphic designers and home users.
    It is an all-in-one program that provides a full-featured screen capture tool, an intuitive image editor, a color picker, a color palette, a pixel-ruler, a protractor, a crosshair and even  a whiteboard.
  3. HyperSnap : Shareware. HyperSnap is the fastest and easiest way to take screen captures from Windows screen and full screen games, and text capture (TextSnap™) from places where normal text copy is not possible. HyperSnap combines the power of a first-class screen capture application with an advanced image editing utility – wrapped into one easy-to-use tool!
Categories
Windows

Synchronize data between PCs, Laptops, or thumbdrives

  1. Allway Sync : It uses innovative synchronization algorithms to synchronize your data between desktop PCs, laptops, USB drives, remote FTP/SFTP servers, different online data storages and more. Encrypted archives are supported. Allway Sync combines bulletproof reliability with extremely easy-to-use interface.
Categories
Windows

Clean Up Windows Utilities

  1. ShellExView v1.70– Shell Extensions Manager : Shell Extensions are in-process COM objects which extends the abilities of Windows operating system. Most shell extensions are automatically installed by the operating system, but there are also many other applications that install additional shell extension components. For example: If you install WinZip on your computer, you’ll see a special WinZip menu when you right-click on a Zip file. This menu is created by adding a shell extension to the system.The ShellExView utility displays the details of shell extensions installed on your computer, and allows you to easily disable and enable each shell extension.
  2. Driver Cleaner
  3. index.dat Cleaner
  4. system cleanup
  5. Eraser : Eraser is an advanced security tool for Windows which allows you to completely remove sensitive data from your hard drive by overwriting it several times with carefully selected patterns.
  6. Starter : Starter allows one to view and manage all the programs that are starting automatically whenever operating system is loading. It enumerates all the hidden registry entries, startup folders’ items and some of the initialization files, so that the user could choose to temporarily disable selected entries, edit them, create new, or delete them permanently.  Secondary purpose is to list all the running processes with possibility to view extended process’ information (such as used DLLs, memory usage, thread count, priorities etc.), and to terminate selected process.
Categories
How to : Windows

How to restore when hard disk corrupted?

When you are not able to restart your Windows, and most of the time is boot system files currupted, the “BEST” way to do is “Format“, but what about your data which not yet backeup?

Try below solutions before you format your hard disk (Windows XP installed):

  1. MBR : Insert Windows Installer CD > Press R to Recovery > Dos mode screen appear (Recovery Console), type “Fixmbr” after C:\Windows >Press Enter > Enter Y when warning message appear > Done.
    * MBR = Master Boot Record. 它是在硬碟的第0軌的一個記錄,其中包含了啟動電腦系統所需要的程式碼。
  2. NTLDR:  Insert Windows Installer CD > Press R to Recovery > Dos mode screen appear (Recovery Console), type “Fixboot” after C:\Windows >Press Enter > Enter Y when a notification message appear > Done.
    * If you able to logon to Windows, Right click My Computer >Properties >Advance > Startup & Recovery > Settings > Choose the system that you want to fix.
    * If you see “NTDLDR is missing.” message, normally this message appear when you hard disk installed more than one Windows, so it caused error when another Windows systems have been deleted or modified.

 

Categories
Windows

Font Viewer Utilities

  1. Font Viewer : Font Viewer renders all installed font families in a scrollable grid view, and allows you to change the size, color, background-color and displayed text, all at the touch of a button. Its built-in listing feature lets you select fonts and store their names in a readable and easily-accessible format.
    You can also export your list to a text file (.txt) or a FontViewer file (.fv) for use at a later date. Additionally, you can export your font list to an Adobe Acrobat PDF file (.pdf), with all of the styles and settings applied.
    Support UTF-8, like chinese font types.
Categories
Windows

極速提升Windows XP效能

極速提升Windows XP效能:

  1. 刪除華麗畫面:
    Start > My Computer > Right click Property >> Advance
  2. 加快選單顯示速度
    Start Menu
    Start > Run > Enter “regedit.exe” > HKEY_CURRENT_USER\Control Panel\Desktop >
    MenuShowDelay > Change 400 to 0
  3. 加快自動更新率
    Start > Run > Enter “regedit.exe” > HKEY_CURRENT_MACHINE\System\CurrentControlSet\Control\Update > Change 400 to 0
  4. 寬頻上網高速化
    Start > Run > Enter “regedit.exe” > HKEY_CURRENT_MACHINE\System\CurrentControlSet\Services\Tcpip\Parameters > Parameters > Change 400 to 0
  5. 縮短XP開關機時間
    Start > Run > Enter “regedit.exe” > HKEY_CURRENT_MACHINE\System\CurrentControlSet\Control\SessionManager\MemoryManagement\Prefetch Parameters>
  6. 定期磁碟重組
    Defragment
Categories
Freeware Microsoft

Share your mouse and keyboard between multiple computers

  1. Synergy: Synergy lets you easily share your mouse and keyboard between multiple computers on your desk, and it’s Free and Open Source. Just move your mouse off the edge of one computer’s screen on to another. You can even share all of your clipboards. All you need is a network connection. Synergy is cross-platform (works on Windows, Mac OS X and Linux).
  2. Multi Monitor Mouse (M3) : M3 allows for conventional control of the mouse within each monitor’s screen, while permitting immediate warping across monitors when desired to increase mouse traversal speed.
Categories
Freeware Microsoft

Do you need a Skype Recording Software when you are not around?

  1. SAM Skype Answering Machine: SAM is a simple voice answering machine for Skype users. When you are away from your PC and there is no one to answer your incoming Skype calls, KishKish SAM will pick up the call, play a greeting message and the all-time classic beep, so the calling party will leave a voice recorded message. Now SAM does even more. SAM will play a Video Greeting of your choosing while recording the voice message.
  2. Pamela for Skype: A versatile and easy to use Skype audio and video recording software. Supported platforms: XP/Vista/7 (32/64-bit).