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#
Author: rocker8942
How to throttle a section in WCF
If a WCF service internally connected to a legacy system which does not support multi threading, the WCF needs to be throttled. The easiest way to achieve this is to make the WCF works sequentially by setting this up not to work concurrently. By default, a WCF configured to process in multiple instances and concurrency… Continue reading How to throttle a section in WCF
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
Useful command of MSSQL Query when comparing and manipulating text data
Extract table from another table SELECT * FROM dbo.SFG_Event_21_22 except SELECT * FROM dbo.SFG_Event_21 Bulk insert BULK insert dbo.SFG_Event_21_22 from ‘C:\Users\joemac\Desktop\final.csv’ WITH ( firstrow = 1, fieldterminator = ‘,’, rowterminator = ‘0x0a’ ); GO bulk insert cannot understand text qualifier bulk insert add NULL for blank data by default Replace string value of a column… Continue reading Useful command of MSSQL Query when comparing and manipulating text data
PC Utility
CPU Temperature Check, Core Temp – Small and do the job. Disk Clean up, Directory Stat, WinDirStat – Very useful figuring out what’s consuming most of disk space. and then clean up based on the result. May take some time to read all the files and directories. Ultimate pc utility 2014 by Scott Hanselman