-
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,…
-
Get the documents out of SharePoint database
I recently helped a client to get the WSS 3.0 documents out, as the client’s SharePoint is broken and we couldn’t get it fixed in short time, but they really want the Word, Excel, and pdf documents out of there. WSS 3.0, Windows SharePoint Services, uses Sql Server for data storage. The Sql Server version…