Author Archive

8 Nov 2013

Experience with MS SQL Server

After years of experience with SQL server, I have gathered some of the practices that are good for writing SQL queries, procedures and functions. Here is my work as presentation, enjoy!! Sql good practices from Deepak Mehtani
8 Oct 2013

Amazing Video

I found this video on You tube. Make sure you watch it on HD mode on YouTube.
2 Oct 2013

SQL Server Fun – Averages with Rollup

Here is tsql way of getting averages and also rolling up. Below example is using adventureworks database that is available with SQL server. It is getting average pay rate by each department and also overall by the
30 Sep 2013

My PMI 2013 conference experience – Healthcare in India

I recently attended the PMI 2013 National Conference hosted at “The Leela” Gurgaon. It was indeed a grand event that I enjoyed thoroughly. I was particularly intrigued by the presentation in the field of Healthcare in India
25 Sep 2013

Brain teaser series….Candy Jar

Find the right candy jar… Who does not love candy? I always loved those colorful candies but I liked that one colored candy. Now I got red candy and blue candy but I like to get the
24 Sep 2013

Business Intelligence (BI)

What is business Intelligence I am sure a lot of people can define business intelligence but what we need to know is how it applies to us our business, our life and things we do. Over the
21 Sep 2013

How to get Windows Folder sizes recursively

Ever need to know the folder sizes that has several sub-folders, windows explorer takes really long time and requires checking properties of each folder. This script will do the job just need excel installed on your machine
21 Sep 2013

SQL Server FUN – Split received string using XML

Several time, we have a need to split the string based on a delimiter, for instance to handle multiple input filter parameters etc. Most of the time we end up using a user defined function that accepts
21 Sep 2013

SQL Server FUN – Identity insert

Insert in identity column for a table Sometimes there is a need to insert data into a table that has identity column. Example when you would like to restore a table from a backup including the same
21 Sep 2013

One of the all time technology world buzz word – “Lean”

I decided to find it little more about it. A new term has been coined, Lean software development. Well the work and definition below is from various sites and sources on internet. I would like to thank them