Category Archives: Uncategorized

String split using full text indexes

Recently I needed a way to extract keywords from email messages in order to create a list of noise words for a spam filter as well as implement an auto complete kind of option for the search box. The first option that came to mind was to use Term extraction in a SSIS package. The… Read More »

An interesting conversation with Google Assistant

If you have read my previous posts you know that I have an interest in AI and machine learning. Recently my phone was updated to include Google Assistant. For those using the iPhone Google Assistant is the Android version of Siri and supposedly smarter at doing things for you. While I have already been using… Read More »

Set based vs row by row (procedural code)

I was reading a blog about how to write procedural code today ( link below) and wanted to take a moment to explore another approach just to provide a more complete reference. To provide some context I am explaining the business case here. A hospital wants to identify people whose heights have changed over time… Read More »

Why Donald Trump deserves a chance

First off, I have never commented on politics even though I feel strongly about it. Mostly because I believe everybody is entitled to their own opinion and a true democracy is one where everyone has a voice and that voice isn’t being suppressed. Like most people I was fairly sure Hillary Clinton would win the… Read More »

Pushing till we get there

I am a very difficult boss to work with. Before I carry on I want to explain that I don’t derive any pleasure from it; it’s just something that’s worked for me. A few days back I was watching a documentary on the training of Special Forces in the Indian Army and the end of… Read More »

Waging war against India Standard Time

If you’re an Indian you already know what I mean when I say India Standard Time. It’s the unique time zone that adds an additional 30 min to 1 hour to any time that was previously agreed upon. This UIST (unofficial IST) has been a part of Indian life since childhood. Waiting for buses that… Read More »

Downloading training material

We provide access to training materials via AWS S3 access, this requires a few additional steps compared to FTP sites but provides must faster , frequent and secure access. This shift from FTP to AWS was performed keeping in mind that most of our participants have bandwidth constraints and are not familiar with FTP access… Read More »