欠

前陣子(從把資料庫搞掰咖之後，又剛好遇到SQL資料庫要搬家)諸事不順，陸續看了一堆文件都沒空document一下。先記著，以後"有機會、有心力"再補XD。

1. Windows SharePoint Service(WSS3.0)之資料庫搬家順便升級(2005=>2008)
2. Oracle 9i: drop one datafile from tablespace
3. Oracle 9i: control file
4. Oracle 9i: autorun offline backup script
5. Oracle 9i: OS授權?
6. PowerBuilder: cross table, printpreview

Database maintenance for WSS3.0

Ref:

1. Database maintenance for Windows SharePoint Services 3.0 (white paper)
2. sp_spaceused (Transact-SQL)
3. DBCC UPDATEUSAGE (Transact-SQL)
4. DBCC SHRINKDATABASE (Transact-SQL)
5. Dropping and Rebuilding Large Objects

Installing Ruby on Rails on Ubuntu

Ref:

1. Installing Ruby on Rails on Debian/Ubuntu
2. Debian / Ubuntu Linux 的 Ruby on Rails 環境架設

Chorme in Ubuntu

1. Install google chrome with wine in Ubuntu
2. How to Install Chromium (Google chrome) in Ubuntu using deb package
   

ruby code format test

天哪!! 我成功了!! 原本是想說開始學ruby了，也應該像C# code一樣去找個formatter來用，這樣以後要貼code比較好看，結果找來找去，好像ruby本身就提供把code轉成html tags的function!! Ruby真的是programmer的好朋友!!!

in_data = Clipboard.data
convertor = Syntax::Convertors::HTML.for_syntax "ruby"
code_html = convertor.convert(in_data)
Clipboard.set_data(code_html)

過程還是有點卡XD 晚點整理好再來分享~

待研究主題: SQL語法之 IN vs. EXISTS

兩篇討論from Ask Tom:

1. IN & EXISTS
2. IN (vs) EXISTS and NOT IN (vs) NOT EXISTS

SharePoint: About Deleted Item

重要文件暫記:

1. How to permanently delete SharePoint content from database.
2. 內容跟上一篇相同，不過多了警告XD 一切後果自行負責
   MOSS/SharePoint 2007: Deleting Deleted Items
3. Programatically Setting the Maximum Versions on Lists and Document Libraries
4. View, restore, or delete items in the Recycle Bin of a SharePoint site
   中文版

User Account Control(UAC) in Vista

先貼後整理

What’s User Account Control (UAC) in Windows Vista?

Disable User Account Control in Windows Vista.

Killme-test