Sumit Gupta

Author: 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…

  • 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…

  • 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…

  • 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…

  • 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

  • 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…

  • 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