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

Encrytion using GPG – command line example for automation

This is the GPG command line example to be used inside of automation as C# console application. This encryption/decryption will only use the password. Encrypt Basic format gpg -o outputPath –cipher-algo AES256 –symmetric sourcePath Example to be used inside of automation echo letmeinPetbarn | gpg –batch –passphrase-fd 0 -o D:\Automations\Petbarn\EMListExtractAndFTP\DataOut\petbarn.csv.gpg –cipher-algo AES256 –symmetric D:\Automations\Petbarn\EMListExtractAndFTP\DataOut\petbarn.csv Decrypt… Continue reading Encrytion using GPG – command line example for automation