Dean's Blog

2013年10月2日星期三

Solr–Indexing pdf files

http://wiki.apache.org/solr/ExtractingRequestHandler

2013年9月23日星期一

Authenticating in Spring Security with password and username in url

http://www.coderanch.com/t/557314/Spring/Authenticating-Spring-Security-password-username

2013年9月21日星期六

遠端桌面服務的安全性設定

http://blog.xuite.net/misgarlic/weblogic/74060435

2013年9月16日星期一

Jmeter

http://systemsarchitect.net/benchmark-your-software-with-jmeter/
http://www.anujgakhar.com/2010/06/23/stress-testing-your-website-with-apache-jmeter/
http://imsardine.simplbug.com/note/jmeter/jmeter.html
http://jmeter-expert.blogspot.tw/2010/03/how-apache-jmeter-simulates-multiple.html
http://jmeter.512774.n5.nabble.com/Need-help-to-load-application-using-500-concurrent-users-td533628.html
http://catyku.pixnet.net/blog/post/14721791-apache-jmeter-2.3%E6%95%99%E5%AD%B8
http://blog.xuite.net/chingwei/blog/28028249-%E3%80%90%E8%BB%9F%E9%AB%94%E3%80%91JMeter+-+%E5%A3%93%E5%8A%9B%E6%B8%AC%E8%A9%A6+-+%E9%80%B2%E9%9A%8E%E7%89%88
http://qtp-automate.blogspot.tw/2013/05/https-recording-with-new-jmeter_22.html

http://cloudchen.logdown.com/posts/247932/apache-jmeter-tool-for-load-test-and-measure-performance

2013年9月6日星期五

HOWTO: Setup SQL Server Linked Server to MySQL

http://www.ideaexcursion.com/2009/02/25/howto-setup-sql-server-linked-server-to-mysql/

Different Options for Importing Data into SQL Server

http://www.mssqltips.com/sqlservertip/1207/different-options-for-importing-data-into-sql-server/

Sample :
Create LinkedServer:
EXEC master.dbo.sp_addlinkedserver @server='MYSQL', @srvproduct='MySQL',
@provider='MSDASQL', @provstr='DRIVER={MySQL ODBC 5.2 Unicode Driver};SERVER=192.168.0.10;Port=3306;USER=root;PASSWORD=pollex123;OPTION=3;DATABASE=pollexsurvey';
Reseed:
DBCC CHECKIDENT ( pls_respondentdetail_extsat
, RESEED, 830);
DBCC CHECKIDENT ( pls_respondentdetail_extsat
, NORESEED);
Select Query:
SELECT * FROM OPENQUERY(pollexsurvey,
'SELECT * FROM pls_question')
Select INTO:
SELECT * INTO internalSat.dbo.pls_question FROM OPENQUERY(MYSQL,
'SELECT * FROM pls_question')
Insert Query:
INSERT OPENQUERY(MYSQL,'SELECT * FROM contact') SELECT * FROM contact

Update query:
UPDATE OPENQUERY(MYSQL,'select fax from contact where id=482') SET fax='123456'
Delete Query
DELETE OPENQUERY(mysql,'select fax from contact where id=482')