How to prevent memory leak in WCF

I have one WCF site that I’m managing and it started leaking memory, which ended up consuming up all server memory and stopped working. The change I made between the incident was that I changed from using service reference to using a class called WebServcieClinet that dynamically instantiating the web service connection. The reason why I introduced WebServiceClient… Continue reading How to prevent memory leak in WCF

SQL Server remote access

To make Sql Server to be accessed remotely, check the belows. 1. Use correct server name. The server name is machine name + instance name. e.g. My-PC\SQLExpress The server name shouldn’t start with ‘\\’ 2. Tick Allow remote connection to this server from the tab Connection of Server Property from SQL Server Management Studio. 3. Enable TCP/IP… Continue reading SQL Server remote access

DateTime time zone conversion in .Net / C#

Converting time zone sometimes can be tricky. If we understand a few basic facts around time zone and knows the how to use it, it turns out relatively easy. Basics of Time Zone There are 3 concepts to know clearly about time zones. UTC (Coordinated Universal Time) : Standard time zone. When it comes to the… Continue reading DateTime time zone conversion in .Net / C#