Clone existing git over new Repo

It is good for us to start from something existing or build on top of existing repo if there is any similar to what we’re looking for rather than build from sketch. I know we can easily to download existing source and directly git add . to you brand new repo. But this will lost all commit history from original author. Usually that is good practice also to remain all the commits history from the day 1. By adding new remote then force push basically this can remain all the previous history.

git clone repo.git
git remote add openshift repo2.git
git commit -a -m "message"
git push
git push openshift master --force

Date Different

Do you know that you can actually use Excel to calculate different between 2 date values? Also use Excel to easily find 100 days after a certain date.

Example 1 – Different between two dates

A1 = 2017-01-01
B1 = 2017-03-01
C1 = B1-A1
   = 59 days

Example 2 – When is after 100 days?

A1 = 2017-01-01
B1 = 100
C1 = A1+B1
   = 2017-04-11

Install AdventureWork Data Warehouse 2014

Install AdventureWork Data Warehouse 2014

Create AdventureWorkDW Database

  1. Download Adventure Works 2014 Warehouse
  2. Unzip to C:\Program Files\Microsoft SQL Server\120\Tools\Samples\Adventure Works 2014 Warehouse Script\
  3. SQL Management Studio > Connect to MSSQL Server > Run instawdbdw.sql.

Deploy Cube

  1. Download AW Multidimensional Models SQL Server
  2. Open solution AWDW2014Multidimensional-EE.sln in SQL Server Data Tools (Visual Studio).
  3. Modify AdventureWorksDW2014.ds to using your local settings.
  • Connect to the server where you create AdventureWorkDW and point to AdventureWorkDW database by test connectstring.
  • Enter impersonation information as appropriate.
  1. Right click project > Deploy > Set server and cube name.
  2. Deploy.

see Readme for Adventure Works DW 2014 Multidimensional Databases.docx

Print CD Cover

You can easily to print CD cover by using Inkscape.

  1. File > New > CD Cover.
  2. Draw a circle with 340x340pt.
  3. Import the image you want to print into circle shape.
  4. Choose image and circle.
  5. Menu > Object > Clip > Set.
  6. Done.

Of course that is much more easier for you to print out on a A4 paper and draw a circle with your CD then cut the paper by following the circle line.


Gitlab Supports Math Notation

I found out a new changes in gitlab. We’re now can edit math formula in any issue comment or wiki page, so convenient! And no excuse of miscommunication anymore, hehe…

see more Mathematics supports for Markdown and AsciiDoc, using Katex

Gitlab not support all the latex syntax yet, there are working on that. The subset of latex using is called Katex which you can try to input from here to preview.

Braille Code on Coway Water Filter

My office purchased a new Coway water filter last year and it just next to me 10 feet away (straight line). The moose code (braille code) actually has been trouble me sometimes. I know that must be meaning of hot & cold water however I couldn’t prove it.

Until today finally I able to decode what is the braille code on the Coway water filter. It actually was curved in Korean version of braille code means cold & hot water. It written in Korean not English. So you have to decode using Korean braille code but not English braille code.

Conclusion, the braille code on Coway machine can be used by all non blind people and Korean blind people only.

Decode Work

운수 (on su) = hot water
냉수 (naeng su) = cold water

see also