myLearning

Moving cursor on iPad

2017-08-20T17:07:00.001-04:00

when you are editing the text, touch the screen with two fingers and wait for a bit when the screen is changed and start moving, the cursor will move according to your fingers
if you hold for a longer time, it will change to the selecting mode and you can select the text by moving your fingers

Excel - reset the last cell on a worksheet

2016-06-06T10:17:00.001-04:00

To select all columns to the right of the last column that contains data, click the first column heading, press <ctrl><shift><right>
To select all rows below the last row that contains data, click the first row heading, press <ctrl><shift><down>
On the Home tab, in the Editing group, click the arrow next to the Clear button, and then click Clear All
Click the Microsoft Office Button , and then click Save
Click the Microsoft Office Button , and then click Close
When you open the workbook again, the last cell of the data should be the last cell on the worksheet

多種事多種説

2016-06-05T17:43:00.001-04:00

急事，慢慢的説
大事，清楚的説
小事，幽默的説
沒把握事，謹慎的説
沒發生事，不要胡説
做不到事，別亂説
傷害人的事，不能説

討厭的事，對事不對人説
開心的事，看場合説
傷心的事，不要見人就説
別人的事，小心的説
自己的事，聽聽自己的心怎麼説
現在的事，做了再説
未來的事，未來再説

Macbook Air Enable closed-display mode

2016-05-06T09:31:00.002-04:00

connect to an external monitor and using the AC power adapter or

having an external mouse or keyboard attached...

more info

Print to Google Cloud Printer on Mac

2016-04-01T11:52:00.001-04:00

Assume the Google Cloud Printers have been setup...

Download Cloud Printer for Mac from here:
http://www.macupdate.com/app/mac/40510/cloud-printer

Add the Print Plugin
https://www.youtube.com/watch?v=FuPQGD5z9IE

Export Word Doc to PDF with Word for iPad

2016-03-28T09:20:00.001-04:00

In the Word document:

Click the Share (right) icon (the one with a person and a + sign)
Select "Send Attachment"
Select "PDF"
Select "Send a Copy"
Here I found a few useful options, send to Google Drive (may need to click "More" to enable it), Gmail and "Save to Dropobox", etc.

iPad connects to weak WiFi network

2016-03-18T08:43:00.001-04:00

I found one very interesting fact... my work place has a very weak public WiFi. My iPad normally doesn't able to see and connect to it. But once I connect a Bluetooth device (either my MacBook Air or even just a bluetooth keyboard), I am able to connect to this WiFi network.

Uninstall / Remove FxFactory Product

2016-02-25T18:56:00.002-05:00

Start FxFactory (5.0.9)
Actions >> Show Products in Finder
It will show two windows

Users>'user name'>Library>Application Support>FxFactory
Library>Application Support>FxFactory

Move the product to the Trash (type in your password)

Normally, it will have more than one files

It will disappear right away in the Installed tab

How to Use Exposure Compensation to Take Control of Your Exposure

2016-02-18T09:17:00.003-05:00

http://digital-photography-school.com/how-to-use-exposure-compensation-to-take-control-of-your-exposure/

Aperture Priority Mode – In Aperture Priority mode, exposure compensation changes the shutter speed. Remember that in this mode, you set the aperture and the camera sets a corresponding shutter speed. If you change the Aperture, your camera just sets another corresponding shutter speed, and there is no change in the exposure level. Exposure compensation gives you the ability to change the shutter speed (and the overall exposure value) while staying at the same aperture you originally set.

Shutter Priority – In Shutter Priority mode, exposure compensation changes the size of your aperture. It is basically the reverse of Aperture Priority mode. You set a shutter speed, and the camera sets a corresponding aperture. Exposure compensation therefore changes the exposure by allowing you to change that aperture size.

Fix Frozen Frames in Final Cut Pro X Drop Zones – Izzy Video #312

2016-02-17T21:59:00.002-05:00

http://www.izzyvideo.com/final-cut-pro-x-drop-zones-frozen/

