DarenHan's Blog

SQL Profiler for express edition

2012-04-23T23:48:00Z

I just started using SQL Server express edition 2008 R2 in my workplace. But the express edition does not have a profiler to trap the errors.

SQL Profiler is only available for developer editions and beyond.

I found this neat tool that works like sql profiler and it is free for download.

http://code.google.com/p/sqlexpressprofiler/downloads/list

Grab it while you can.. :)

TripWolf Travel Guides free for iPhone and Android users (5 apps per day) in celebration of their win.

2011-12-01T08:01:00Z

Below are the schedule when the apps turned free. Each of them cost $5.99 usd. It will be worthwhile if you do travel a lot. For Android users, all tripwolf guides are also available in the Android Market

Thursday December 1st

Italy, Amsterdam, Istanbul, Cologne, Linz

Friday December 2nd

London, Florence, Copenhagen, Oslo, Leipzig

Saturday December 3rd

New York City, Lisbon, Dublin, Dresden, Saint Petersburg

Sunday December 4th

Austria, Mailand, Frankfurt am Main, Valencia, Bordeaux

Monday December 5th

Paris, Stockholm, Porto, Turin, Stuttgart

Tuesday December 6th

Venice, Sevilla, Nice, Glasgow, Düsseldorf

Wednesday December 7th

Vienna, Hamburg, Brussels, Palma de Mallorca, Genoa

Thursday December 8th

Barcelona, Edinburgh, Bologna, Marseille, Heidelberg

Friday December 9th

Bangkok, Los Angeles, Melbourne, Chicago, Dubrovnik

Saturday December 10th

Budapest, San Francisco, Hongkong, Singapore, Rio de Janeiro

Sunday December 11th

Prague, Vancouver, Sydney, Cape Town, Delhi

Monday December 12th

Las Vegas, Buenos Aires, Athens, Tokyo, Cairo

Tuesday December 13th

Shanghai, Hanoi, Dubai, Beijing

Some new RedGate products relevant to developers.

2011-12-01T07:52:00Z

SmartAssembly:

This is a tool to obfuscate your .NET code using SmartAssembly

Free eBook "Troubleshooting SQL Server: A Guide for the Accidental DBA"

2011-12-01T07:48:00Z

Get Jonathan Kehayias' eBook 'Troubleshooting SQL Server' to help you diagnose and solve common performance problems.

Download your copy now!

PopCap PC Game "Zuma" is free for download.

2011-11-27T01:17:00Z

Link: http://www.popcap.com/promos/2011/zuma/free/?cid=fb:popcap:zumafree

Use the coupon code to checkout the game free.

The coupon code is valid till 29 Nov 2011.

Lavasoft Ad-ware Pro is free for download on 28 Dec 2010

2010-12-28T20:40:00Z

Go to the url on today 28th Dec and download the software to get rid of malware. It is a free for 24 hours. So get your copy before it is too late.

http://reviews.cnet.com/exclusives/

Troubleshooting a page not found error on file server

2010-05-24T06:48:00Z

I hit this error "The page is not found" when the customer browse a file from our file server from our web pages which are hosted on IIS 6. The problem with IIS 6 is that the error messages are not very clear, hence it is tougher to troubleshoot.

- Things we have tried but didn't work

1. Change the IIS anonymous account to a domain service account to access the file server.

2. Re-inherit the permissions of the read-write permissions from windows explorer in the file server and propagate the folder access permissions. It gives me error saying the file is not able to change permissions.

- Things I have tried to fix the error

1. Take out the url and create a sample virtual directory to point to the file server and see what is wrong. I begin remove bits and pieces of the url till I get it right.

2. Change the permissions of the read-write permissions from IIS instead of the previous approach. It allows me to do that without any errors.

3. Recreate the IIS folders which point to the file server folders as it seems the IIS anonymous account password is corrupted.

Error message "Operation Must Use an Updateable Query"

2010-05-24T06:44:00Z

I got this error from a asp.net web page exporting data to an excel file.

From the looks of it, it look mysterious.

But the microsoft kb article is quite useful -> http://support.microsoft.com/kb/316475

I read point #2 from the kb article and set the folder which I am writing to from read-only to write and it solves my problem!

- Make sure that the file that you are trying to open is not saved as ReadOnly.

Unable to access web services from remote machine

2010-05-01T07:17:00Z

I encountered the above mentioned error when accessing from a remote machine other than the server where the web service is hosted.

To solve the error,

I added the following chunk of configuration after <system.web> tag in the web.config in the web services project file.

Hope this is useful to people who are new to creating web services.

"Requested registry access is not allowed" error message when you try to create a custom event log

