Alfred's New Ramblings

Work

SQL Express 2008

This is the first time I used SQL Server 2008 Express.  A most interesting experience.  First off there are several types, database only, management tools only, both  and Advanced Services that comes with reporting services.  I installed the database only…

How wide is it?

I was tooling around Microsoft SQL server in preparation for a 64 bit migration when I came across this interesting command. xp_msver It returned the following for my Intel box. 1    ProductName    NULL    Microsoft SQL Server 2    ProductVersion    589824    9.00.4035.00…

Three things today

Trying out noting three things that made my day. Hack a pillow case to be a seat cover case for son’s booster cushion. The four stacks of Ikea seat cushion kept running around. Delivered manpower forecast and crunch. Persisted and…

SID

SID are used to uniquely identify each object in the Windows world . An analogy will be social security numbers or NRIC number. I was very surprised when I heard that the famous sysinternal tool, newsid has ben depreciated.  Afterall…