Posts

Showing posts from 2017

Command to find the proxy server of the system (Windows)

Windows Command to find the proxy server of the system: reg query "HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Internet Settings" | find /i "proxyserver"

Root and Install Custom ROM on Samsung Galaxy Grand Duos

Root and Install Custom ROM on Samsung Galaxy Grand Duos: Install Samsung Drivers on the PC. Install Odin for Windows. Download CWM touch for Custom Recovery. Flash this with Odin with Auto Reboot unchecked. Boot into the Recovery mode and install whatever ROM you like. Reference: https://www.youtube.com/watch?v=ABzbBW4usho&spfreload=5 http://www.droidviews.com/best-custom-roms-for-samsung-galaxy-grand-duos-gt-i9082/ https://forum.xda-developers.com/galaxy-grand-duos/development/android-7-1-1-lineageos-rr-n-v5-8-0-t3537748 Comment if you need more help...Happy modding...

How to Encrypt and Decrypt in SQL Server with Certificate

How to Encrypt and Decrypt in SQL Server with Certificate: While using the sensitive data in applications, we need to encrypt it whenever we are storing in the database tables. For this purpose, we usually use the asymmetric keys with certificate. The process is descriped as below... First, we need to create as master key with a password. Later, we need to create a certificate with Subject Name and Expiry Date. Later, we need to create a symmetric key with a algorithm by making use of the certificate. CREATE MASTER KEY ENCRYPTION BY PASSWORD = 'p@ssw0rd' CREATE CERTIFICATE MyCertCert WITH SUBJECT = 'MyTestCert', EXPIRY_DATE = '10/31/2018' CREATE SYMMETRIC KEY MySymKey WITH ALGORITHM = TRIPLE_DES ENCRYPTION BY CERTIFICATE MyCertCert Once the key is created with the certificate, you can see your certificate by making use of the below query. SELECT * FROM sys.certificates Later you can use the below SQL Statements to encrypt or decrypt the cont