Sumit Gupta

Sql optimization

Today, I experience a slow down in one of website I just finish building up. It was a intereting project which has ability to create Dynamic form and hence the related dynamic database tables. But the problem was in part where we preload user information and later show them on our dynamic forms when user…

July 12, 2011
ASP.NET JavascriptSerializer for Array

I need to throw some database entry which are as simple as TIME, for this I got a string array in my ASP.NET code behind. I was throwing this String Array in JSON format after using JavascriptSerialize.Serialize method and it is making not so perfect Json script. I said it is not making perfect json…

May 28, 2011
Classic ASP : Enable Debug mode on IIS7

After a long time today I need to work on Classic ASP website. Ofcourse, it was debugging job and the first hurdle was to make the site running in my test environment where unfortunately I don’t have Debugging for ASP.net enabled. So, I thought to do that by changing my IIS 7 setting so I…

May 27, 2011
Read System TimeZone to DB

I was looking for the TimeZone Database which also need to told me if Given Timezone is DayLightSaving enabled or not. After searching few hours on Internet I found few database that do not tell the Daylight Saving stuff. Then I found a function in TimeZoneInfo class that list all System Timezone, I loop through…

May 7, 2011
Reseed Auto Increment Value in SQL Server

You can reseed the Auto increment field to desire number by using following SQL statement [I think it is specific for SQL Server only] other Database have their own methods. DBCC CHECKIDENT (<TableName>, RESEED, 0) Works great for me on Sql Server 2008

May 7, 2011
MySql 5.5 : funny about it

Just saw the release note of MySql 5.5. Looks exciting upgrade, but what looks most funny about the software is the fact that they claim to improve performance by 1500% on windows [some 372% on linux]. Looks great work by them. But I found this information funny, as my some Open source lover friends always…

April 25, 2011
Ejabbered – Service Failure on Window

Found a fix for this “Error 1075: The dependency service does not exist or has been marked for deletion” 1. Open RegEdit2. Navigate to this key:HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\ejabberd3. Under “DependOnService”, change “LanmanWorkstation” to “” (empty string)4. Reboot

April 21, 2011