Updates Resource Center for SharePoint Products and Technologies

Updates to the SharePoint Products and Technologies become available periodically. To successfully plan for and deploy these updates, use the process outlined in the Deployment Roadmap for Updates and in the articles linked to from the roadmap.

http://technet.microsoft.com/en-us/office/sharepointserver/bb735839.aspx

SQL Server Login Migration Scripts

If you haven't visited http://www.overachiever.net/, you'll be surprised to find out the usefulness of tutorial materials available for free.

My work has several SQL Server 2000 and 2005 and will soon begin to implement 2008. From time to time, I wanted to have reliable scripts that can assist me in migrating logins quickly when database migration needed to be done between servers.

You will find video tutorial plus all the scripts that cover for login migration between multiple versions of SQL Servers here, i.e., SQL Server 2000 to 2005, SQL Server 2005 to 2005, etc.

Really excellent materials!

My favorite Starbucks Store

This Starbucks store is on the northwest corner of Ball and Brookhurst in Anaheim. It is still my favorite among so many other Starbucks in Orange County.

Inside is neither fancy nor spic-and-spec clean. Most furnitures are old. The parking lot area is rather torn down due to heavy traffic and lack of maintenance. The air ventilation unit above the south-side door makes pretty loud noise every time someone opens the door to enter the store. Floor tiles are worn out noticeably, too.

However, I feel very comfortable and relaxed once I sit down at a table facing the south side with a cup of coffee. There's definitely this comfort-quality at this store being a less-than-perfect coffeehouse.

I call this store, "The Commoner's Starbucks". It just feels so comfortable to be there -- reading, relaxing, enjoying some drinks, etc.

Is varchar a good candidate for primary key?

Is varchar a good candidate for primary key?



The answer is: No.

Variable-length data is a poor choice to be a primary key. It is better to use fixed length data such as Int, BigInt or CHAR(10) for a primary key candidate.

first blog posting

Hello, world! I just signed up for my new blog page. I'll post useful code snippets mostly, particularly asp.net, c#, and sql.