Microsoft websitespark

WebSiteSpark provides software licenses that you can use for three years at no cost. Once enrolled, you can download and immediately use the following software from Microsoft:




•3 licenses of Visual Studio 2008 Professional Edition

•1 license of Expression Studio 3 (which includes Expression Blend, Sketchflow, and Web)

•2 licenses of Expression Web 3

•4 processor licenses of Windows Web Server 2008 R2

•4 processor licenses of SQL Server 2008 Web Edition

•DotNetPanel control panel (enabling easy remote/hosted management of your servers)

The Windows Server and SQL Server licenses are for you to do both development and production work. Also, the production licenses can be leveraged in a couple of different ways. You can do 1 production server with 4 processors or 4 servers with 1 processor each. These servers can also be either dedicated hardware or virtualized offerings. If you want, you can throw the licenses on your own server with the “self-hosted” model or you can enroll with one of the hosters that have signed up as a Network Partner. As a Network Partner, they will pass the savings of the licenses on to you and only charge you for the infrastructure work. You can find all of the hosting network partners on the WebsiteSpark page.

資料來源
http://www.joshholmes.com/blog/2009/09/24/AnnouncingTheWebsiteSparkProgram.aspx



微軟websitespark網站
http://www.microsoft.com/web/websitespark/

Open Source Free Antivirus for Windows 2003

ClamWin Free Antivirus

ClamWin is a Free Antivirus program for Microsoft Windows 98/Me/2000/XP/2003 and Vista.

 

ClamWin Free Antivirus comes with an easy installer and open source code. You may download and use it absolutely free of charge. It features:

• High detection rates for viruses and spyware;
• Scanning Scheduler;
• Automatic downloads of regularly updated Virus Database.
• Standalone virus scanner and right-click menu integration to Microsoft Windows Explorer;
• Addin to Microsoft Outlook to remove virus-infected attachments automatically.

未來啟示錄SP1 Online 看到在地化的力量!!

第一次在電視上看到這個遊戲的宣傳短片，感覺還蠻不錯的

《未來啟示錄》遊戲宣傳影片 - 遊戲基地



後來某天..........

看到了台灣在地化版本的廣告，我笑了....深植我心...忘都忘不了
跟大家分享一下

SP1未來啟示錄TV廣告 台語版+字幕

SQL Server log 大爆炸

前一星期有個同事因為SQL Server 2008 Transcation log 檔案太大，導致SQL Server無法運作，他做了以下的動作，將SQL Server的執行程序停止，手動刪除log實體檔案，再次啟動SQL Server的程序，完蛋了.......叫不起來

後來依照以下的方式把資料庫給救回來囉~~紀錄一下
假設資料庫名稱為OhMyGod
1. 停止SQL Server, 將原mdf檔移走
2. 開啟SQL Server, 建立新的OhMyGod資料庫.
3. 停止SQL Server
4. 將損壞的mdf覆蓋回新建的mdf檔,並刪除新建的log檔
5. 開啟SQL Server
3. 設定OhMyGod資料庫狀態為EMERGENCY:
ALTER DATABASE OhMyGod SET EMERGENCY
4. 設定OhMyGod資料庫模式為"單一使用者":
sp_dboption 'OhMyGod', 'single user', 'true'
5. 檢查指定資料庫中所有物件的配置、結構和邏輯完整性:
DBCC CHECKDB (OhMyGod, REPAIR_ALLOW_DATA_LOSS)
6. 還原OhMyGod資料庫模式:
sp_dboption 'OhMyGod', 'single user', 'false'
7. 設定OhMyGod資料庫狀態為
ONLINE:ALTER DATABASE OhMyGod SET ONLINE

完成以上動作，資料庫救回來了，萬幸萬幸~~