Nancy is for my Mom's best friend and my middle name (which I never tell anyone) is my maternal Grandmother's middle name. My Mother has her Grandmother's middle name and wanted to carry on the tradition.
My kids are Jessica & Jeffrey. I gave Jessica my Mom's middle name (which is Nevada, and she loves it..thank goodness!) My son's middle names are William George which are both his Grandfather's first names.
My husband is Leslie and he absolutely refused when I wanted to name our son after him. Being mistaken for a girl got pretty frustrating I suppose.