Monthly Archives: June 2015

Quick File Compare tool (vim)

Yesterday, one of my developer modified huge script file but he used old version to modify. It was uphill task to understand the changes and correct it. I am not keen on any installations or add-in… vim (one of my … Continue reading

Posted in knowledge, Productivity, Windows Server | Tagged , , , | Leave a comment

SQL Query to find employees with X Consecutive A Grades

One of my friend (Satya) asked a very interesting interview question during the Lunch today. Question is to write a SQL Query to find the employees who received Grade ‘A’ for 3 consecutive years. Self-join is the simple answer to … Continue reading

Posted in Productivity, SQL Query, SQL Server | Tagged , , , , , , | Leave a comment

SSIS – MERGE JOIN with OR condition

Do you know if there is any option to implement OR condition with Merge Join in SSIS? NO, there is no such option (Let me know if there is a way and I am not aware of it)! Recently I … Continue reading

Posted in knowledge, Productivity, SQL Query, SQL Server, SSIS | Tagged , , | Leave a comment

Avoid Blunders with SQL Query execution – Check where you are running the script

For a second, I thought I am running database restore script on my Production environment! Boom… &^%#*)! Just a check confirms I am running it on Dev environment as expected, I am relieved. But it made me to think how … Continue reading

Posted in Productivity, Script, SQL, SQL Server | Tagged , , , | Leave a comment