I’m a .NET developer by profession. One of the things I really like about .NET is event driver applications and web sites. PHP doesn’t natively support this, but with a little imagination it’s not hard to recreate.||The .NET way|| For those not familiar with the event handler model, here’s a little example: To create a [...]

The *DateAdd* function of Microsoft SQL-server allows you to add a specified number of days, weeks, month or years to a specified date. But it does not allow you to dynamically specify if you want to add a day, week, month, etc. The Transact-SQL DateAdd syntax is specified as follows: DATEADD (datepart , number, date [...]

Sql statement to enumerate all user tables in a MS-SQL instance. SELECT a.[Name] as FunctionName FROM sysobjects a WHERE a.xtype = ‘U’ Meaning of sysobject.xtype values D : ? F : foreign keys FN : user defined functions P : stored procedures PK : primary keys S : system tables TR : triggers U : [...]

_\”The workload does not contain any events or queries that can be tuned against current database. Check to see that the trace contains valid events or that the SQL script contains valid queries and you are tuning against the right database.\”_That’s the error I received when trying to run the Index Tuning Wizard on a [...]

My Asus Eee PC-701 4G came with 512MB RAM. It’s not bad, and most tasks perform good enough. But at the current memory prices, I bought a strip of 2GB SO-DIMM anyway.The Asus takes DDR2-667MHz (PC-5300), 200-pins SO-DIMM modules. [note] Before opening your Asus Eee PC, remember to unplug the power cord and remove the [...]

I’ve had my 701 for about 2 weeks now. I really love the little machine. But even so, there are some things I think are allegable for improvement.||The good,|| *Price* At €299,- I didn’t have to thinks more than about 2 seconds to decide I was getting one. *Form factor* It’s small. It’s handy. I [...]

Here’s a short guide to installing Windows Fundamentals for Legacy PCs (WinFLP) on the Asus Eee PC. I’m using the 4G model, with 4GB SSD flash disk and 512MB RAM. Update: I have upgraded my Eee PC’s memory to 2GB. This tutorial has been assembled from multiple forums and Eee PC sites. There are some [...]