Tuesday, August 30, 2011

Rain Rain PLEASE Come!

The lengthy drought has made me depressed. Looks like the relief is coming. Very excited. Please don't let me down.



 

 

Tuesday, August 23, 2011

IE9 failed to open after Win7 SP1 installed

Symptom:

  1. Got this error at startup. "The ordinal 379 could not be located in the dynamic link library iertutil.dll."

  2. Checked the update history and found out the 'failed' status in "Windows Internet Explorer 9 for Windows 7". Opened it up and got the "Error Code 355"


I thought this could be a difficult fix or hard-to-find-solutions problem after a quick google search without luck.

Eventually I came cross Microsoft KB 929833, and decided to give a shot by running 'sfc /scannow' command. It took a good 30 minutes and told me to reboot in the command prompt. I did and to my surprise, the IE9 opened up.

Monday, August 22, 2011

SQL Backup Script

To create a simple backup job by using SQL Server Agent in MS SQL Server Management Studio

DECLARE @BackupPath VARCHAR(100)

SET @BackupPath = '\\<UNC Path>\PM_' + CONVERT(VARCHAR, GETDATE(), 112) + '.bak'

BACKUP DATABASE [<database_name>]

TO DISK = @BackupPath
GO

 

Wednesday, August 17, 2011

Error connecting to WSS database backup files

I was testing Selective Restore Manager for SharePoint from Metalogix on my WSS3.0 server. I had no problem connecting to SharePoint database or SharePoint site, but was not able to connect to any database backup file. Then of course, I could not test the file restore either.

At "Add connection" drop-down, I selected "Connection to SharePoint Database Backup file - ready only' option, pointed to my BAK files location, (both network share and local disk). The SQL server name was automatically populated as "<SERVER_NAME>\MICROSOFT##SSEE", and the Authentication is set to "Use Current Windows user". Once I clicked connect and was returned with the following error: 

I contacted Metalogix and was told it's the permission issue to sql. However, I don't have any other account besides my Windows domain admin account used to set up WSS server. I could not enable the remote connection either because this edition of SQL does not support it.

Then I used SQL server management studio express to back up the content database, then SRM seems to see the backup file but SRM crashed as soon as it started to restore.



 

So maybe this is not the backup solution for me till I found the workaround.

 

Manage MS internal database on WSS 3.0



  1. Install “SQL Server Management Studio Express” at the same server you have this “##ssee”  database server.


  2. When connecting to the database, use this as the “Server Name”:\\.\pipe\mssql$microsoft##ssee\sql\query






VMFS vs RDM



originated from http://www.vmware.com/files/pdf/Exchange_2010_on_VMware_-_Best_Practices_Guide.pdf

 

Monday, August 1, 2011

反射性疼痛的警訊

50歲的陳媽媽是家庭主婦,身材很標準、看起來很年輕,除了有高血壓外,並沒有其他疾病。而且她非常注重飲食養生,不菸、不酒,每天都有運動的習慣。
但是,最近陳媽媽卻發現,早上慢跑時牙齦會痛,假日和先生去爬山,沒有多久,牙齦也會痛,只好提早回家休息。先生勸她去看牙科,可是陳媽媽從小就怕牙醫,
所以,當她去看她的家庭醫師時,順道告訴醫師最近發生的這些情形。沒想到醫師很謹慎告訴她:「趕快去看心臟專科醫師,請醫師幫您做詳細的檢查。」
陳媽媽回家後告訴先生,陳先生半信半疑說:「牙痛怎麼會看心臟科呢?」陳媽媽說:「但是醫師是很嚴肅地建議我趕快去看耶!不是開玩笑喔!」隔天夫妻倆一起到心臟科門診求診。
醫師聽完陳媽媽的敘述後,告訴她:「陳太太,我建議您住院安排做心導管檢查,您的牙齦痛應該是『心絞痛引起的反射性疼痛』。」
經過心導管檢查果然發現,陳媽媽的心臟有3條血管阻塞,而且還有多處阻塞的情形,因此醫師建議陳媽媽接受心臟冠狀動脈血管繞道手術;她在手術後,恢復良好。
大多數人對「心絞痛」症狀的認識是:胸悶、胸前劇痛、盜冷汗。其實,心絞痛的症狀還有:手麻、肩胛骨(後肩膀)痛、下巴(或牙齦)痛、麻,而這些症狀都稱為反射性疼痛。容易罹患心血管疾病的危險因子除了高血壓、高血脂、糖尿病、抽菸、肥胖者外,年齡(40歲以上)、停經後婦女、有家族史者,亦都是罹患心血管疾病的高危險群。
關於心臟病發作除左胳膊痛苦以外,心臟病發作會有其他症狀:如下巴會劇痛,以及噁心和盜汗,然而這些症狀也許並不常常發生。

注意:心臟病發作期間,可能不會有胸口的痛苦。多數人(大約60%)在他們的睡眠期間心臟病發作,因而沒有醒來。 然而,胸口痛也許會讓您從您的熟睡中醒來。
如果這樣,立刻咬碎二阿斯匹靈在您的嘴中並且與水吞下他們。之後,給鄰居或居住非常近的家庭成員打電話 -說; " 心臟病發作! 已吞了2顆阿斯匹靈。" 然後坐在前門附近的椅子或沙發上,並且等待人們的到來~絕不能再躺下來~  心臟科醫師聲明,如果每個人,在收到這電子郵件以後,送給10個人,大概
會有一個人的生命能被保存。

Prevent users accidentally move the top level folders

All top-level folders are shown in the file server share below. To prevent users from accidentally moving or deleting any of the top-level ...