-
Sql Server 2005 SP1 Agent email notification not working
It looks that there is a bug in Sql Server 2005 SP1 that renders Sql Server Agent job email notification useless. This notification is enabled through Notification page in job property page. Below is the error message you will see in Sql Server Agent log, even when “Agent XPs” setting is set to 1: [298]…
-
Proper ways of setting up Sql Server 2005
Here are some things I’ve learned with many clients when setting up Sql Server 2005 systems. 1. Get 64-bit if you can. Throw in as many processors, memory, good disk system (properly tuned SAN, for example) as you can possibly get; 2. Apply the latest service packs for Windows. At this writing, it is SP2…
-
HP DV6253cl laptop wireless not working
As mentioned here, I bought a HP dv6253cl (AMD Turion 64 dual core) laptop around April, 2007. Up to about a month ago, it worked all right, with the wireless indicator on with blue color. Then it stopped working. If memory serves, I think it stopped working after installing Windows Update. The wireless light is…
-
Internet connection problem when Symantec anti-virus software is not running
I noticed there were a lot of bloated Symantec anti-virus junk installed on a workstation I work with. So I disabled most of them in Windows services. The next day I came back, I couldn’t connect to the web with my Firefox anymore, but could connect via Internet Explorer. In addition, connecting to remote Sql…
-
Database backup compression in Sql Server 2008 Katmai
It looks like database backup compression in Sql Server 2008 will only be available in Enterprise Edition, at least that is what BOL says, in the latest Sql Server 2008 CTP (November, 2007). So I gave it a little spin. I detached AdventureWorks, attached it on a Katmai instance and run two sets of backups,…