Sandip's Programming Zen

An attempt to share tech/coding experiences

Archive for June 2008

Interesting SQL Server stuff

leave a comment »

1. This article explains how to track SQL Server 2005 deadlocks using Profiler tool.

2. An open source project at coldeplex to compare two SQL Server 2005 databases.

Advertisements

Written by Sandip

June 30, 2008 at 5:41 am

Posted in MS SQL

Tagged with

An ice-free North Pole this summer?

leave a comment »

Researchers have said that North Pole will be completely ice-free this summer. This is going to happen first time in recorded human history. This is shocking and too quick I was tracking a similar story published on Dec ’07, which quoted that North Pole could be ice-free in 5-6 years. I think this is the most visible effect of global warming so far.

Hope not to see more such disturbing effects.

Ref 1, Ref 2

Written by Sandip

June 29, 2008 at 8:47 am

Posted in Global Warming

Running Asp.Net 1.1 and 2.0 together in Windows 64-bit environment

leave a comment »

To be noted, Microsoft is not going to release 64-bit version of .Net framework 1.1. So installing it on Windows 2003 64-bit OS will require it to run in “32-bit mode”. Normally this is done easily when you try to install FW 1.1 on OS it will ask you to run a command during installation and that enables IIS to run FW 1.1 in 32-bit mode.

Asp.Net Tab in IIS MMC will be missing so assigning different FW version to different websites should be done using command line tool : aspnet_regiis.exe (it is separate for each FW version and can be found in framework directory e.g. C:\WINDOWS\Microsoft.NET\Framework\v1.1.4322)

Examples:
aspnet_regiis.exe -s W3SVC/1/ROOT/<yourappname>       (for recursive update)
aspnet_regiis.exe -sn W3SVC/1/ROOT/<yourappname>     (for non-recursive update)

For more details visit here.

Written by Sandip

June 26, 2008 at 10:45 am

Posted in Troubleshooting

Tagged with , ,

Migrating SQL Server 2000 database to SQL Server 2005

leave a comment »

SQL Server 2005 has a feature called “Copy Database” (you can right click on any database or server instance to find it). The function copies database from target sql server 2000 to the sql server 2005 while still keeping it online for target database users.

In my case, I ran through the migration wizard and in the last step which it actually runs the package which migrates database, it failed. It did not shown any proper error message so that I can find out what went wrong. I did it again and this time making sure I exactly follow the process but result was same.

So it did not go smooth. So I opted to do it crude way, by detaching and reattaching the database mdf file in sql server 2005. That worked. Then I had to migrate all dependent sql jobs and DTS packages manually as well.

Written by Sandip

June 22, 2008 at 10:56 am

Posted in MS SQL

A small but important performance booster

with one comment

Web applications which send out email notifications as part of their user interaction process normally works fine, but as they grow in terms of number of users it tends to feel slower in parts where email is sending out in background. Reason is obvious, your smtp server has to handle more request then before and it takes time to process each email request, so your main application thread has to wait (and so does user).

Solution is simple, just isolate your email sending functions by creating separate thread (and also set it on low priority). This way your main application thread (and thus your users) does not have to wait them processed.

I have seen simple functions to take around 30 seconds to process just because email sending function is waiting in background just to get an time out error from smtp server.

Written by Sandip

June 22, 2008 at 10:17 am

Posted in Programming

SQL Server Scale Out

leave a comment »

This msdn blog post compiles important links on SQL server scaling and performance.

Written by Sandip

June 16, 2008 at 11:23 am

Posted in MS SQL

Firefox 3.0 coming on Tuesday, are you ready to migrate?

leave a comment »

Firefox 3.0 is slated to be released on coming Tuesday. I am using it since they have released first beta. It freaking cool browser, but are you ready to migrate from your FF 2.0?
There are number of popular add-ons not compatible with FF 3.0.

Check compatibility report online here.

Written by Sandip

June 12, 2008 at 1:53 pm

Posted in Softwares