.NET Generic Handler(ashx) Object to JSON Serialization

public class jsonSample : IHttpHandler
{
    public void ProcessRequest(HttpContext context)
    {
        context.Response.ContentType = "application/json";

        Person p = new Person();
        p.name = "Richard";
        p.address.Add("Taipei");
        p.address.Add("US");

        // .NET 3.5 & 4 solution 
        // Reference : http://msdn.microsoft.com/en-us/library/system.web.script.serialization.javascriptserializer.aspx
        System.Web.Script.Serialization.JavaScriptSerializer serializer =
            new System.Web.Script.Serialization.JavaScriptSerializer();
        context.Response.Write(serializer.Serialize(p));

        // Json.NET solution 
        // Reference : http://json.codeplex.com/
        context.Response.Write(Newtonsoft.Json.JsonConvert.SerializeObject(p));

        /* Result:
            * 
            *   {"name":"Richard","address":["Taipei","US"]}     
            * 
            */
    }

    public bool IsReusable
    {
        get
        {
            return false;
        }
    }
}

public class Person
{
    public List<string> address = new List<string>();
    public string name;   
}

Speed up SQL Server Management Studio (SSMS)

 

[Solution] : Add an entry in your HOSTS

1. Press the keys [Win] + [R]
2. notepad %systemroot%\system32\drivers\etc\hosts.
3. Append the following..
   127.0.0.1    crl.microsoft.com
4. Save the file.

ref: http://www.virtualobjectives.com.au/sqlserver/ssms_slow.htm

[Solution] : Use sqlwb Utility –nosplash arguments

ex:

• ssms.exe –nosplash
• ssms.exe -nosplash -S "."
• ssms.exe -nosplash -S ".\SQLEXPRESS"

ref: http://msdn.microsoft.com/en-us/library/ms162825%28v=sql.90%29.aspx

[Solution] : Uncheck “Check publisher’s certificate revocation”

1. Go into IE, select Tools|Internet Options|Advanced
2. If “Check publisher's certificate revocation” under the security node is checked, then uncheck it.

ref: http://blogs.msdn.com/b/euanga/archive/2006/07/11/662053.aspx