Colt Kwong Blog

Visual Studio extensions for SharePoint - Developer User Guide

I was engaged in a SharePoint workflow project recently, so I prepare and boost my learning in SharePoint technology. I got new laptop and VS2008 (excited), but then I heard that the extension for VS 2008 will only be available in June 2008 (Today is still May!)

So I install VS2005, the extended SharePoint tool and the following "mandatory" components:

• Visual Studio 2005 extensions for .NET Framework 3.0 (Windows Workflow Foundation)
• SharePoint Server 2007 SDK
  

Of course, I need to check out the user guide of VS extension that just released yesterday.

Please feel free to drop me any useful resources or website so as to fasten my learning process. :)

Visual Studio 2005 Team Foundation Server Power Tools

If you are a typical TFS user like me, then you must bookmarked these 2 links / tools already:

1. Visual Studio 2005 Team Foundation Server Power Tools
2. Visual Studio Team System Web Access (formerly known as TeamPlain)
   

Opening Work Items in Excel/Project Failed with Office 2007 (TF80042)

 I try to open a (collection) work items in Excel today but I got the following error:

I was thinking is it because I am using Excel 2007 instead of  Excel 2003?

No way, it works fine after I read this post and enable .NET programming support!

Imagine Cup 2008 in Hong Kong

The Microsoft Hong Kong Imagine Cup website has been launched this year (the flourish and web page are excellent BTW)!

As a supporting organization, the Hong Kong .NET User Group is proud to cooperate with local MS office and provide a discussion forum and experts for this event this year.

Windows Mobile 6 for Palm Treo 750V

After attending the MS Hong Kong TechEd 2007 2 weeks ago, I'm glad to meet Mr. Mobile and recently, I know that Windows Mobile 6 release for the Palm Treo 750V after reading his blog.

Frankly, I had been using the Treo 750V with my 3G data plan for more than 8 months, but I'm not so satisfy and won't recommend this phone to others, because it is not so stable and I asked for a replacement already. Also, I have to restart it at least once a day (I know I know, it's acceptable for most WM users out there).

Anyway, I just install Windows Mobile 6 on my Treo 750V successfully so I hope this would enhance my device and fix some bugs. Also, please also read this doc about the difference between WM5 and WM6.

Colt

Sleep and Power Management in Windows Vista

I run into a problem that my laptop cannot wake up after sleep / hibernate, I try many different settings and combinations in power management of Vista and no luck, so I suspect it is related to my recent installation of KB939979 or KB938194?!

Nevertheless, I searched a couple of articles & tools, and also the differences between sleep (S2), hybrid sleep (S3) and hibernate (S4) in Windows Vista. My resolution is... update the latest version of display driver in Vista then problem gone. :)

Discount for Microsoft TechEd HK 2007

Just put the privilege membership discount announcement to couple of local communities and user groups for the Microsoft Hong Kong TechEd 2007. If you want further discount, drop me a message because I got a special discount code where the ticket is even more cheaper than a TechEd sponsor...

The name or security ID (SID) of the domain specified is inconsistent with the trust information for that domain

My colleague created a WMware Windows base image and I asked him to send a new copy to me because I need an environment of 2 separate (virtual) machines for AppServer (machineA) and DbServer (machineB) for testing purpose.

machineA is a DC and what I need to do next is let machineB join the domain of machineA. I go to the property of my computer on machineB and join the domain of machineA successfully. However, I can't login to machineB after restart and I got an error message: The name or security ID (SID) of the domain specified is inconsistent with the trust information for that domain.

Fortunately, I read this post from google and try the NewSid tool immediately, then the SID and name of the cloned WMware image changed immediately! (BTW, the URL of NewSid tool in that blog post is outdated so please following this link - http://www.microsoft.com/technet/sysinternals/Utilities/NewSid.mspx)

One more collaboration tool - SharedView

I have been using various remote assistance / collaboration tools in Live Messenger, Unyte, WebEx, GoToMeeting, QQ etc for long time due to my job and business nature, and it's good to hear that Microsoft provide a beta version of the SharedView tool.

Microsoft SharedView Beta - is a fast and easy way to share documents and screen views with small groups (15 max) of friends or coworkers; anytime, anywhere. Use SharedView to put your heads together and collaborate.

Check it out: http://get.live.com/betas/sharedview_betas

Unique and non unique index in SQL server

A developer asked me a question yesterday about what's the difference of unique and non unique index in a DB table. I then google and redirect him to this short and clean article: http://www.w3schools.com/sql/sql_create.asp 

It's good to recall:

Updating a table containing indexes takes more time than updating a table without, this is because the indexes also need an update. So, it is a good idea to create indexes only on columns that are often used for a search.