Moving cursor on iPad

• 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

• 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

多種事 多種説

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

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

Macbook Air Enable closed-display mode

• 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

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

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

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

• 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

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

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

Intro to Unreal Engine for VR

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

Excel on Mac/Windows - linebreak in cell

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

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

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)

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

"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

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

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

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

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.