<?xml version="1.0" encoding="UTF-8" ?>
<?xml-stylesheet type="text/xsl" href="http://community.sgdotnet.org/utility/FeedStylesheets/atom.xsl" media="screen"?><feed xmlns="http://www.w3.org/2005/Atom" xml:lang="en"><title type="html">DarenHan&amp;#39;s Blog</title><subtitle type="html">I am a Dot net asp.net developer working with VS 2005 and SQL 2005 now.

</subtitle><id>http://community.sgdotnet.org/blogs/darenhan/atom.aspx</id><link rel="alternate" type="text/html" href="http://community.sgdotnet.org/blogs/darenhan/default.aspx" /><link rel="self" type="application/atom+xml" href="http://community.sgdotnet.org/blogs/darenhan/atom.aspx" /><generator uri="http://communityserver.org" version="4.1.30912.2823">Community Server</generator><updated>2009-03-17T04:08:00Z</updated><entry><title>Get Wondershare Office Recovery v1.5 free while stocks last</title><link rel="alternate" type="text/html" href="/blogs/darenhan/archive/2010/03/01/get-wondershare-office-recovery-v1-5-free-while-stocks-last.aspx" /><id>/blogs/darenhan/archive/2010/03/01/get-wondershare-office-recovery-v1-5-free-while-stocks-last.aspx</id><published>2010-03-01T02:18:00Z</published><updated>2010-03-01T02:18:00Z</updated><content type="html">&lt;p&gt;Wondershare Office Recovery, from Wondershare Software, is a new 
powerful office recovery tool specially designed for recovering office 
files and PDF files lost caused by accidental deletion, formatted, virus
 infection, bad sectors, misuse of partition tools and so forth, 
allowing users to restore variety of office files formats, including 
DOC, DOCX, XLS, XLSX, PPT, PPTX, PST, DBX, ACCDB, MPP, PUB, ONE, XSN and
 PDF files.&lt;/p&gt;
&lt;p&gt;&amp;nbsp;&lt;/p&gt;
&lt;p&gt;Now, there is a chance to get a free copy of Wondershare Office Recovery 1.5.&lt;/p&gt;
&lt;p&gt;&amp;nbsp;&lt;/p&gt;
&lt;p&gt;Just go to the link below and &lt;/p&gt;
&lt;p&gt;&lt;a target="_blank" href="http://www.data-recovery-utilities.com/office-recovery/get-keycode.html"&gt;http://www.data-recovery-utilities.com/office-recovery/get-keycode.html&lt;/a&gt;&lt;/p&gt;&lt;div style="clear:both;"&gt;&lt;/div&gt;&lt;img src="http://community.sgdotnet.org/aggbug.aspx?PostID=224568" width="1" height="1"&gt;</content><author><name>darenhan</name><uri>http://community.sgdotnet.org/members/darenhan/default.aspx</uri></author></entry><entry><title>Trend Micro Internet Security 2010 free updates for 1 year for Mac / PC.</title><link rel="alternate" type="text/html" href="/blogs/darenhan/archive/2010/02/28/trend-micro-internet-security-2010-free-updates-for-1-year-for-mac-pc.aspx" /><id>/blogs/darenhan/archive/2010/02/28/trend-micro-internet-security-2010-free-updates-for-1-year-for-mac-pc.aspx</id><published>2010-02-28T13:39:00Z</published><updated>2010-02-28T13:39:00Z</updated><content type="html">&lt;p&gt;Step one: &lt;/p&gt;
&lt;p&gt;Go to this link and download the version for PC or Mac on the right hand side - top.&lt;/p&gt;
&lt;p&gt;&lt;a target="_blank" href="http://shop.trendmicro.com/iomega/en/?sn=f9bj26006x"&gt;http://shop.trendmicro.com/iomega/en/?sn=f9bj26006x&lt;/a&gt;&lt;/p&gt;
&lt;p&gt;&amp;nbsp;&lt;/p&gt;
&lt;p&gt;Step two:&lt;/p&gt;
&lt;p&gt;Install the trial but when the installation finishes, you can register your email and you get 1 year free updates as well as subscription.&lt;/p&gt;
&lt;p&gt;&amp;nbsp;&lt;/p&gt;
&lt;p&gt;Enjoy!&lt;/p&gt;
&lt;p&gt;&amp;nbsp;&lt;/p&gt;&lt;div style="clear:both;"&gt;&lt;/div&gt;&lt;img src="http://community.sgdotnet.org/aggbug.aspx?PostID=224569" width="1" height="1"&gt;</content><author><name>darenhan</name><uri>http://community.sgdotnet.org/members/darenhan/default.aspx</uri></author></entry><entry><title>After server security patches, the sharing folder permissions disappears. Here is a quick fix.</title><link rel="alternate" type="text/html" href="/blogs/darenhan/archive/2010/02/24/after-server-security-patches-the-sharing-folder-permissions-disappears-here-is-a-quick-fix.aspx" /><id>/blogs/darenhan/archive/2010/02/24/after-server-security-patches-the-sharing-folder-permissions-disappears-here-is-a-quick-fix.aspx</id><published>2010-02-24T08:29:00Z</published><updated>2010-02-24T08:29:00Z</updated><content type="html">&lt;p&gt;Source: http://support.microsoft.com/?kbid=125996&lt;/p&gt;
&lt;p&gt;To save only the existing share names and their permissions on Windows follow these steps. &lt;br /&gt;&lt;br /&gt;&lt;b&gt;Note&lt;/b&gt; This procedure applies only to NetBIOS shares and not to Macintosh volumes.  &lt;/p&gt;
&lt;ol&gt;
&lt;li&gt;On
the existing Windows installation that contains the share names and
permissions that you want to save, start Registry Editor (Regedt32.exe).&lt;/li&gt;
&lt;li&gt;From the HKEY_LOCAL_MACHINE subtree, go to the following key:
&lt;div class="indent"&gt;&lt;b&gt;SYSTEM\CurrentControlSet\Services\LanmanServer\Shares&lt;/b&gt;&lt;/div&gt;
&lt;/li&gt;
&lt;li&gt;Save or export the registry key.
&lt;ul&gt;
&lt;li&gt;For Windows NT and Windows 2000,  click &lt;b&gt;Save Key&lt;/b&gt; on the &lt;b&gt;Registry&lt;/b&gt; menu.&lt;/li&gt;
&lt;li&gt;For Windows Server 2003, click &lt;b&gt;Export&lt;/b&gt; on the &lt;b&gt;File&lt;/b&gt; menu.&lt;/li&gt;
&lt;/ul&gt;
&lt;/li&gt;
&lt;li&gt;Type a new file name (a file extension is not necessary), and then save the file to a floppy disk.&lt;/li&gt;
&lt;li&gt;Reinstall Windows.&lt;/li&gt;
&lt;li&gt;Run Registry Editor (Regedt32.exe).&lt;/li&gt;
&lt;li&gt;From the HKEY_LOCAL_MACHINE subtree, go to the following key:
&lt;div class="indent"&gt;&lt;b&gt;SYSTEM\CurrentControlSet\Services\LanmanServer\Shares&lt;/b&gt;&lt;/div&gt;
&lt;/li&gt;
&lt;li&gt;Restore or import the registry key.
&lt;ul&gt;
&lt;li&gt;For Windows NT and Windows 2000, click &lt;b&gt;Restore&lt;/b&gt; on the &lt;b&gt;Registry&lt;/b&gt; menu.&lt;/li&gt;
&lt;li&gt;For Windows Server 2003, click &lt;b&gt;Import&lt;/b&gt; on the &lt;b&gt;File&lt;/b&gt; menu.&lt;/li&gt;
&lt;/ul&gt;
&lt;/li&gt;
&lt;li&gt;Type the path and file name of the file that you saved in steps 3 and 4.&lt;br /&gt;&lt;br /&gt;&lt;b&gt;Caution&lt;/b&gt;
This step overrides the shares that already exist on the Windows
computer with the share names and permissions that exist in the file
you are restoring. You are warned about this before you restore the
key. &lt;/li&gt;
&lt;li&gt;Restart the server.&lt;/li&gt;
&lt;/ol&gt;
&lt;p&gt;&lt;b&gt;Note&lt;/b&gt; After you
complete this procedure, if you decide that you should not have
restored the Shares key, restart the computer and press the SPACEBAR to
use the last known good configuration. After you restore the shares
key, the shares can be used by network clients. If you run the &lt;b&gt;net shares&lt;/b&gt;
command on the server, the server displays the shares; however, File
Manager does not display the shares. To make File Manager aware of the
newly restored shares, create any new share on the server. File Manager
displays all of the other shares after you restart the server or stop
and restart the Server service.&lt;br /&gt;&lt;br /&gt;
 In Windows NT 3.5, if you click &lt;b&gt;Stop Sharing&lt;/b&gt; in File Manager, the restored shares are still displayed, but they are dimmed.&lt;br /&gt;&lt;br /&gt;
