I've never met anyone with a fantasy and D&D inspired name and I'm not likely to settle down get married and have kids. When I was younger we had several cats. One I named Prowl, because of the Transformer. Another I named Tattenger, from a TV show I don't even remember.
I've taken first and last names from people I've known and turned them into either place name locations or NPC names. I knew an "Erin" once who's name became that of a evil enchantress.
I knew someone named "Carla" who's name got converted & morphed to a city name - Aarlan.
I knew someone with the last name "Tschaja", which bacame a city name.
I named a city "Gillian" after the actress from X-Files.
I named a NPC "Morgan" inspired from a character on a Canadian TV show called Radio Active.
I used the name "Onaway" for a major city. It's the name of a small rural town here in Alberta.
I've integrated the old EN World City Project into my campaign. The city's name - "Mor's End" - is named after Morrus.
The continent of Janardun is named after the Canadian singer Jann Arden. (I was into her music for a while and the name stuck.)
As I've gotten older, I've done this less and less. However, a good resource for names are old year books from college. Browsing through my GMMC year book from 1994 has inspired certain names for locales on my homebrewed world. I tend to use those from other programs more. It doesn't feel as silly that way.
I also named a couple of NPCs "Ahdina" and "Loghan" after a couple I knew, at my second go around at colllege, named Adina and Logan. They are the queen and king of a major country on my homebrew.
Of course, I've borrowed other character names from other campaigns I've played in and read about (on EN World).
And last, but not least, one of my players named his skyrider paladin, "Mojo Rising". I kid you not.
Cheers!
KF72