URL Rewrite in wordpress on plesk for windows

Problem: When we install wordpress on windows with plesk, URL rewrite does not work as expected. It gives 404 error.

Solution: Create a web.config file with following code





<configuration> <system.webServer> <rewrite> <rules> <rule name="wordpress" patternSyntax = "Wildcard"> <match url="*" /> <conditions> <add input="{REQUEST_FILENAME}" matchType = "IsFile" negate = "true" /> <add input="{REQUEST_FILENAME}" matchType = "IsDirectory" negate = "true" /> </conditions> <action type="Rewrite" url="index.php" /> </rule> </rules> </rewrite> </system.webServer> </configuration>

Place it in your root directory. Woha problem solved...

Display more than 20 records in DataViewer Consol

By default when we click on Datastore Viewer in App-Engine Consol, It shows 20 records per page.

If I have thousands of records, I would like to see at least 100 records per page.

There is no setting for no of records per page.

To view 100 records per page:

1. Open Datastore Viewer.
2. Click on Next 20 Link.
3. Copy and Paste URL in address bar to a Notepad.
4. It look something like this
https://appengine.google.com/datastore/explorer?app_id=xxxxxxxxxx&kind=xxxxx&viewby=kind&query=SELECT%20*%20FROM%20xxxxx&limit=20&offset=20

5.Change limit and offset both to 100.

6.Copy and paste new URL to browser.

7.See 100 records listing. Now it also show next 100.

Deploying Crystal Report

Crystal Report's assemlies require separate installation, when you deploy your .Net applucation having crstal report.

Use followinf re-disrtributable package:

For VS 2005
C:\Program Files\Microsoft Visual Studio 8\SDK\v2.0\BootStrapper\Packages\CrystalReports\CRRedist2005_x86.msi

For VS 2008
C:\Program Files\Microsoft SDKs\Windows\v6.0A\BootStrapper\Packages\CrystalReports10_5\CRRedist2008_x86.msi

Troublshooting Service Broker

Recently i was troublshooting a service broker application.
Here are the useful objects
sys.conversation_endpoints Catelog


is_broker_enabled field in sys.databases
Should be enabled

If disabled try following statements
ALTER DATABASE my_database SET SINGLE_USER
ALTER DATABASE my_database SET ENABLE_BROKER
ALTER DATABASE my_database SET MULTI_USER

(It is very strang after a abnormal shutdown of SQL Server, database goes to recovery mode. When it come back the is_broker_enabled was disabled. It took 3 hrs. to identify the problem :(
)