Articles by Sushanta Pokharel

The Carenet Extended Team

Posted by on

Throughout my career I have been a part of different IT offshore businesses at different levels and I have found the field to be very challenging. Challenging because of the immaturity of the IT field, geographical separation and cultural differences rather than the novelty of the model itself.

  • Read More
  • Read More

SQL Query Optimization (Part 1) – Introduction To Execution Plans and Indexes

Posted by on

As xxdata engineers, our work time is mostly consumed with writing queries that produce the desired output or with designing systems that can properly capture the required data. However, we frequently run across situations where we also need to optimize our queries for efficiency. As entry level data engineers, (or even when we have gained much experience) we might tend to believe that all queries that produce equal output must be equivalent in resource consumption. This is a misconception most of us learn the hard way.

  • Read More

Introduction to Non-Relational Data Storage using Hbase

Posted by on

Big Talk About BigTable

Relational Databases have hegemony on the way data has been stored. Proponents of Relational Database emphasize on normalization for valid reasons. Maintainability, Integrity (summed up in ACID) and Security has been the primary focus of classical relational database problems. Backed by Moore’s law it was easy to theorize that processing speed would inevitably be a trivial factor over other engineering problems like consistency and integrity. In some sense that is true but hitherto unaccounted for were sites like Google and Facebook which needed to process PetaBytes of data every second in real time.

  • Read More
  • Read More

Deploying Custom Forms to Microsoft Office SharePoint Server

Posted by on

Applications need to collect data from users. SharePoint emphasizes ease of use for non technical users while providing a comprehensive API for programmers. This means a diversity of techniques that demand different levels of technical complexity and flexibility for design of forms. This article aims to introduce some of these techniques and evaluate them on different aspects like ease of deployment, security etc.

  • Read More

Deerwalk Picnic at Lakure Bhanjyang, A Memoir

Posted by on

For an urbanite like me who immediately reaches for his phone after hearing a tweet, 27 November 2010 was a welcome change. This day, we at Deerwalk went picnicking near Lakure Bhanjyang. And there, when we heard tweets we looked towards the trees. We were a wild bunch with only one thing on our minds, “to have fun”, and we got more than what we had expected.

  • Read More