Monday, June 29, 2009

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!

Friday, June 26, 2009

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.