Posts

What Interview Is/Is Not for an interviewer

After spending more than decade and having participated in hundreds of interviews, following is my list of what interview "Is" and "Is Not" from interviewers stand point. Interview Is:- Opportunity to meet someone with a set of experience in which they have learned their own ways of doing things and may help you learn something new. To learn what worked for them and what didn't, also the reason why it was success or failure for them. Which provides you free knowledge which can help you avoid your next failure and probably this is not documented and you would have failed. To help build a better work force, so energy invested today in interviewing will save you a lot in future. Interview Is Not:- To ask questions which may not be needed for the role. To ask questions which you can't answer yourself, In doing so you will never know if the person is right/wrong. You can ask such questions to see if they bluff or become impatient but not to test t

Cookieless Session

Introduction There are various reasons to adopt cookieless session. Recently, I implemented cookieless session and in that process, I went through many articles on the internet, but none of them have gone in depth to bring it all together. To implement cookieless sessions, you don't have to modify your programming model—a simple change in the  web.config  file does the trick. But with that can come uncovered scenario and you would end up spending considerable time fixing it up just like I did. So let's get started with what and how it has to be changed to make cookieless work for you with no issues. Now let us go through the steps one by one: Step 1: Adjust the web.config file Interestingly enough, you don't have to change anything in your ASP.NET application to enable cookieless sessions, except the following configuration setting. < sessionState cookieless ="true" />                     < authentication mode ="Forms">   

Query Column With Always Encryption

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())           

Block Chain

Image
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

Why is CRM important

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