Monday 18 May 2015

Saturday 2 May 2015

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




Thursday 23 April 2015

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/

Tuesday 21 April 2015

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


TerminologyOracleSQL Server

schemadatabase

service namedatabase name

System ID (SID)database name
Storage blockpage
Extentuser-definedfixed at 8 pages
Storage management pages (SMP)dictionary or locallocal only
Metadatadata dictionarySYS database
Recursive SQLconnect by clauseHierarchyID data type
LanguagePL/SQLT-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;

 

Wednesday 21 January 2015

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.

Sunday 18 January 2015

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.


l1000.jpg