SQL Server Upgrade Recommendations and Best Practices

As the DBA in your organization, you are central to the success of the SQL Server environment. In the case of a system upgrade, you need to act as a driver' for an upgrade project to ensure success based on your technical expertise and role in the organization. Over this multi-part series, these articles will outline proven and recommended best practices for the upgrade process.…

Are We Becoming Ad-Phobic?

A recent US survey revealed that more than half of TV viewers actually leave the room during commercials. This is bad news for advertisers, without whose support many programs could not be provided in the first place, but I don't imagine anyone is about to give up viewing entirely.

Updating WinXP + Free Cell Help

I am having problems using Windows Update on Windows XP Home Edition. I noticed that Windows update was notifying me that Windows Security Update 823559 needed to be installed. It would install without problems. But the next time I booted up my P.C. Windows Update was giving me the same story. I used Windows update and found Windows SP1 update and tried to apply that…

Using Your Database To Do the Work

A lot of people have asked me "what can I do to make the database work for me, instead of ColdFusion?". The truth is that any veteran developer will tell you that making the database do the work, is the best practice in web development. I can think of a few different ways to make the database work for you. By this I mean telling…