Spring Batch With Spring Boot

http://ashismo.github.io/java-spring/2017/05/16/Spring-Batch-with-Spring-Boot

Java Generic Type & get-put principle

https://stackoverflow.com/questions/1292109/explanation-of-the-get-put-principle

Java 8: java.time.*

https://www.mkyong.com/spring-boot/spring-boot-spring-data-jpa-java-8-date-and-time-jsr310/

RRD Tool

http://www.study-area.org/tips/rrdtool/rrdtool.html

http://ycfu.blog.mypc.tw/2008/05/rrdtool.html

http://blog.csdn.net/jndxjing/article/details/8014410

SQL Server Data Format

1.   Get Date in a format such as: 2017/09/11

CONVERT(char(10),DATEADD(day,-(1),GETDATE()) ,111) AS Date

Select Into v.s. Insert into From

1. Select Into

Create a new table in the destination database
select * into sif.dbo.callDetail from I3_IC.dbo.calldetail_viw;

2.  Insert into From

Insert into existing table, column needs to assigned explicitly. * may not work in some databases.

INSERT INTO table2 (column1, column2, column3, ...)
SELECT column1, column2, column3, ...
FROM table1
WHERE condition;

Pentaho Data Integration (Kettle)

http://ithelp.ithome.com.tw/articles/10186567