Monday, August 22, 2016

7 Alternative Painting Apps

Easy Paint Tool SAI

Created by the Japanese company Systemax Software, SAI is one of the go-to softwares for many indie artists. It’s a lightweight and compact tool, and unlike other digital painting tools, it doesn’t greedily hog all of your RAM/CPU.

http://www.clipstudio.net/en/purchase/trial

http://www.hongkiat.com/blog/painting-apps-for-digital-artists/


Saturday, June 11, 2016

How can I enable the insert rows option in my Microsoft Excel 2010

How can I enable the insert rows option in my Microsoft Excel 2010?

Try this:
From your worksheet, press Alt + F11.   careful, that's ALT + F11
Next press Ctrl+G
Type in (or copy here and paste)
Application.CommandBars("Cell").Reset
Then press the Enter key.
Press Alt+Q to return to the worksheet.
Click your right mouse button on any worksheet cell.   Does your right click menu appear now?

Tuesday, March 29, 2016

Perform defrag in Windows 10 SSD or HDD

http://www.tenforums.com/tutorials/8933-optimize-defrag-drives-windows-10-a.html

in the command prompt, type the command you want to use below, and press Enter.

Commonly Used Commands:

 defrag C: /O
NOTE: Substitute C: in the command with the drive letter you want instead.

 defrag /C /O
NOTE: For all HDDs and SSDs.


Syntax:

defrag | /C | /E [] [/H] [/M [n] | [/U] [/V]] [/I n]

Where is omitted (traditional defrag), or as follows: /A | [/D] [/K] [/L] | /O | /X

Or, to track an operation already in progress on a volume: defrag /T

Parameters:

ValueDescription
/APerform analysis on the specified volumes.
/BPerform boot optimization to defrags the boot sector of the boot volume. This will not work on a SSD.
/CPerform the operation on all volumes.
/DPerform traditional defrag (this is the default).
/EPerform the operation on all volumes except those specified.
/HRun the operation at normal priority (default is low).
/I nTier optimization would run for at most n seconds on each volume.
/KPerform slab consolidation on the specified volumes.
/LPerform retrim on the specified volumes. Only for a SSD.
/M [n]Run the operation on each volume in parallel in the background. At most n threads optimize the storage tiers in parallel.
/OPerform the proper optimization for each media type.
/TTrack an operation already in progress on the specified volume.
/UPrint the progress of the operation on the screen.
/VPrint verbose output containing the fragmentation statistics.
/XPerform free space consolidation on the specified volumes.

To Analyze Current Optimization of Drive

A) Type the command below into PowerShell, press Enter, and go to step 7 below.

 Optimize-Volume -DriveLetter  -Analyze –Verbose

Note   Note
Analyzes the volume specified for fragmentation statistics. Performs analysis only and reports the current optimization state of the volume.

Substitute  in the command above with the actual drive letter you want to analyze.

For example: Optimize-Volume -DriveLetter C -Analyze -Verbose

Saturday, March 12, 2016

Windows 7 Updates

This issue has come and gone over the years with different fixes along the way, so here is my updated guide to this issue as of this date January 5th, 2016
This is what I do when I reinstall W7with SP1 or have issues with Windows update stuck on checking for updates.
If Service Pack 1 is not installed, install it before following this guide.
Download KB-3102810 and save it where you can find it later
Download SUR Tool save it to same place
Restart the PC and disconnect from internet before Windows loads, this is important because at every boot windows will check for updates in the background and this will start the checking for updates hang all over again and will prevent the install of the downloaded packages until it finishes checking, so disconnecting from the internet before Windows loads prevents this.
Once booted install KB-3102810, if reboot is required do so and stay disconnected from internet.
Now install the SUR Tool package, this is a big package and will install many updates along with cleaning up and repairing the Windows update store. It will also cut down on how many more Windows updates will need to be installed later.
After install of SUR package reboot, connect to insternet and do a manual Windows Update, it should work much faster now. Even after these fixes I have seen some W7 PC's take up to an hour to finish checking for updates if launched from Control Panel manually.
If you have other Windows updates issues and the 2 updates above are installed, download this Microsoft Windows Update fixit tool (right click "save link as") run it and select aggressive mode to completely reset Windows updates. Reboot and try Windows Updates from the Control Panel