2010-04-30T07:25:00Z

I encountered this error when deploying my web services on the server. As I am writing a custom error to the event viewer, it prompts me that I do not have sufficient rights to write to the event viewer.

What I did was:

Log on to the computer as an administrator.
Click Start, click Run, type regedit in the Open box, and then click OK. The Registry Editor window appears.
Locate the following registry subkey:
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\Eventlog
Right-click Eventlog, and then click Permissions. The Permissions for Eventlog dialog box appears.
Click Advanced. The Advanced Security Settings for Eventlog dialog box appears.
In the Name column, double-click the Users group. The Permission Entry for Eventlog dialog box appears.
Select the Set Value check box, select the Create Subkey check box, and then click OK.
Quit Registry Editor, and then log off from the administrator account.
Log on to the computer as a regular user.
Try to create a custom event log by using Visual Studio .NET, and then try to write to this event log by using an application that is built on Visual Studio .NET.

Source of info: http://support.microsoft.com/kb/842795

Note: You can allow Everyone access rights to write to the event viewer but will probably raise some security issues. What the above method is proposing to allow rights to write or create the subkey in event viewer only.

Get Wondershare Office Recovery v1.5 free while stocks last

2010-03-01T02:18:00Z

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.

Now, there is a chance to get a free copy of Wondershare Office Recovery 1.5.

Just go to the link below and

http://www.data-recovery-utilities.com/office-recovery/get-keycode.html

Trend Micro Internet Security 2010 free updates for 1 year for Mac / PC.

2010-02-28T13:39:00Z

Step one:

Go to this link and download the version for PC or Mac on the right hand side - top.

http://shop.trendmicro.com/iomega/en/?sn=f9bj26006x

Step two:

Install the trial but when the installation finishes, you can register your email and you get 1 year free updates as well as subscription.

Enjoy!

After server security patches, the sharing folder permissions disappears. Here is a quick fix.

2010-02-24T08:29:00Z

Source: http://support.microsoft.com/?kbid=125996

To save only the existing share names and their permissions on Windows follow these steps.

Note This procedure applies only to NetBIOS shares and not to Macintosh volumes.

On the existing Windows installation that contains the share names and permissions that you want to save, start Registry Editor (Regedt32.exe).
From the HKEY_LOCAL_MACHINE subtree, go to the following key:
SYSTEM\CurrentControlSet\Services\LanmanServer\Shares
Save or export the registry key.
- For Windows NT and Windows 2000, click Save Key on the Registry menu.
- For Windows Server 2003, click Export on the File menu.
Type a new file name (a file extension is not necessary), and then save the file to a floppy disk.
Reinstall Windows.
Run Registry Editor (Regedt32.exe).
From the HKEY_LOCAL_MACHINE subtree, go to the following key:
SYSTEM\CurrentControlSet\Services\LanmanServer\Shares
Restore or import the registry key.
- For Windows NT and Windows 2000, click Restore on the Registry menu.
- For Windows Server 2003, click Import on the File menu.
Type the path and file name of the file that you saved in steps 3 and 4.

Caution 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.
Restart the server.

Note 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 net shares 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.

In Windows NT 3.5, if you click Stop Sharing in File Manager, the restored shares are still displayed, but they are dimmed.

Only permissions for domain users are restored. If a local user was created in the previous Windows NT installation, that local user's unique security identifier (SID) is lost. NTFS permissions on folders and files are not affected when you save and restore the shares key.

Note: This article does not apply to Windows Server 2008 or Windows Server 2008 R2.

Resize your hard disk partitions for free using EASEUS Partition Master 4.1.1 Home Edition

2010-01-01T03:03:00Z

EASEUS Partition Master Home Edition is a FREE disk partitioning utility for extending system partition, better disk space management, settling low disk space problem under Windows 2000/XP/Vista/Windows 7 (for 32 bit Only - How to figure out Windows 32 bit or 64 bit?).

Check it out:

http://www.partition-tool.com/personal.htm

Could not load file or assembly 'CrystalDecision.web, version=10.5.3700' on web page.

2009-12-30T08:46:00Z

Problem:

Could not load file or assembly 'CrystalDecision.web, version=10.5.3700' 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.

<% Register TagPrefix="cr" Namespace="CrystalDecisions.Web" Assembly="CrystalDecision.Web, Version=10.5.37... %>

Solution:

Navigate to SAP BusinessObjects url : http://wiki.sdn.sap.com/wiki/pages/viewpage.action?pageId=56787567

And download the crystal dlls version 10.5.37. Install the crystal GAC dlls on the web server.

Restart the IIS as the GAC is now refreshed with the latest crystal reports dll.