Intro to Unreal Engine for VR

2016-02-11T11:05:00.002-05:00

https://channel9.msdn.com/blogs/misslivirose/Intro-to-Unreal-Engine-for-VR

Excel on Mac/Windows - linebreak in cell

2015-05-18T17:59:00.002-04:00

On Mac - control-option-return

On Windows - alt-return (or alt-enter)

Setup HP ProLiant ML310e Gen8 v2 Server - Install OS (Windows Server) with Intelligent Provisioning

2015-05-02T13:24:00.000-04:00

I have the Windows 2012 R2 installation on USB drive. I have installed a single 320GB HD. I boot up the server but cannot from the USB to install the OS, some driver(s) will not be available.

Start the server
Press <F10> to Start Intelligent Provisioning (when the options are shown)
Click on "Configure and Install"
Step 1 Hardware Settings, Continue (use default)
Step 2 OS Selection (select the OS, Install Method and Source Media), Continue

the Source Media options

Disc
Network Share
FTP
USB

Locate OS installation File, Continue

For USB, open usb-sdb1

OS Info

Enter Admin Password (optional)

Continue to start the installation

Update firmware
Copy OS files

Reboot
OS Installation
Restart a few times

Lightroom Presets

2015-04-23T09:12:00.000-04:00

Installing new presets

Start Lightroom
Open up the presets on the left (in Develop mode)
All the adobe presets start with "Lightroom ..."
Create new folder for the new presets (optional), otherwise, lightroom will put new presets in "User Presets" folder. This is your way to group the presets.
Right click on the folder and select "Import"
Go to the location of your downloaded presets and import them (remember to unzip the zip file to get the preset files .lrtemplate)
You can move the preset from one folder to the other
Right click on the imported preset and select "Show in Finder"
You can import the new presets, create new folder from here (need to restart Lightroom to see the result)
You cannot create sub-folders and if you create sub-folder manually in the finder, the sub-folder will appear as a folder in lightroom

Free Presets

http://seimeffects.com/2011/11/04/silver-shadows-2-free-lightroom-presets/
http://www.presetsheaven.com/presets/28-free-lightroom-presets-from-chris/
http://www.deliciouspresets.com/shop/lightroom-presets/free/

Presets Heaven : Offers presets and training!
Wonder Land Presets : Packages with over a dozen free presets!
On One Software : Fantastic package of 85 presets!
Inside Lightroom : Color, black and white, and calibration presets.
Gantico : Releases a new set of presets every few months.
Lightroom Blog : A variety of user presets.
640 Pixels : A package of 15 color, black and white, and split tone presets.
XEQUALS : Really fun site that connects users through presets!

Tips for using Oracle (for beginner)

2015-04-21T09:43:00.000-04:00

Useful SQL statements

get all the tables

SELECT * FROM TAB ORDER BY TNAME

get all the columns

select * from col where tname = '<table name>' ORDER BY colno

Return Top n records (Select Top 1 * in MS SQL)

SELECT column_name(s)
FROM table_name
WHERE ROWNUM <= number;

Concatenation Operator

IF THEN ELSE ELSIF END IF example

     IF (...) THEN
          ...;
     ELSIF (...) THEN
          ...;
     ELSE
          ...;
     END IF;

GetDate() (in MS SQL)

sysdate

Table DUAL

A dummy table with a single record used for selecting when you're not actually interested in the data, but instead want the results of some system function in a select statement:

select sysdate from dual;

Sequence

Open
to see the defination (Last number too)
Get next value
<sequence_name>.NEXTVAL;

INSERT INTO <table>
(<col1>, <col2>)
VALUES
(<seq_name>.NEXTVAL, 'xxx');

you can't use CURRVAL until you have used NEXTVAL at least once in your session.

Data Types

No boolean data type
varchar2 (2K, Oracle8 4K)
number(5,2) - 999.99

Terminology

Terminology	Oracle	SQL Server
	schema	database
	service name	database name
	System ID (SID)	database name