Only permissions for domain users are restored. If a local user was
created in the previous Windows NT installation, that local user&amp;#39;s
unique security identifier (SID) is lost. NTFS permissions on folders
and files are not affected when you save and restore the shares key.&lt;br /&gt;&lt;br /&gt;&lt;b&gt;Note&lt;/b&gt;:  This article does not apply to Windows Server 2008 or Windows Server 2008 R2.&lt;/p&gt;
&lt;p&gt;&amp;nbsp;&lt;/p&gt;&lt;div style="clear:both;"&gt;&lt;/div&gt;&lt;img src="http://community.sgdotnet.org/aggbug.aspx?PostID=224567" width="1" height="1"&gt;</content><author><name>darenhan</name><uri>http://community.sgdotnet.org/members/darenhan/default.aspx</uri></author></entry><entry><title>Resize your hard disk partitions for free using EASEUS Partition Master 4.1.1 Home Edition  </title><link rel="alternate" type="text/html" href="/blogs/darenhan/archive/2010/01/01/resize-your-hard-disk-partitions-for-free-using-easeus-partition-master-4-1-1-home-edition.aspx" /><id>/blogs/darenhan/archive/2010/01/01/resize-your-hard-disk-partitions-for-free-using-easeus-partition-master-4-1-1-home-edition.aspx</id><published>2010-01-01T03:03:00Z</published><updated>2010-01-01T03:03:00Z</updated><content type="html">&lt;p&gt;EASEUS Partition Master Home Edition is a &lt;span class="Bold"&gt;FREE&lt;/span&gt;
disk partitioning utility for extending system partition, better disk
space management, settling low disk space problem under Windows
2000/XP/Vista/&lt;a href="http://www.partition-tool.com/easeus-partition-manager/free-windows-7-partition-manager.htm"&gt;&lt;span class="Bold"&gt;Windows 7&lt;/span&gt;&lt;/a&gt; (for 32 bit Only - &lt;a href="http://www.partition-tool.com/easeus-partition-manager/windows-32-or-64-bit.htm"&gt;How to figure out Windows 32 bit or 64 bit&lt;/a&gt;?).&lt;/p&gt;
&lt;p&gt;Check it out:&lt;/p&gt;
&lt;p&gt;http://www.partition-tool.com/personal.htm&lt;/p&gt;&lt;div style="clear:both;"&gt;&lt;/div&gt;&lt;img src="http://community.sgdotnet.org/aggbug.aspx?PostID=224510" width="1" height="1"&gt;</content><author><name>darenhan</name><uri>http://community.sgdotnet.org/members/darenhan/default.aspx</uri></author></entry><entry><title>Could not load file or assembly 'CrystalDecision.web, version=10.5.3700' on web page.</title><link rel="alternate" type="text/html" href="/blogs/darenhan/archive/2009/12/30/could-not-load-file-or-assembly-crystaldecision-web-version-10-5-3700-on-web-page.aspx" /><id>/blogs/darenhan/archive/2009/12/30/could-not-load-file-or-assembly-crystaldecision-web-version-10-5-3700-on-web-page.aspx</id><published>2009-12-30T08:46:00Z</published><updated>2009-12-30T08:46:00Z</updated><content type="html">&lt;p&gt;&lt;strong&gt;Problem:&lt;/strong&gt; &lt;/p&gt;
&lt;p&gt;Could not load file or assembly &amp;#39;CrystalDecision.web, version=10.5.3700&amp;#39; on web page. I found the register tagprefix tag under the code behind of the aspx page has the following tag and figured it is a dll problem.&lt;/p&gt;
&lt;p&gt;&amp;lt;% Register TagPrefix=&amp;quot;cr&amp;quot; Namespace=&amp;quot;CrystalDecisions.Web&amp;quot; Assembly=&amp;quot;CrystalDecision.Web, Version=10.5.37... %&amp;gt;&lt;/p&gt;
&lt;p&gt;&lt;strong&gt;Solution:&lt;/strong&gt; &lt;/p&gt;
&lt;p&gt;Navigate to SAP BusinessObjects url : &lt;a href="http://wiki.sdn.sap.com/wiki/pages/viewpage.action?pageId=56787567"&gt;http://wiki.sdn.sap.com/wiki/pages/viewpage.action?pageId=56787567&lt;/a&gt;&lt;/p&gt;
&lt;p&gt;And download the crystal dlls version 10.5.37. Install the crystal GAC dlls on the web server.&lt;/p&gt;
&lt;p&gt;Restart the IIS as the GAC is now refreshed with the latest crystal reports dll.&lt;/p&gt;&lt;div style="clear:both;"&gt;&lt;/div&gt;&lt;img src="http://community.sgdotnet.org/aggbug.aspx?PostID=224509" width="1" height="1"&gt;</content><author><name>darenhan</name><uri>http://community.sgdotnet.org/members/darenhan/default.aspx</uri></author></entry><entry><title>Just created a buddhist web site</title><link rel="alternate" type="text/html" href="/blogs/darenhan/archive/2009/10/17/just-created-a-buddhist-web-site.aspx" /><id>/blogs/darenhan/archive/2009/10/17/just-created-a-buddhist-web-site.aspx</id><published>2009-10-17T10:04:00Z</published><updated>2009-10-17T10:04:00Z</updated><content type="html">&lt;p&gt;I found out about this small buddhist group from my friend. I did the web site out of volunteer. They are having some sutta lessons or mediations. &lt;/p&gt;
&lt;p&gt;The place is called&amp;nbsp; &lt;span style="font-size:x-large;"&gt;&lt;span style="color:#000099;"&gt;&lt;/span&gt;&lt;/span&gt;&lt;a href="http://themindingcentre.googlepages.com/"&gt;The Minding Centre.&lt;/a&gt;&lt;/p&gt;
&lt;p&gt;Link:&amp;nbsp; http://www.dharmafarer.net/&lt;/p&gt;
&lt;p&gt;&amp;nbsp;&lt;/p&gt;
&lt;p&gt;Let me know of any comments you have on the web site. :)&lt;/p&gt;&lt;div style="clear:both;"&gt;&lt;/div&gt;&lt;img src="http://community.sgdotnet.org/aggbug.aspx?PostID=224448" width="1" height="1"&gt;</content><author><name>darenhan</name><uri>http://community.sgdotnet.org/members/darenhan/default.aspx</uri></author></entry><entry><title>Norton 2010 Launch Event</title><link rel="alternate" type="text/html" href="/blogs/darenhan/archive/2009/10/08/norton-2010-launch-event.aspx" /><id>/blogs/darenhan/archive/2009/10/08/norton-2010-launch-event.aspx</id><published>2009-10-08T08:29:00Z</published><updated>2009-10-08T08:29:00Z</updated><content type="html">&lt;p style="padding-left:90px;"&gt;&lt;img src="http://community.sgdotnet.org/resized-image.ashx/__size/604x404/__key/CommunityServer.Components.UserFiles/00.00.00.18.56/DSC01487.JPG" alt="" /&gt;&lt;/p&gt;
&lt;p style="padding-left:150px;"&gt;&amp;nbsp;&lt;/p&gt;
&lt;p style="padding-left:90px;"&gt;This event is held to commemorate the launch of Norton 2010 security
suit. Each participate has a goodie bag which comprises of a XL
T-Shirt, wireless mouse, Norton 2010 CD and a complimentary SG Flyer
ticket.&lt;br /&gt;&lt;br /&gt;We had good dinner and after dinner, there are some
games which include making your own eggdrop machine which catches an
egg without making it break from 2 metres.&lt;/p&gt;
&lt;p style="padding-left:90px;"&gt;Next, we are shown the video where the Norton guys proved their new technology of having everyone identify which is a good file versus a bad file which are feedback gathered from around the world. This cloud technology let them determine malware even before virus signatures are made. The new Norton 2010 is using less resources than the previous 2009 version. We are also shown videos of underground economy selling people&amp;#39;s identity, credit card details online. Security is a must if you are doing online transactions.&lt;/p&gt;
&lt;p style="padding-left:90px;"&gt;The Norton guys told us freeware anti-malware software usually give people a false sense of security that they are &amp;quot;protected&amp;quot;. I very much agreed with this sentence as most locals here seldom fork out money to buy the software they need. They rather depend on freeware found online. &lt;br /&gt;&lt;br /&gt;Our Table 9 won the 2nd runner-up for the eggdrop machine. We won $10 haagen daz voucher each.&lt;br /&gt;&lt;br /&gt;Before leaving home, I collected my ipod shuffle 4 gig which I won during the beta lucky draw.&lt;/p&gt;
&lt;p style="padding-left:90px;"&gt;&amp;nbsp;&lt;/p&gt;
&lt;p style="padding-left:90px;"&gt;To register yourself as member of the Norton Inner Circle Group for events like this:&lt;/p&gt;
&lt;p style="padding-left:90px;"&gt;http://www.nortonopscenter.com/asean/nic/member.html&lt;/p&gt;&lt;div style="clear:both;"&gt;&lt;/div&gt;&lt;img src="http://community.sgdotnet.org/aggbug.aspx?PostID=224437" width="1" height="1"&gt;</content><author><name>darenhan</name><uri>http://community.sgdotnet.org/members/darenhan/default.aspx</uri></author></entry><entry><title>Plants vs Zombies 1.0 40% off usual price for Mac (today's offer only)</title><link rel="alternate" type="text/html" href="/blogs/darenhan/archive/2009/08/31/plants-vs-zombies-1-0-40-off-usual-price-for-mac-today-s-offer-only.aspx" /><id>/blogs/darenhan/archive/2009/08/31/plants-vs-zombies-1-0-40-off-usual-price-for-mac-today-s-offer-only.aspx</id><published>2009-08-31T10:30:00Z</published><updated>2009-08-31T10:30:00Z</updated><content type="html">&lt;p&gt;&lt;img src="http://www.mupromo.com/images/screens/uploaded/JPG/31233_scr.jpg" alt="" /&gt;&lt;br /&gt;&lt;br /&gt;Plants vs Zombies...Get ready to soil your plants in an all-new action-strategy game from PopCap! A mob of fun-loving zombies is about to invade your home, and your only defense is an arsenal of 49 zombie-zapping plants. Use peashooters, wall-nuts, cherry bombs and more to mulchify 26 types of zombies before they can reach your front door.&lt;br /&gt;&lt;br /&gt;Each zombie has its own special skills, so youll need to think fast and plant faster to combat them all. But be careful how you use your limited supply of greens and seeds&amp;hellip; as you battle the fun-dead, obstacles like a setting sun, creeping fog and a swimming pool add to the challenge. And with five game modes to dig into, the fun never dies!&lt;br /&gt;&lt;br /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; * Play five game modes: Adventure, Mini-Games, Puzzle, Survival, plus the stress-free Zen Garden&lt;br /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; * Conquer all 50 levels of Adventure mode -- through day, night and fog, in a swimming pool and on the rooftop&lt;br /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; * Battle 26 types of zombies including pole-vaulters, snorkelers and Zomboni drivers&lt;br /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; * Earn 49 powerful perennials and collect coins to buy a pet snail, power-ups and more!&lt;br /&gt;&lt;br /&gt;Video: (Please visit the site to view this media)&lt;br /&gt;&lt;br /&gt;&lt;a target="_blank" href="http://www.mupromo.com/?ref=6861"&gt;Download the game now&lt;/a&gt;&lt;/p&gt;
&lt;p&gt;The sale offer is only valid for today only - 30 August 2009&lt;/p&gt;&lt;div style="clear:both;"&gt;&lt;/div&gt;&lt;img src="http://community.sgdotnet.org/aggbug.aspx?PostID=224410" width="1" height="1"&gt;</content><author><name>darenhan</name><uri>http://community.sgdotnet.org/members/darenhan/default.aspx</uri></author></entry><entry><title>Free C# 3.0 oreilly book for download</title><link rel="alternate" type="text/html" href="/blogs/darenhan/archive/2009/08/17/free-c-3-0-oreilly-book-for-download.aspx" /><id>/blogs/darenhan/archive/2009/08/17/free-c-3-0-oreilly-book-for-download.aspx</id><published>2009-08-17T21:04:00Z</published><updated>2009-08-17T21:04:00Z</updated><content type="html">&lt;p&gt;I found a free book given by the redgate people. Quite friendly bunch of people who are giving free ebooks with downloads of their software tools for database and performance tuning.&lt;/p&gt;
&lt;p&gt;&amp;nbsp;&lt;/p&gt;
&lt;p&gt;See the link below:&lt;/p&gt;
&lt;p&gt;&lt;a target="_blank" href="http://www.red-gate.com/products/ants_performance_profiler/be_ahead_of_the_game_ebook.htm?utm_source=simpletalk&amp;amp;utm_medium=email&amp;amp;utm_content=nlv_aheadofgame-ebook&amp;amp;utm_campaign=antsperformanceprofiler"&gt;http://www.red-gate.com/products/ants_performance_profiler/be_ahead_of_the_game_ebook.htm?utm_source=simpletalk&amp;amp;utm_medium=email&amp;amp;utm_content=nlv_aheadofgame-ebook&amp;amp;utm_campaign=antsperformanceprofiler&lt;/a&gt;&lt;/p&gt;
&lt;p&gt;&amp;nbsp;&lt;/p&gt;&lt;div style="clear:both;"&gt;&lt;/div&gt;&lt;img src="http://community.sgdotnet.org/aggbug.aspx?PostID=224374" width="1" height="1"&gt;</content><author><name>darenhan</name><uri>http://community.sgdotnet.org/members/darenhan/default.aspx</uri></author></entry><entry><title>How good is Microsoft antivirus? </title><link rel="alternate" type="text/html" href="/blogs/darenhan/archive/2009/06/20/how-good-is-microsoft-antivirus.aspx" /><id>/blogs/darenhan/archive/2009/06/20/how-good-is-microsoft-antivirus.aspx</id><published>2009-06-20T09:10:00Z</published><updated>2009-06-20T09:10:00Z</updated><content type="html">&lt;p&gt;Microsoft has officially unveiled its long-awaited consumer antivirus offering. Formerly code-named &amp;ldquo;Morro,&amp;rdquo; it&amp;rsquo;s now been christened Microsoft Security Essentials, and it will enter public beta testing next week. If you have a licensed copy of Windows XP (Service Pack 2 or above), Windows Vista, or Windows 7, you&amp;rsquo;ll be able to download and install the software at no additional charge. No subscription is required for ongoing definition updates, either. The final release is scheduled for this fall.&amp;nbsp;&lt;/p&gt;
&lt;p&gt;http://blogs.zdnet.com/Bott/?p=1067&lt;/p&gt;&lt;div style="clear:both;"&gt;&lt;/div&gt;&lt;img src="http://community.sgdotnet.org/aggbug.aspx?PostID=224320" width="1" height="1"&gt;</content><author><name>darenhan</name><uri>http://community.sgdotnet.org/members/darenhan/default.aspx</uri></author></entry><entry><title>How to disable Java Quick Start process</title><link rel="alternate" type="text/html" href="/blogs/darenhan/archive/2009/05/26/how-to-disable-java-quick-start-process.aspx" /><id>/blogs/darenhan/archive/2009/05/26/how-to-disable-java-quick-start-process.aspx</id><published>2009-05-26T15:37:00Z</published><updated>2009-05-26T15:37:00Z</updated><content type="html">&lt;p&gt;&amp;nbsp;&lt;/p&gt;
&lt;p&gt;I recently got this jqs.exe in my task manager in Windows XP and found a way to disable it. Please read on.&lt;/p&gt;
&lt;p&gt;&amp;nbsp;&lt;/p&gt;
&lt;p&gt;If you open the Windows Task Manager (by pressing CTRL ALT DEL) you might notice 
the process jqs.exe that is running with a low priority. Jqs.exe uses about 1.5 
Megabytes of computer memory and 2 Megabytes of virtual memory while running. It 
also initiates I/O processes frequently if those columns are activated in the 
Task Manager.&lt;/p&gt;
&lt;p&gt;Experienced computer users might guess that the process is related to Java 
and that is the case indeed. Jqs.exe is the Java Quick Starter which was 
designed to improve the startup time of Java applets and applications by 
prefetching Java Runtime Environment files frequently into memory. That&amp;rsquo;s mainly 
interesting for users who work with Java on a day to day basis. Everyone else 
might be better of disabling the Java Quick Starter. Think of a user who 
encounters one Java applet per month (or week), would it make sense to run the 
process all the time because of those few instances where it might start the 
application or applet faster?&lt;/p&gt;
&lt;p&gt;Jqs.exe is definitely querying the Windows Registry for instance. The 
performance increase might not be huge but you will free up some computer memory 
and some I/O processes on the computer system.&lt;/p&gt;
&lt;p&gt;&lt;strong&gt;How to disable JQS.exe&lt;/strong&gt;&lt;/p&gt;
&lt;p&gt;Now, if you want to disable the Java Quick Starter process you can do that in 
the Windows Control Panel. You find a Java entry there which will open the Java 
Control Panel.&lt;/p&gt;
&lt;p&gt;A click on Advanced and the selection of Miscellaneous will display the 
activated Java Quick Starter entry. Uncheck the box to disable the process. This 
will be visible in the Windows Task Manager immediately.&lt;/p&gt;
&lt;p&gt;&amp;nbsp;&lt;/p&gt;
&lt;p&gt;Source of information: http://www.ghacks.net/2008/12/15/jqsexe/&lt;/p&gt;&lt;div style="clear:both;"&gt;&lt;/div&gt;&lt;img src="http://community.sgdotnet.org/aggbug.aspx?PostID=224298" width="1" height="1"&gt;</content><author><name>darenhan</name><uri>http://community.sgdotnet.org/members/darenhan/default.aspx</uri></author></entry><entry><title>SQL Server 2000 suspect database status</title><link rel="alternate" type="text/html" href="/blogs/darenhan/archive/2009/05/20/sql-server-2000-suspect-database-status.aspx" /><id>/blogs/darenhan/archive/2009/05/20/sql-server-2000-suspect-database-status.aspx</id><published>2009-05-20T05:15:00Z</published><updated>2009-05-20T05:15:00Z</updated><content type="html">&lt;p align="left" style="text-align:left;mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;" class="MsoNormal"&gt;&lt;b&gt;&lt;span style="font-size:x-small;font-family:Verdana;"&gt;&lt;span style="font-weight:bold;font-size:10pt;font-family:Verdana;"&gt;I find this solution quite useful and use it in my job to solve my problem.&lt;/span&gt;&lt;/span&gt;&lt;/b&gt;&lt;/p&gt;
&lt;p align="left" style="text-align:left;mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;" class="MsoNormal"&gt;&lt;b&gt;&lt;span style="text-decoration:underline;"&gt;&lt;span style="font-size:x-small;font-family:Verdana;"&gt;&lt;span style="font-weight:bold;font-size:10pt;font-family:Verdana;"&gt;Problem&lt;br /&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/b&gt;&lt;span style="font-size:x-small;font-family:Verdana;"&gt;&lt;span style="font-size:10pt;font-family:Verdana;"&gt;I have a SQL Server 2000 database that has the wrong database status.&amp;nbsp; For some reason it is in the &amp;#39;Suspect\Offline&amp;#39; mode.&amp;nbsp; I just need to correct the problem quickly and get my database back online.&amp;nbsp; How can I do so?&amp;nbsp;&amp;nbsp; Once the status is correct, do I need to take any further steps?&amp;nbsp; &lt;/span&gt;&lt;/span&gt;&lt;/p&gt;
&lt;p align="left" style="text-align:left;mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;" class="MsoNormal"&gt;&lt;b&gt;&lt;span style="text-decoration:underline;"&gt;&lt;span style="font-size:x-small;font-family:Verdana;"&gt;&lt;span style="font-weight:bold;font-size:10pt;font-family:Verdana;"&gt;Solution&lt;br /&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/b&gt;&lt;span style="font-size:x-small;font-family:Verdana;"&gt;&lt;span style="font-size:10pt;font-family:Verdana;"&gt;To cut to the chase, the script below can be used to correct the SQL Server 2000 database status, but in reality this is only a third of the equation.&amp;nbsp; We also need to correct any sort of corruption and understand why this occurred in the first place.&amp;nbsp; &lt;/span&gt;&lt;/span&gt;&lt;/p&gt;
&lt;p align="left" style="text-align:left;mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;" class="MsoNormal"&gt;&lt;b&gt;&lt;i&gt;&lt;span style="font-size:x-small;font-family:Verdana;"&gt;&lt;span style="font-weight:bold;font-size:10pt;font-style:italic;font-family:Verdana;"&gt;Database Status Correction Script&lt;/span&gt;&lt;/span&gt;&lt;/i&gt;&lt;/b&gt;&lt;span style="font-size:x-small;font-family:Verdana;"&gt;&lt;span style="font-size:10pt;font-family:Verdana;"&gt;&lt;/span&gt;&lt;/span&gt;&lt;/p&gt;
&lt;p align="left" style="text-align:left;mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;" class="MsoNormal"&gt;&lt;span style="font-size:x-small;font-family:Verdana;"&gt;&lt;span style="font-size:10pt;font-family:Verdana;"&gt;The script below will change the database to be in simple recovery mode, which may or may not be the needed configuration for your database.&amp;nbsp; As such, it is necessary to review your database configurations once this script has been executed.&amp;nbsp; In addition, it is necessary to change the &amp;#39;YourDatabaseName&amp;#39; to your database name in single quotes.&lt;/span&gt;&lt;/span&gt;&lt;/p&gt;
&lt;div align="center"&gt;
&lt;table cellpadding="0" cellspacing="0" style="width:60%;" class="MsoNormalTable"&gt;
&lt;tbody&gt;
&lt;tr&gt;
&lt;td style="padding:2.25pt;"&gt;
&lt;p align="left" style="text-align:left;" class="MsoNormal"&gt;&lt;span style="font-size:x-small;font-family:Arial;"&gt;&lt;span style="font-size:10pt;font-family:Arial;"&gt;USE Master&lt;br /&gt;GO&lt;br /&gt;&lt;br /&gt;-- Determine the original database status&lt;br /&gt;SELECT [Name], DBID, Status&lt;br /&gt;FROM master.dbo.sysdatabases &lt;br /&gt;GO&lt;br /&gt;&lt;br /&gt;-- Enable system changes&lt;br /&gt;sp_configure &amp;#39;allow updates&amp;#39;,1&lt;br /&gt;GO&lt;br /&gt;RECONFIGURE WITH OVERRIDE&lt;br /&gt;GO&lt;br /&gt;&lt;br /&gt;-- Update the database status&lt;br /&gt;UPDATE master.dbo.sysdatabases &lt;br /&gt;SET Status =&amp;nbsp;16 &lt;br /&gt;WHERE [Name] = &amp;#39;YourDatabaseName&amp;#39;&lt;br /&gt;GO&lt;br /&gt;&lt;br /&gt;-- Disable system changes&lt;br /&gt;sp_configure &amp;#39;allow updates&amp;#39;,0&lt;br /&gt;GO&lt;br /&gt;RECONFIGURE WITH OVERRIDE&lt;br /&gt;GO&lt;br /&gt;&lt;br /&gt;-- Determine the final database status&lt;br /&gt;SELECT [Name], DBID, Status&lt;br /&gt;FROM master.dbo.sysdatabases &lt;br /&gt;GO&lt;/span&gt;&lt;/span&gt;&lt;span style="font-size:x-small;font-family:Verdana;"&gt;&lt;span style="font-size:10pt;font-family:Verdana;"&gt;&lt;/span&gt;&lt;/span&gt;&lt;/p&gt;
&lt;/td&gt;
&lt;/tr&gt;
&lt;/tbody&gt;
&lt;/table&gt;
&lt;/div&gt;
&lt;p align="left" style="text-align:left;mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;" class="MsoNormal"&gt;&lt;b&gt;&lt;i&gt;&lt;span style="font-size:x-small;font-family:Verdana;"&gt;&lt;span style="font-weight:bold;font-size:10pt;font-style:italic;font-family:Verdana;"&gt;Check for Corruption&lt;/span&gt;&lt;/span&gt;&lt;/i&gt;&lt;/b&gt;&lt;span style="font-size:x-small;font-family:Verdana;"&gt;&lt;span style="font-size:10pt;font-family:Verdana;"&gt; &lt;/span&gt;&lt;/span&gt;&lt;/p&gt;
&lt;p align="left" style="text-align:left;mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;" class="MsoNormal"&gt;&lt;span style="font-size:x-small;font-family:Verdana;"&gt;&lt;span style="font-size:10pt;font-family:Verdana;"&gt;The next step in this process is very key.&amp;nbsp; It is necessary to determine if the database has any corruption and ensure that the database will be able to support the users.&amp;nbsp; If the database has corruption, you may be exposing yourself to more issues by just changing the database status without correcting the underlying issue.&amp;nbsp; To identify the underlying issue, execute the following commands:&lt;/span&gt;&lt;/span&gt;&lt;/p&gt;
&lt;ul&gt;
&lt;li style="text-align:left;mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;mso-list:l2 level1 lfo1;" class="MsoNormal"&gt;&lt;span style="font-size:x-small;font-family:Verdana;"&gt;&lt;span style="font-size:10pt;font-family:Verdana;"&gt;DBCC CHECKDB - Validate the overall database integrity &lt;/span&gt;&lt;/span&gt;&lt;/li&gt;
&lt;li style="text-align:left;mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;mso-list:l2 level1 lfo1;" class="MsoNormal"&gt;&lt;span style="font-size:x-small;font-family:Verdana;"&gt;&lt;span style="font-size:10pt;font-family:Verdana;"&gt;DBCC CHECKCATALOG - Validate the system catalog integrity &lt;/span&gt;&lt;/span&gt;&lt;/li&gt;
&lt;li style="text-align:left;mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;mso-list:l2 level1 lfo1;" class="MsoNormal"&gt;&lt;span style="font-size:x-small;font-family:Verdana;"&gt;&lt;span style="font-size:10pt;font-family:Verdana;"&gt;DBCC CHECKTABLE - Validate the integrity for a single table&lt;/span&gt;&lt;/span&gt; &lt;/li&gt;
&lt;/ul&gt;
&lt;p align="left" style="text-align:left;mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;" class="MsoNormal"&gt;&lt;span style="font-size:x-small;font-family:Verdana;"&gt;&lt;span style="font-size:10pt;font-family:Verdana;"&gt;To resolve the issue, you may need to do one or more of the following:&lt;/span&gt;&lt;/span&gt;&lt;/p&gt;
&lt;ul&gt;
&lt;li style="text-align:left;mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;mso-list:l0 level1 lfo2;" class="MsoNormal"&gt;&lt;span style="font-size:x-small;font-family:Verdana;"&gt;&lt;span style="font-size:10pt;font-family:Verdana;"&gt;Drop and Recreate Index(es) &lt;/span&gt;&lt;/span&gt;&lt;/li&gt;
&lt;li style="text-align:left;mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;mso-list:l0 level1 lfo2;" class="MsoNormal"&gt;&lt;span style="font-size:x-small;font-family:Verdana;"&gt;&lt;span style="font-size:10pt;font-family:Verdana;"&gt;Move the recoverable data from an existing table to a new table &lt;/span&gt;&lt;/span&gt;&lt;/li&gt;
&lt;li style="text-align:left;mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;mso-list:l0 level1 lfo2;" class="MsoNormal"&gt;&lt;span style="font-size:x-small;font-family:Verdana;"&gt;&lt;span style="font-size:10pt;font-family:Verdana;"&gt;Update statistics &lt;/span&gt;&lt;/span&gt;&lt;/li&gt;
&lt;li style="text-align:left;mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;mso-list:l0 level1 lfo2;" class="MsoNormal"&gt;&lt;span style="font-size:x-small;font-family:Verdana;"&gt;&lt;span style="font-size:10pt;font-family:Verdana;"&gt;DBCC UPDATEUSAGE &lt;/span&gt;&lt;/span&gt;&lt;/li&gt;
&lt;li style="text-align:left;mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;mso-list:l0 level1 lfo2;" class="MsoNormal"&gt;&lt;span style="font-size:x-small;font-family:Verdana;"&gt;&lt;span style="font-size:10pt;font-family:Verdana;"&gt;sp_recompile &lt;/span&gt;&lt;/span&gt;&lt;/li&gt;
&lt;/ul&gt;
&lt;p align="left" style="text-align:left;mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;" class="MsoNormal"&gt;&lt;span style="font-size:x-small;font-family:Verdana;"&gt;&lt;span style="font-size:10pt;font-family:Verdana;"&gt;To ensure the issue is corrected, it is a good idea to re-run the identification commands listed above and validate that they do not have any issues.&lt;/span&gt;&lt;/span&gt;&lt;/p&gt;
&lt;p align="left" style="text-align:left;mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;" class="MsoNormal"&gt;&lt;span style="font-size:x-small;font-family:Verdana;"&gt;&lt;span style="font-size:10pt;font-family:Verdana;"&gt;To address these items, check out the following &lt;a target="_blank" href="http://www.mssqltips.com/" title="http://www.mssqltips.com/"&gt;MSSQLTips.com&lt;/a&gt;:&lt;/span&gt;&lt;/span&gt;&lt;/p&gt;
&lt;ul&gt;
&lt;li style="text-align:left;mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;mso-list:l4 level1 lfo3;" class="MsoNormal"&gt;&lt;span style="font-size:x-small;color:#000000;font-family:Verdana;"&gt;&lt;span style="font-size:10pt;color:black;font-family:Verdana;"&gt;&lt;a target="_blank" href="http://www.mssqltips.com/tip.asp?tip=1013" title="http://www.mssqltips.com/tip.asp?tip=1013"&gt;SQL Server - Performing maintenance tasks&lt;/a&gt;&lt;/span&gt;&lt;/span&gt;&lt;span style="font-size:x-small;font-family:Verdana;"&gt;&lt;span style="font-size:10pt;font-family:Verdana;"&gt; &lt;/span&gt;&lt;/span&gt;&lt;/li&gt;
&lt;li style="text-align:left;mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;mso-list:l4 level1 lfo3;" class="MsoNormal"&gt;&lt;span style="font-size:x-small;font-family:Verdana;"&gt;&lt;span style="font-size:10pt;font-family:Verdana;"&gt;&lt;a target="_blank" href="http://www.mssqltips.com/tip.asp?tip=1029" title="http://www.mssqltips.com/tip.asp?tip=1029"&gt;SQL Server Command Line Tools To Manage Your Server&lt;/a&gt; &lt;/span&gt;&lt;/span&gt;&lt;/li&gt;
&lt;li style="text-align:left;mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;mso-list:l4 level1 lfo3;" class="MsoNormal"&gt;&lt;span style="font-size:x-small;font-family:Verdana;"&gt;&lt;span style="font-size:10pt;font-family:Verdana;"&gt;&lt;a target="_blank" href="http://www.mssqltips.com/tip.asp?tip=1143" title="http://www.mssqltips.com/tip.asp?tip=1143"&gt;Performing SQL Server Maintenance with No Maintenance Window&lt;/a&gt; &lt;/span&gt;&lt;/span&gt;&lt;/li&gt;
&lt;li style="text-align:left;mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;mso-list:l4 level1 lfo3;" class="MsoNormal"&gt;&lt;span style="font-size:x-small;font-family:Verdana;"&gt;&lt;span style="font-size:10pt;font-family:Verdana;"&gt;&lt;a target="_blank" href="http://www.mssqltips.com/tip.asp?tip=1132" title="http://www.mssqltips.com/tip.asp?tip=1132"&gt;Performing Maintenance with Databases in Full Recovery mode&lt;/a&gt;&lt;/span&gt;&lt;/span&gt; &lt;/li&gt;
&lt;/ul&gt;
&lt;p align="left" style="text-align:left;mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;" class="MsoNormal"&gt;&lt;b&gt;&lt;i&gt;&lt;span style="font-size:x-small;font-family:Verdana;"&gt;&lt;span style="font-weight:bold;font-size:10pt;font-style:italic;font-family:Verdana;"&gt;Determine the Root Cause&lt;/span&gt;&lt;/span&gt;&lt;/i&gt;&lt;/b&gt;&lt;span style="font-size:x-small;font-family:Verdana;"&gt;&lt;span style="font-size:10pt;font-family:Verdana;"&gt;&lt;/span&gt;&lt;/span&gt;&lt;/p&gt;
&lt;p align="left" style="text-align:left;mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;" class="MsoNormal"&gt;&lt;span style="font-size:x-small;font-family:Verdana;"&gt;&lt;span style="font-size:10pt;font-family:Verdana;"&gt;In the long term, it is imperative to understand what caused the suspect/offline database.&amp;nbsp; At a minimum the following questions should be addressed:&lt;/span&gt;&lt;/span&gt;&lt;/p&gt;
&lt;ul&gt;
&lt;li style="text-align:left;mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;mso-list:l1 level1 lfo4;" class="MsoNormal"&gt;&lt;span style="font-size:x-small;font-family:Verdana;"&gt;&lt;span style="font-size:10pt;font-family:Verdana;"&gt;What has recently changed in your environment? &lt;/span&gt;&lt;/span&gt;&lt;/li&gt;
&lt;li style="text-align:left;mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;mso-list:l1 level1 lfo4;" class="MsoNormal"&gt;&lt;span style="font-size:x-small;font-family:Verdana;"&gt;&lt;span style="font-size:10pt;font-family:Verdana;"&gt;Review your SQL Server logs to see if you can determine when the error occurred. &lt;/span&gt;&lt;/span&gt;&lt;/li&gt;
&lt;li style="text-align:left;mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;mso-list:l1 level1 lfo4;" class="MsoNormal"&gt;&lt;span style="font-size:x-small;font-family:Verdana;"&gt;&lt;span style="font-size:10pt;font-family:Verdana;"&gt;Talk to your team members to ask them what changes have been made. &lt;/span&gt;&lt;/span&gt;&lt;/li&gt;
&lt;li style="text-align:left;mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;mso-list:l1 level1 lfo4;" class="MsoNormal"&gt;&lt;span style="font-size:x-small;font-family:Verdana;"&gt;&lt;span style="font-size:10pt;font-family:Verdana;"&gt;Review your change management and auditing processes to see what has changed in SQL Server or at a systems level. &lt;/span&gt;&lt;/span&gt;&lt;/li&gt;
&lt;li style="text-align:left;mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;mso-list:l1 level1 lfo4;" class="MsoNormal"&gt;&lt;span style="font-size:x-small;font-family:Verdana;"&gt;&lt;span style="font-size:10pt;font-family:Verdana;"&gt;See if the issue has occurred on any other databases in your environment.&lt;/span&gt;&lt;/span&gt; &lt;/li&gt;
&lt;/ul&gt;
&lt;p align="left" style="text-align:left;mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;" class="MsoNormal"&gt;&lt;b&gt;&lt;span style="text-decoration:underline;"&gt;&lt;span style="font-size:x-small;font-family:Verdana;"&gt;&lt;span style="font-weight:bold;font-size:10pt;font-family:Verdana;"&gt;Next Steps&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/b&gt;&lt;span style="font-size:x-small;font-family:Verdana;"&gt;&lt;span style="font-size:10pt;font-family:Verdana;"&gt;&lt;/span&gt;&lt;/span&gt;&lt;/p&gt;
&lt;ul&gt;
&lt;li style="text-align:left;mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;mso-list:l3 level1 lfo5;" class="MsoNormal"&gt;&lt;span style="font-size:x-small;font-family:Verdana;"&gt;&lt;span style="font-size:10pt;font-family:Verdana;"&gt;Although the script from this tip can be easily run, it is necessary to understand why the issue occurred and be sure not to have any corruption moving forward. &lt;/span&gt;&lt;/span&gt;&lt;/li&gt;
&lt;li style="text-align:left;mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;mso-list:l3 level1 lfo5;" class="MsoNormal"&gt;&lt;span style="font-size:x-small;font-family:Verdana;"&gt;&lt;span style="font-size:10pt;font-family:Verdana;"&gt;Heed caution and truly understand the situation before running this script and make sure you do not cause any further issues. &lt;/span&gt;&lt;/span&gt;&lt;/li&gt;
&lt;li style="text-align:left;mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;mso-list:l3 level1 lfo5;" class="MsoNormal"&gt;&lt;span style="font-size:x-small;font-family:Verdana;"&gt;&lt;span style="font-size:10pt;font-family:Verdana;"&gt;For additional information reference: &lt;/span&gt;&lt;/span&gt;
&lt;ul&gt;
&lt;li style="text-align:left;mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;mso-list:l3 level2 lfo5;" class="MsoNormal"&gt;&lt;span style="font-size:x-small;font-family:Verdana;"&gt;&lt;span style="font-size:10pt;font-family:Verdana;"&gt;&lt;a target="_blank" href="http://msdn2.microsoft.com/en-us/library/aa260406(SQL.80).aspx" title="http://msdn2.microsoft.com/en-us/library/aa260406(SQL.80).aspx"&gt;master.dbo.sysdatabases &lt;/a&gt;system table &lt;/span&gt;&lt;/span&gt;&lt;/li&gt;
&lt;li style="text-align:left;mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;mso-list:l3 level2 lfo5;" class="MsoNormal"&gt;&lt;span style="font-size:x-small;font-family:Verdana;"&gt;&lt;span style="font-size:10pt;font-family:Verdana;"&gt;&lt;a target="_blank" href="http://msdn2.microsoft.com/en-us/library/aa259616(SQL.80).aspx" title="http://msdn2.microsoft.com/en-us/library/aa259616(SQL.80).aspx"&gt;sp_configure&lt;/a&gt; system stored procedure&lt;/span&gt;&lt;/span&gt; &lt;/li&gt;
&lt;/ul&gt;
&lt;/li&gt;
&lt;li style="text-align:left;mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;mso-list:l3 level1 lfo5;" class="MsoNormal"&gt;&lt;span style="font-size:x-small;font-family:Verdana;"&gt;&lt;span style="font-size:10pt;font-family:Verdana;"&gt;Check out the following &lt;a target="_blank" href="http://www.mssqltips.com/" title="http://www.mssqltips.com/"&gt;MSSQLTips.com&lt;/a&gt;: &lt;/span&gt;&lt;/span&gt;
&lt;ul&gt;
&lt;li style="text-align:left;mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;mso-list:l3 level2 lfo5;" class="MsoNormal"&gt;&lt;span style="font-size:x-small;color:#000000;font-family:Verdana;"&gt;&lt;span style="font-size:10pt;color:black;font-family:Verdana;"&gt;&lt;a target="_blank" href="http://www.mssqltips.com/tip.asp?tip=1013" title="http://www.mssqltips.com/tip.asp?tip=1013"&gt;SQL Server - Performing maintenance tasks&lt;/a&gt;&lt;/span&gt;&lt;/span&gt;&lt;span style="font-size:x-small;font-family:Verdana;"&gt;&lt;span style="font-size:10pt;font-family:Verdana;"&gt; &lt;/span&gt;&lt;/span&gt;&lt;/li&gt;
&lt;li style="text-align:left;mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;mso-list:l3 level2 lfo5;" class="MsoNormal"&gt;&lt;span style="font-size:x-small;font-family:Verdana;"&gt;&lt;span style="font-size:10pt;font-family:Verdana;"&gt;&lt;a target="_blank" href="http://www.mssqltips.com/tip.asp?tip=1029" title="http://www.mssqltips.com/tip.asp?tip=1029"&gt;SQL Server Command Line Tools To Manage Your Server&lt;/a&gt; &lt;/span&gt;&lt;/span&gt;&lt;/li&gt;
&lt;li style="text-align:left;mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;mso-list:l3 level2 lfo5;" class="MsoNormal"&gt;&lt;span style="font-size:x-small;font-family:Verdana;"&gt;&lt;span style="font-size:10pt;font-family:Verdana;"&gt;&lt;a target="_blank" href="http://www.mssqltips.com/tip.asp?tip=1143" title="http://www.mssqltips.com/tip.asp?tip=1143"&gt;Performing SQL Server Maintenance with No Maintenance Window&lt;/a&gt; &lt;/span&gt;&lt;/span&gt;&lt;/li&gt;
&lt;li style="text-align:left;mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;mso-list:l3 level2 lfo5;" class="MsoNormal"&gt;&lt;span style="font-size:x-small;font-family:Verdana;"&gt;&lt;span style="font-size:10pt;font-family:Verdana;"&gt;&lt;a target="_blank" href="http://www.mssqltips.com/tip.asp?tip=1132" title="http://www.mssqltips.com/tip.asp?tip=1132"&gt;Performing Maintenance with Databases in Full Recovery mode&lt;/a&gt; &lt;/span&gt;&lt;/span&gt;&lt;/li&gt;
&lt;li style="text-align:left;mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;mso-list:l3 level2 lfo5;" class="MsoNormal"&gt;&lt;span style="font-size:x-small;font-family:Verdana;"&gt;&lt;span style="font-size:10pt;font-family:Verdana;"&gt;&lt;a target="_blank" href="http://www.mssqltips.com/tip.asp?tip=1040" title="http://www.mssqltips.com/tip.asp?tip=1040"&gt;Server Info = SQL Server 2000 to 2005 Crosswalk&lt;/a&gt; &lt;/span&gt;&lt;/span&gt;&lt;/li&gt;
&lt;li style="text-align:left;mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;mso-list:l3 level2 lfo5;" class="MsoNormal"&gt;&lt;span style="font-size:x-small;font-family:Verdana;"&gt;&lt;span style="font-size:10pt;font-family:Verdana;"&gt;&lt;a target="_blank" href="http://www.mssqltips.com/tip.asp?tip=960" title="http://www.mssqltips.com/tip.asp?tip=960"&gt;SQL 2000 to 2005 Crosswalk - Startup Parameters&lt;/a&gt; &lt;/span&gt;&lt;/span&gt;&lt;/li&gt;
&lt;li style="text-align:left;mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;mso-list:l3 level2 lfo5;" class="MsoNormal"&gt;&lt;span style="font-size:x-small;font-family:Verdana;"&gt;&lt;span style="font-size:10pt;font-family:Verdana;"&gt;&lt;a target="_blank" href="http://www.mssqltips.com/tip.asp?tip=1013" title="http://www.mssqltips.com/tip.asp?tip=1013"&gt;SQL Server - Performing maintenance tasks&lt;/a&gt;&lt;/span&gt;&lt;/span&gt; &lt;/li&gt;
&lt;/ul&gt;
&lt;/li&gt;
&lt;/ul&gt;&lt;div style="clear:both;"&gt;&lt;/div&gt;&lt;img src="http://community.sgdotnet.org/aggbug.aspx?PostID=224282" width="1" height="1"&gt;</content><author><name>darenhan</name><uri>http://community.sgdotnet.org/members/darenhan/default.aspx</uri></author></entry><entry><title>Turn an ipod touch into an iphone (well almost)</title><link rel="alternate" type="text/html" href="/blogs/darenhan/archive/2009/04/10/turn-an-ipod-touch-into-an-iphone-well-almost.aspx" /><id>/blogs/darenhan/archive/2009/04/10/turn-an-ipod-touch-into-an-iphone-well-almost.aspx</id><published>2009-04-10T03:11:00Z</published><updated>2009-04-10T03:11:00Z</updated><content type="html">&lt;p&gt;&amp;nbsp;&lt;/p&gt;
&lt;p&gt;I found a link that describes how to make an ipod touch becomes almost an iphone. There is no hacking involved. So safe to try it out if you are a vivid ipod fan.&lt;/p&gt;
&lt;p&gt;&lt;a href="http://www.pocketgadget.org/2009/04/07/turn-your-ipod-touch-into-an-iphone-almost/"&gt;http://www.pocketgadget.org/2009/04/07/turn-your-ipod-touch-into-an-iphone-almost/&lt;/a&gt;&lt;/p&gt;
&lt;p&gt;&amp;nbsp;&lt;/p&gt;&lt;div style="clear:both;"&gt;&lt;/div&gt;&lt;img src="http://community.sgdotnet.org/aggbug.aspx?PostID=224211" width="1" height="1"&gt;</content><author><name>darenhan</name><uri>http://community.sgdotnet.org/members/darenhan/default.aspx</uri></author></entry><entry><title>12 Macheist apps for the price for $39 (9 days left for offer)</title><link rel="alternate" type="text/html" href="/blogs/darenhan/archive/2009/03/29/12-macheist-apps-for-the-price-for-39-9-days-left-for-offer.aspx" /><id>/blogs/darenhan/archive/2009/03/29/12-macheist-apps-for-the-price-for-39-9-days-left-for-offer.aspx</id><published>2009-03-29T14:52:00Z</published><updated>2009-03-29T14:52:00Z</updated><content type="html">&lt;p&gt;This year&amp;#39;s bundle features a core lineup of a dozen award winning and popular apps, games and utilities that represent the cream of the crop from the Mac development community. Whether you&amp;#39;re interested in cooking a meal, or playing the best puzzle game of last year, or selling off an old item on Ebay, the MacHeist bundle has you covered. And for the first time ever, the MacHeist bundle can be yours for just $39.&lt;/p&gt;
&lt;p&gt;MacHeist is also donating 25% of each bundle purchase to a partnering charity of the customer&amp;#39;s choice. To date, MacHeist customers have raised over $700,000 for philanthropic efforts around the world. You can find out more about this year&amp;#39;s participating charities here.&lt;/p&gt;
&lt;p&gt;You&amp;rsquo;ll be able to choose where your money goes when you purchase the bundle. The participating charities are listed below:&lt;/p&gt;
&lt;div class="column uno"&gt;
&lt;h3&gt;&lt;a target="_blank" href="http://www.actionagainsthunger.org/"&gt;&lt;img src="http://static.macheist.com/sales-bundle/charities/actionagainsthunger.png" alt="" /&gt;Action Against Hunger&lt;/a&gt;&lt;/h3&gt;
&lt;p&gt;An international network committed to saving the lives of malnourished children and families while ensuring access to safe water and sustainable solutions to hunger.&lt;/p&gt;
&lt;h3&gt;&lt;a target="_blank" href="http://www.aidsresearch.org/"&gt;&lt;img src="http://static.macheist.com/sales-bundle/charities/aidsresearchalliance.png" alt="" /&gt;AIDS Research Alliance&lt;/a&gt;&lt;/h3&gt;
&lt;p&gt;Pioneering a revolutionary business model for conducting medical research in the United States, influencing the direction of HIV research along the way.&lt;/p&gt;
&lt;h3&gt;&lt;a target="_blank" href="http://www.climateprotect.org/"&gt;&lt;img src="http://static.macheist.com/sales-bundle/charities/allianceforclimateprotection.png" alt="" /&gt;Alliance for Climate Protection&lt;/a&gt;&lt;/h3&gt;
&lt;p&gt;Persuading people around the world of the importance and urgency of adopting and implementing effective and comprehensive solutions for the climate crisis.&lt;/p&gt;
&lt;h3&gt;&lt;a target="_blank" href="http://www.directrelief.org/"&gt;&lt;img src="http://static.macheist.com/sales-bundle/charities/directreliefinternational.png" alt="" /&gt;Direct Relief International&lt;/a&gt;&lt;/h3&gt;
&lt;p&gt;Provides medical assistance to improve the quality of life for people affected by poverty, disaster, and civil unrest at home and throughout the world.&lt;/p&gt;
&lt;h3&gt;&lt;a target="_blank" href="http://hsus.org/about_us/humane_society_international_hsi/"&gt;&lt;img src="http://static.macheist.com/sales-bundle/charities/humanesociety.png" alt="" /&gt;Humane Society International&lt;/a&gt;&lt;/h3&gt;
&lt;p&gt;Addresses animal issues that cross many borders and impact millions of animals worldwide.&lt;/p&gt;
&lt;/div&gt;
&lt;div class="column"&gt;
&lt;h3&gt;&lt;a target="_blank" href="http://www.nature.org/"&gt;&lt;img src="http://static.macheist.com/sales-bundle/charities/naturalconservancy.png" alt="" /&gt;The Nature Conservancy&lt;/a&gt;&lt;/h3&gt;
&lt;p&gt;The leading conservation organization working around the world to protect ecologically important lands and waters for nature and people.&lt;br /&gt;&amp;nbsp;&lt;/p&gt;
&lt;h3&gt;&lt;a target="_blank" href="http://www.savethechildren.org/"&gt;&lt;img src="http://static.macheist.com/sales-bundle/charities/savethechildren.png" alt="" /&gt;Save the Children&lt;/a&gt;&lt;/h3&gt;
&lt;p&gt;The leading independent organization creating lasting change in the lives of children in need around the world.&lt;/p&gt;
&lt;h3&gt;&lt;a target="_blank" href="http://www.savedarfur.org/"&gt;&lt;img src="http://static.macheist.com/sales-bundle/charities/savedarfur.png" alt="" /&gt;Save Darfur&lt;/a&gt;&lt;/h3&gt;
&lt;p&gt;Inspiring action, raising awareness, and speaking truth to power on behalf of the people of Darfur in an effort to end the genocide plaguing the country.&lt;/p&gt;
&lt;h3&gt;&lt;a target="_blank" href="http://www.preventcancer.org/"&gt;&lt;img src="http://static.macheist.com/sales-bundle/charities/preventcancerfoundation.png" alt="" /&gt;Prevent Cancer Foundation&lt;/a&gt;&lt;/h3&gt;
&lt;p&gt;Cancer prevention and early detection through research, education and community outreach to all populations, including children and the underserved.&lt;/p&gt;
&lt;h3&gt;&lt;a target="_blank" href="http://www.worldwildlife.org/"&gt;&lt;img src="http://static.macheist.com/sales-bundle/charities/wwf.png" alt="" /&gt;World Wildlife Fund&lt;/a&gt;&lt;/h3&gt;
&lt;p&gt;The leader in wildlife conservation and preservation of animal habitats around the world.&lt;/p&gt;
&lt;/div&gt;
&lt;p&gt;&amp;nbsp;&lt;/p&gt;
&lt;p&gt;Get the Mac apps bundle here:&lt;/p&gt;
&lt;p&gt;&lt;a href="http://www.macheist.com/bundle/u/167185/"&gt;http://www.macheist.com/bundle/u/167185/&lt;/a&gt;&lt;/p&gt;
&lt;p&gt;Only 9 days left for the offer.&amp;nbsp;&lt;/p&gt;
&lt;p&gt;&amp;nbsp;&lt;/p&gt;&lt;div style="clear:both;"&gt;&lt;/div&gt;&lt;img src="http://community.sgdotnet.org/aggbug.aspx?PostID=224187" width="1" height="1"&gt;</content><author><name>darenhan</name><uri>http://community.sgdotnet.org/members/darenhan/default.aspx</uri></author></entry><entry><title>The formatter threw an exception while trying to deserialize the message</title><link rel="alternate" type="text/html" href="/blogs/darenhan/archive/2009/03/17/the-formatter-threw-an-exception-while-trying-to-deserialize-the-message.aspx" /><id>/blogs/darenhan/archive/2009/03/17/the-formatter-threw-an-exception-while-trying-to-deserialize-the-message.aspx</id><published>2009-03-17T04:08:00Z</published><updated>2009-03-17T04:08:00Z</updated><content type="html">&lt;p&gt;I got this error when programming in dot net 3.5 using WCF:&lt;/p&gt;
&lt;p&gt;The formatter threw an exception while trying to deserialize the message: There was an error while trying to deserialize parameter &lt;a href="http://tempuri.org/:parameter"&gt;http://tempuri.org/:parameter&lt;/a&gt;. The InnerException message was &amp;#39;There was an error deserializing the object of type XXXXXXXX. The maximum string content length quota (8192) has been exceeded while reading XML data. This quota may be increased by changing the MaxStringContentLength property on the XmlDictionaryReaderQuotas object used when creating the XML reader.&amp;#39;.&amp;nbsp; Please see InnerException for more details.&lt;/p&gt;
&lt;p&gt;Solution:&lt;br /&gt;Find the immediate window in vs2008 and checkout the length of the string by using the length function.&lt;br /&gt;estimate and assign the MaxStringContentLenth to more than the length of the string&lt;br /&gt;in the WCF configuration editor.&lt;/p&gt;
&lt;p&gt;MaxStringContentLenth&amp;nbsp; =&amp;nbsp;Y megabytes * 1024 * 1024.&lt;/p&gt;
&lt;p&gt;&amp;nbsp;&lt;/p&gt;&lt;div style="clear:both;"&gt;&lt;/div&gt;&lt;img src="http://community.sgdotnet.org/aggbug.aspx?PostID=224156" width="1" height="1"&gt;</content><author><name>darenhan</name><uri>http://community.sgdotnet.org/members/darenhan/default.aspx</uri></author></entry></feed>