First, Simple recovery mode in SQL 2000 does not reduce the amount of information logged in any way compared to Full recovery mode.  What Simple mode does is allow that...

I think the most significant quote from the results is

"unless your company is operating at a CMM level 3 or higher -- don't upgrade and simply deploy new systems...

"Always" and "Never" are two words people should always remember never to use.  Especially when giving advice. 

I registered a request with Microsoft that it should be possible during the install to specify the groups that SQL Server uses.  The response was 'This will be considered for...

I think this follows on in some way from the editorial about the lack of women in IT.  There is also a lack of men in IT.

We have managed to...

Avoid doing a shrinkfile if you know the file will grow again.  Repeated shrinkfiles will result in disk fragmentation which will harm performance.  You can only cure disk fragmentation by...

What is the size of your DW, and how long does the backup and the restore take?  I would be concerned that as your DW size grows, you may run...

If your account is not a member of the local Administrators group on the target server, you may get this issue.  KB 171862 describes this problem and gives a solution...

I have done W2003 x64 installs on a xeon box.  I needed to go back to the hardware vendor site to get some working x64 drivers.  (An x86 install on the...

I have seen the AWE checkbox on 64-bit SQL, but have not found out yet if it is ignored or harmful.  There is no way that selecting AWE on 64-bit...

I am surprised that your server can be 12 hours wrong without AD complaining.  I would have expected the computer account to have been disabled in this situation.  You should...

Maybe one reason vendor applications do not support the latest service pack is they have their own work schedules.  Adjusting the schedule to fit in a SP just because Microsoft...

This probably should be reported as a bug to Microsoft.

I think sp_MSforeachtable is not officially supported by Microsoft.  Therefore you will need to isolate where you get the fp execption,...

I would really really like a standard schedule for releasing Service Packs.  This allows workload to be predicted and planned.  Irregular SP releases mean irregular application of SPs.  If the...

If you have the DTS Designer components installed and the package still does not work, then get hold of Filemon fron sysinternals.

If you run Filemon while your DTS package is...