安裝Office 2007 Communication Server R2

注意事項
不能 Deploy Server - 不要安裝KB974571更新

參考
http://blogs.technet.com/b/dodeitte/archive/2009/10/13/do-not-apply-kb974571-to-lcs-ocs-servers.aspx

http://www.msexchange.org/articles_tutorials/exchange-server-2007/management-administration/deploying-exchange-server-2007-office-communications-server-2007-r2-part8.html

Hyper-V的VM有Saved狀況，不能刪除或啟動

解決如下：

1. 在Service中關掉所有Hyper-V服務
   
   
   
   • Hyper-V Image Management
   
   
   • Hyper-V Networking Management Service
   
   
   • Hyper-V Virtual Machine Management


2. 找出VM的設定檔
   
   
   
   • C:\ProgramData\Microsoft\Windows\Hyper-V\Virtual Machines
   
   
   • 例：F75ED29E-AE61-4FB4-BB52-66926D608666.xml


3. 刪除最後的</configuration>>的">"

參考資料

Larson, R.
(n.d.). Hyper-V File Storage and Permissions. Retrieved 11 10, 2010,
from
http://www.virtualizationadmin.com/articles-tutorials/microsoft-hyper-v-articles/storage-management/hyper-v-file-storage-permissions.html

spmikec. (n.d.). Thread Hyper-V Delete Save State . Retrieved 11 10, 2010, from
http://boardreader.com/thread/Hyper_V_Delete_Save_State_1sqlz__bed19854-e765-4ca3-accc-bbaf903c7f46.html

改變Word中合併欄位的日期格式

1. 選取日期合併欄位；
2. 按ALT+F9；
3. 改成如下: {MERGEFIELD "date" \@"dd MMMM yyyy"} 格式碼(Format Code) 與Excel 中使用的一樣。但須注意MMMM一定要大楷。

Dynamic Website with PHP Exercise

Create Dynamic Website
-Define Local Information & Testing Server in DW
Website Name: Contactroot
folder: contact

Create record set & display informationIn dynamic website:
1. Create "country_all.php"
2. Create a dabase connection to the "newland_tours" database on MySQL database server
3. Create record set "rsCountries" to retrieve all fields and records from tbl_country(sory by countryName ascending)
4. Make a table with two row-first row: header-second row: record
(Assume "dynamic"

Sort descending
1. Choose "dynamic" website and open "country_all.php"
2. Add a new column "population" in the table
3. Change the record to dsiplay by population descending (desc in SQL) in advanced mode

Setting up dynamic website development enviroment

Here is the listing of some tools useful:
1. XAMPP (Apache + PHP + MySQL, with phpmyadmin)
2. MySQL ODBC Connector

Enviroment
Web Server + Application Server + Database Server
1. Open Source: Apache + PHP + MySQL
2. Microft IIS (web server + ASP/ASP.NET) + Open Source MySQL (Need MySQL ODBC Connector)

Security Tools

• PortQry
• Virus sample

VBA Function

練習

1. 讓使用者可以用下形式計算bmi, 體重(kg)/身高(m square)

• e.g. bmi(60, 1.7)

2. 讓使用者可以用下形式計算身金

• salary(3000, 5000, 0.05, 30)
• 3000: 底薪
• 5000: 銷售產品的價格
• 0.05: 佣金
• 30: 賣出的產品數目

3. 讓使用者可以用下形式轉換體重

• pound2kg(220)

4. 重用 3. & 1. ，讓使用者可以用下形式使用

• bmiInPound(150, 1.7)
• 150: pound
• 1.7: meter

答案

Function bmi(massKg, heightM)
bmi = massKg / heightM ^ 2
End Function

Function salary(base, price, cRate, quantity)
salary = base + price * cRate * quantity
End Function

Function pound2kg(massPound)
pound2kg = massPound * 2.2
End Function

Function bmiInPound(massPound, heightM)
bmiInPound = bmi(pound2kg(massPound), heightM)
End Function