Although Dean was originally going to have a tattoo - as seen in this behind the scenes in Phantom Traveler - it was in season Three that both Sam and Dean got tattoos.
FFN: Those matching tattoos are pretty cool. How long has that been planned?
SG: I remember talking about it with Ben Edlund last season, while Cat was writing "Born Under A Bad Sign." We agreed that if we were Sam, the first thing we'd do is take that anti-possession amulet and head for the nearest tattoo parlor. He reminded me of it while we were working on “Jus In Bello,” because breaking out the amulets was an important story point in that episode. So I stuck it in there, and it made for a nice moment. It’s like, of course Sam and Dean have matching tats. How could it be any other way? By the way, I'll be convinced we're truly a cult hit when a fan gets the same tattoo.
Little did Sera know, that fans had been getting tattoos since early on in the Show's run.
- see Fan Tattoos
In 4.18 The Monster At The End Of This Book, this phenomenom is referred to when Sam and Dean reveal their tattoos in order to pass as avid fans. In response the publisher of the "Supernatural" books by Chuck Shirley, reveals she has the same tattoo - on her ass. While not named in the episode, the publisher's name was Sera Seige, named after writers Julie Siege and Sera Gamble - as mentioned in this interview by Sera Gamble.
In 7.20 The Girl with the Dungeons and Dragons Tattoo Charlie reveals she has a Tattoo is of Princess Leia in her slave girl bikini astride a 20-sided dice (which are used in RPGs). In a scenario familiar to many fans, she claims she got it while drunk at Comic Con.
During the airing of the episode, the phrase #DandDtattoo trended on twitter source.