2017年6月21日 星期三
The road ahead for WebLogic 12c
http://biemond.blogspot.tw/2013/10/the-road-ahead-for-weblogic-12c.html
2017年6月15日 星期四
Pollexsurvey data creation
1. Create data with excel template
2. Copy & paste to SQL Server Managment studio
3. Insert into local mysql database (Link server need to be configured in advance)
INSERT OPENQUERY(MYSQLLOCAL,'SELECT * FROM pollexsurvey.pls_respondent') SELECT * FROM pls_respondent WHERE uid > 4280;
INSERT OPENQUERY(MYSQLLOCAL,'SELECT * FROM pollexsurvey.pls_respondent_role') SELECT * FROM pls_respondent_role WHERE respondent_uid > 4280;
INSERT OPENQUERY(MYSQLLOCAL,'SELECT * FROM pollexsurvey.pls_respondentdetail_extsat2017') SELECT * FROM pls_respondentdetail_extsat2017 WHERE uid > 4280;
4. Delete data of earlier batches
delete from pollexsurvey.pls_respondent WHERE uid <=4280;
delete from pollexsurvey.pls_respondentdetail_extsat2017 WHERE uid <=4280;
delete from pollexsurvey.pls_respondent_role WHERE respondent_uid <=4280;
select count(*) from pollexsurvey.pls_respondent;
select count(*) from pollexsurvey.pls_respondentdetail_extsat2017;
select count(*) from pollexsurvey.pls_respondent_role;
5. Export the SQL
2. Copy & paste to SQL Server Managment studio
3. Insert into local mysql database (Link server need to be configured in advance)
INSERT OPENQUERY(MYSQLLOCAL,'SELECT * FROM pollexsurvey.pls_respondent') SELECT * FROM pls_respondent WHERE uid > 4280;
INSERT OPENQUERY(MYSQLLOCAL,'SELECT * FROM pollexsurvey.pls_respondent_role') SELECT * FROM pls_respondent_role WHERE respondent_uid > 4280;
INSERT OPENQUERY(MYSQLLOCAL,'SELECT * FROM pollexsurvey.pls_respondentdetail_extsat2017') SELECT * FROM pls_respondentdetail_extsat2017 WHERE uid > 4280;
4. Delete data of earlier batches
delete from pollexsurvey.pls_respondent WHERE uid <=4280;
delete from pollexsurvey.pls_respondentdetail_extsat2017 WHERE uid <=4280;
delete from pollexsurvey.pls_respondent_role WHERE respondent_uid <=4280;
select count(*) from pollexsurvey.pls_respondent;
select count(*) from pollexsurvey.pls_respondentdetail_extsat2017;
select count(*) from pollexsurvey.pls_respondent_role;
5. Export the SQL
2017年5月2日 星期二
personal appraisal v.s. agile development
https://www.scrumalliance.org/community/articles/2017/april/why-scrum-and-kpis-dont-mix
https://scrumology.com/how-to-do-agile-performance-reviews/
http://www.agilelearninglabs.com/2012/05/agile-performance-reviews-2/
https://scrumology.com/how-to-do-agile-performance-reviews/
http://www.agilelearninglabs.com/2012/05/agile-performance-reviews-2/
2017年4月25日 星期二
Making OpenNMS highly available
https://wiki.opennms.org/wiki/Making_OpenNMS_highly_available#Making_OpenNMS_highly_available
OpenNMS general blog
https://www.adventuresinoss.com/category/opennms-general/
http://opennms.530661.n2.nabble.com/How-to-manually-define-a-topology-Map-1-12-X-td7585315.html
https://www.adventuresinoss.com/2016/01/22/opennms-at-scale/
https://github.com/j-white/opennms-events-stress-tools/tree/master/udpgen
https://searchcode.com/codesearch/view/33906804/
http://opennms.530661.n2.nabble.com/How-to-manually-define-a-topology-Map-1-12-X-td7585315.html
https://www.adventuresinoss.com/2016/01/22/opennms-at-scale/
https://github.com/j-white/opennms-events-stress-tools/tree/master/udpgen
https://searchcode.com/codesearch/view/33906804/
Customizing the OpenNMS home screen
http://jumboframe.net/jumboframe/customizing-the-opennms-home-screen
2017年4月23日 星期日
IMS service profile
http://theimslantern.blogspot.tw/2007/07/ims-service-routing-service-profile.html
訂閱:
文章 (Atom)