Software Related Blogs

While recently implementing SQL Always Encrypted feature I encountered a problem. The column that has been encrypted cannot be used with certain operators(RIGHT/LEFT/LIKE and etc). What I did for this is created a SQL/CLR method and passed ID as parameter, this method then queries the table again and decrypts the value if there is valid certificate on the server where this method is being executed. [ SqlFunction (SystemDataAccess = SystemDataAccessKind .Read, DataAccess = DataAccessKind .Read)]     public static string GetDecryptedValueByID( int ? id)     {        if (id == null ) return null ;        using ( SqlConnection conn = new SqlConnection ( "context connection=true" ))         {             conn.Open();             SqlCommand cmd = new SqlCommand ( "SELECT Column from Table where ID =" + id.ToString() " , conn);             SqlDataReader reader = cmd.ExecuteReader();             while (reader.Read())           

Hashing is key to BlockChain as it generates a unique number for the content in question. One you have know hash of any text/file you can verify whether content has changed or not, because slightest of change will change the hash and hash generated for verification will not match with hash of original content.   After stipulated time all the transaction recorded will be converted into a block which will contain transaction and hash of the transaction . Hence if someone tries to change any transaction hashkey will not match. First created block is called Genesis block which will not have address to previous block, anyblock created after first block will point to block after/before block and all blocks backward lead to genesis block.  Centralised ledger is notion for centralised database/controlling authority, in this practice if controlling authority goes out of business everyone suffers, also issuing authority can do frauds as no one verifies what they are doing. Centra

Business is about offering Product/Service and customer is heart of the business. Any business cannot exist without its customer, hence it becomes of utmost importance to keep the customer happy. What you do to start a business and keep it going:- Get new customer/acquire new customer. Enhance relationship with existing customer. Retain customer so that you have increased customer base. Now lets say you have started a business to sell musical instrument, and you have big names endorsing your brand. Your brand is gaining popularity and everyone is considering your product along with other supplier/companies. Now if you have CRM, you can simply import existing customer data and sync all the leads in sync with the system. For new/potential customers :- Call/text/email  customers telling them more about the product and help them buy(Sell your product or service). If customers are considering to buy at sometime, you can arrange email/call reminders. Send them promotion