Gokul's Blog


Leave a comment

Enable SQL CLR

USE MASTER
GO
GRANT EXTERNAL ACCESS ASSEMBLY TO [TestUser] — user
GO

ALTER DATABASE My-Database SET TRUSTWORTHY ON
GO
sp_configure ‘clr enabled’, 1
GO
reconfigure

Advertisements


Leave a comment

Clearing up space on your web-server

When you have tons of virtual directories and multiple deployments that has happened on your web-server. The files are compiled and cached under “C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files\…

Removing files from the above folder saves a lot of space

They are safe to be removed, below are a couple of blog posts for reference.

http://stackoverflow.com/questions/586790/eliminating-temporary-asp-net-files

And also they explain how we can change the location of the temp folder to a different drive ( I have not done this because by just deleting some temp files I was able to reclaim around 1GB space)

How to do it http://blog.cwa.me.uk/2007/10/15/relocating-temporary-aspnet-files/


Leave a comment

Debug Windows Services

Below code helps to convert a windows service to a Console app and debug easily.
(Console App/Windows Service)
 static void Main()
        {
            MyService svc = new MyService();

            if (Environment.UserInteractive)
            {
                svc.StartProcessThread();
                Console.WriteLine("Press any key to stop program");
                Console.Read();
                svc.OnStop();
            }
            else
            {
                ServiceBase.Run(svc);
            }

        }

.csharpcode, .csharpcode pre
{
font-size: small;
color: black;
font-family: consolas, “Courier New”, courier, monospace;
background-color: #ffffff;
/*white-space: pre;*/
}
.csharpcode pre { margin: 0em; }
.csharpcode .rem { color: #008000; }
.csharpcode .kwrd { color: #0000ff; }
.csharpcode .str { color: #006080; }
.csharpcode .op { color: #0000c0; }
.csharpcode .preproc { color: #cc6633; }
.csharpcode .asp { background-color: #ffff00; }
.csharpcode .html { color: #800000; }
.csharpcode .attr { color: #ff0000; }
.csharpcode .alt
{
background-color: #f4f4f4;
width: 100%;
margin: 0em;
}
.csharpcode .lnum { color: #606060; }