Storage	block	page
Extent	user-defined	fixed at 8 pages
Storage management pages (SMP)	dictionary or local	local only
Metadata	data dictionary	SYS database
Recursive SQL	connect by clause	HierarchyID data type
Language	PL/SQL	T-SQL

For Loop and with / as a Cursor

FOR i IN 1..10
LOOP
...
END LOOP;

--------------------------------
FOR iRec IN (SELECT * FROM <table> WHERE <field> = <value>)LOOP
...
END LOOP;

--------------------------------
CURSOR <cursor name> IS
    <sql statement>

BEGIN
    FOR <item> IN <cursor name>
        LOOP
            ...
        END LOOP;
END;

--------------------------------
can pass a parameter:

CURSOR <cursor name> (<parameter> VARCHAR2) IS
    <sql statement>
BEGIN
    FOR <item> IN <cursor name>(<parameter>)
        LOOP
            ...
        END LOOP;
END;

Challenges of Life

2015-01-21T14:18:00.001-05:00

"Great faith is a product of great fights. Great testimonies are the outcome of great tests. Great triumphs can only come out of great trials" - Smith Wigglesworth.

iPad Air Lightning to HTMI adaptor

2015-01-18T11:49:00.002-05:00

If you have problem with the Apple Lightning To Hdmi Cable, try to plug it in the other way. I found that I need to plug it upside down.

Photography - Close up

2014-12-08T14:33:00.001-05:00

Don't cut off body parts except at the mid chest, waist or mid thigh region.

http://www.izzyvideo.com/close-up-shot/

medium close up (MCU) - cut at waist, show hands movement, with head room above the head
close up (CU) - at the chest, with head room
head and shoulder close up
head close up (big head close up)
choker close up - the face only
extreme close up - the mouth only

Sunny 16 rule

2014-12-08T14:11:00.001-05:00

If it's a sunny day, set aperture to f/16 and shutter speed closest to the reciprocal of yout ISO.

ISO 50, 1/60 sec
ISO 100, 1/125 sec
ISO 200, 1/250 sec, etc.

Use f/16 for sunny settings, but go down for less bright conditions:

f/11 for cloudy daylight
f/8 for overcast
f/5.6 for outdoor shade
f/4 for dark shade

Dos and Don’ts for Shooting the Moon

2014-12-04T16:12:00.002-05:00

Do use a tripod

Don’t use a slow shutter speed

The moon is actually moving very quickly around the earth at a speed of 2,288 miles per hour (3,683 kilometers per hour). Because of the moon’s speed and the long focal length necessary to capture an image of the moon, you need to use the fastest shutter speed possible. A good rule of thumb for tack sharp moon photos is nothing slower than 1/125th of a second.

Do use a telephoto lens

To successfully shoot any kind of detail of the moon in your image, you need at least a 300mm telephoto. For a full frame image, you will need around an 800mm lens.

Don’t use any filters on your lens

Do try the Looney 11 rule

The Looney 11 rule is similar to the Sunny 16 rule. Set your f-stop to f/11, then match the shutter speed to your ISO.

With ISO 100, set the shutter speed to 1/100 or 1/125 second
With ISO 200, set the shutter speed to 1/200 or 1/250
With ISO 400, set the shutter speed to 1/400 or 1/500, etc.

Don’t touch the camera to start your exposure

Using a cable release or remote trigger is the best way to start your exposure. If you don’t have either of these gadgets, use the self-timer feature on your camera to begin your shot.

Do use Mirror Lock-up

If your camera gives you the option to lock up your mirror this can greatly increase your chances of getting a tack sharp image.

Don’t use Image Stabilization

Canon’s IS (Image Stabilization) or Nikon’s VR (Vibration Reduction) must be turned off anytime your camera is on a tripod.

Do know the cycles of the moon

