database
前demo有介紹利用SqlDataSoure和手動撰寫ADO.NET的方式大量新增資料的方法，雖然已經有效的改善了寫入的速度，但在發現了SqlBulkCopy以後，發現它更是威力強大，現在就來介紹SqlBulkCopy的猛。 3 SHARES FacebookGoogle+TwitterMore ★注意事項：本文是延續將資料大量寫入資料庫時的優化寫法的更優化如果對於文中有不清楚之意，可利用本文最下方相關的文章進入觀看資料大量寫入資料庫時的優化寫法一文 ▲說明都在程式註解中啦 //一開始我們先產生一個DataTable來裝我們要寫入的資料 DataTable dt = new DataTable(); dt.Columns.Add("id", typeof(int)); dt.Columns.Add("name", typeof(string)); //因為SqlBulkCopy的猛就是大量的一次寫入，所以我們也來跑10萬筆吧 int i; for (i = 0; i < 100000; i++)
backup
source link http://mycodetub.logdown.com/posts/260395-gitlab-backup-restore-settings-notes 這一陣子在熟悉使用 git 版本控制軟體之後，不免也會想要自己架設一個 git server 來存放自己平常工作的測試程式或休閒時間所寫的小 App。只不過 git server 的架設好像沒有像之前使用 VisualSVN Server 那麼容易，只要 下一步工程師 就可以完成。 後來有朋友推薦使用 GitLab 來架設 Git Server，也滿好用的。使用他提供的 omnibus 安裝，其實也是非常容易，只不過目前只有提供安裝在 Ubuntu, CentOS, 或 Debian 上而已。 好啦～講重點： 這份筆記的目的就是要防止萬一哪一天，
Tool
Frame rates Create a video (using the encoder libx264) from series of numerically sequential images such as img001.png, img002.png, img003.png, etc. Important: All images in a series need to be the same size and format. You can specify two frame rates: * The rate according to which the
結婚後的第一台公路車OCR 2，陪伴我上武嶺和塔塔佳，渡過無限汗水的騎乘生活。現在車子換成老婆在騎，我手上留著原廠附的輪組很久了，原因是花鼓無法有效潤滑，造成阻力越來越大。 最近雖然買了SHIMANO 拆花鼓棘輪工具想把棘輪座拆下保養，誰知在使儘力氣下都拆不下來，用錘子加上板手用力下拆花鼓工具崩牙了只有放棄。 後來想到之前有買一個同樣SHIMANO的Tiagra等級後花鼓，但是36孔的而我的鋁輪框是24孔的並不相容，查了網路發現有編輪專家用跳編的方式克服 http://blog.xuite.net/jimmy63723/twblog/175549014-%E8%A9%B2%E6%AD%BB%E7%9A%84%E8%BC%AA%E7%B5%84%E9%8B%BC%E7%B5%B2%E8%B7%B3%E7%B7%A8~+2%
configuration
https://access.redhat.com/documentation/en-US/Red_Hat_Enterprise_Linux/5/html/Online_Storage_Reconfiguration_Guide/iscsioffloadmain.html This chapter describes how to set up iSCSI interfaces in order to bind a session to a NIC port when using software iSCSI. It also describes how to set up interfaces
configuration
Messages from /var/log/messages after OpenManage install Josh Brown josh.brown at lightsurf.com Tue Apr 19 13:26:14 CDT 2005 * Previous message: Messages from /var/log/messages after OpenManage install * Next message: Messages from /var/log/messages after OpenManage install * Messages sorted by: [ date ] [ thread ] [ subject ] [ author
Compiler
Re: cannot generate system identifier for public text"-//OASIS// DTD DocBook V4.1//EN" * From: Norman Walsh <ndw at nwalsh dot com> * To: Kohler Benjamin <Benjamin dot Kohler at vpbank dot com> * Cc: "'docbook-apps at lists dot oasis-open dot org&
Dell
How to reboot an DELL idrac when web page refuse access: Connect to idrac IP using ssh with the password refused by web page $ ssh root@192.168.0.120 root@192.168.0.120's password: The magic DELL tool is here : radadm /admin1-> racadm =============================================================================== RACADM version
configuration
Windows Server 2012: Deactivating UAC Deactivating UAC in Windows 2008 R2 was possible via running msconfig (for example winkey+r -> msconfig), going to the Tools tab and launching "Change UAC settings". There, you select "Never notify" to disable UAC. The same approach is still available
Tool
Metacharacters Defined Metacharacter Examples ^ Start of a string. ^abc abc, abcdefg, abc123, … $ End of a string. abc$ abc, endsinabc, 123abc, … 0 Any character (except \n newline) a.c abc, aac, acc, adc, aec, … | Alternation. bill|ted ted, bill {…} Explicit quantifier notation. ab{2}c abbc […] Explicit set of characters to
Tool
Rotate 90 clockwise: ffmpeg -i in.mov -vf "transpose=1" out.mov For the transpose parameter you can pass: 0 = 90CounterCLockwise and Vertical Flip (default) 1 = 90Clockwise 2 = 90CounterClockwise 3 = 90Clockwise and Vertical Flip Use -vf "transpose=2,transpose=2" for 180 degrees. Make sure you
Network
NET-SNMP snmpwalk simple example The NET-SNMP snmpwalk command is a really good tool , but it has a really big help output, to simplify things just use one of the below examples and, if needed add the adequate parameters: SNMP v1: snmpwalk -v1 -c <community> <ipaddress&