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.