The Photographer’s Ephemeris will not only give you the phases of the moon, but also show you when and where the moon will appear in the sky. By far the most photographed stage is the full moon, which is also the brightest and the most difficult to expose correctly. The side lighting of the Gibbous stage produces some interesting shadows which may allow you to capture craters and mountains. The crescent moon is, of course, the darkest stage, but one which may create some interesting effects when added to a nighttime landscape.

Don’t always place the moon in the center

Don’t just put the moon in the center of your image with nothing else – it’s been done a million times before and there is nothing exciting about this. Try to include other objects in the frame with the moon.

Don’t just place the moon in an empty sky. Including a foreground object will create a more dramatic image.

Do switch to manual focus

Don’t just shoot the moon at night

The best time for photographing the moon is just after it rises or just before it sets, when it is very low in the sky. When the moon is near the horizon, it is closest to Earth and will appear larger in your images. Also, as the full moon rises the sun will be setting, and as the full moon sets the sun will be rising. This may give you great lighting to include or accentuate foreground or landscape objects. Shooting the moon in the day time will give you opportunity to include foreground objects, and you also may be able to capture some craters on the moon’s surface.

The June full moon, called the “Honey Moon”, captured as it sets at sunrise.

Do use exposure bracketing

After you are satisfied with the exposure you have dialed in, bracket two stops under and two stops over, just to ensure that you get an exposure you will be happy with later.

Don’t use Auto White Balance

Using auto white balance will give you very inconsistent results. What is the source for the light of the moon? That’s right, the sun! So try daylight white balance, but if you are looking for a different effect, try tungsten or cloudy.

Don’t depend on your meter

Most likely your camera’s light meter will be fooled by the amount of light reflecting off the moon. Also it is important to note that as the moon rises, the exposure will continual change. It gets brighter as it rises, so you need to keep adjusting your shutter speed.

Five Things You Don’t Need To Include On Your Resume

2014-12-03T11:08:00.003-05:00

Every Job You’ve Ever Held
Starting and Ending Months for Your Past Positions
Your Tasks and Duties at Each Job
Your Exact Job Title, If It’s Confusing
Any Indication of Your Age

http://news.monster.com/a/other/five-things-you-dont-need-to-include-on-your-resume-33cc5d?WT.mc_n=CRM_US_B2C_LC_JOM_Act_D_141203

Remove MS SQL Server Instance

2014-10-09T09:03:00.001-04:00

This is the example in Windows 7 with MS SQL Server 2012

Control Panel
Program and Features
Select "Microsfot SQL Server 2012 (64-bit)"
Click "Uninstall/Change"
Click "Remove"
Click "OK"
Select the instance to remove in the drop down box, click "Next >"
Check the features (will show all available features installed for this instance) to remove

Database Engine Services
Reporting Services, etc.

Click "Next >"
Click "Next >"
Click "Remove"
Click "Close"

https://www.youtube.com/watch?v=ugkP3Wt850c

Getting Mac OS version in a disk image

2014-10-05T15:36:00.004-04:00

You can get the version in this file:

/System/Library/CoreServices/ServerVersion.plist

<key>ProductUserVisibleVersion

<string>

Custom Thumbnail for YouTube video on a Mac

2014-09-28T18:01:00.000-04:00

Instead of using the default three thumbnails from YouTube, you can use any part of the video as the thumbnail:

Play the video using any player stop at the spot you want it as the thumbnail
Press <command><shift>4 and then <spacebar>
Click on the player window
Save the image on DropBox (optional, but very handy)
Upload to YouTube

6 Ways to Take WOW Photos in Less Than an Hour

2014-09-23T16:18:00.004-04:00

In summary:

Method One: Bird’s Eye View
Method Two: Worms Eye View
Method Three: Shoot at an Angle
Method Four: Get the Sun Behind Your Subject
Method Five: Use Shadows
The Ultimate WOW Shots

The ultimate WOW shots are created when you use one of more of these techniques by combining elements, angles, and points of view.

http://digital-photography-school.com/6-ways-to-take-wow-photos-in-less-than-an-hour/